Syncs / users_to_pg

users_to_pg

Mirror warehouse users into the app database.

core pii

Last run

2026-07-09T23:55:12Z · success

1248 rows

Configuration

source: bq_prod · mode: incremental

→ postgres (public.users)

Definition

      syncs/users_to_pg.yml
      YAML · 18 lines
      
    
# drt docs: inline secrets / PII masked — prefer *_env references
name: users_to_pg
description: "Mirror warehouse users into the app database."
tags: [core, pii]
model: |
  SELECT id, name, email, created_at
  FROM {{ ref('users') }}
destination:
  type: postgres
  host_env: DEMO_PG_HOST
  dbname: acme_app
  table: public.users
  upsert_key: [id]
sync:
  mode: incremental
  cursor_field: created_at
  mask:
    email: '« redacted »'

Lineage

Reads bq_prod · writes postgres (public.users) · read by orders_to_pg, sessions_to_pg.

State

last_sync_at	2026-07-09T23:55:12Z
last_cursor_value	2026-07-09T23:50:00Z
rows_synced	1248
last_status	success
last_error	—