Syncs / sessions_to_pg

sessions_to_pg

Session rollups keyed by user.

analytics

Last run

2026-07-09T22:10:30Z · success

940 rows

Configuration

source: bq_prod · mode: incremental

→ postgres (public.sessions)

Definition

      syncs/sessions_to_pg.yml
      YAML · 18 lines
      
    
name: sessions_to_pg
description: "Session rollups keyed by user."
tags: [analytics]
model: ref('session_rollups')
destination:
  type: postgres
  host_env: DEMO_PG_HOST
  dbname: acme_app
  table: public.sessions
  upsert_key: [session_id]
  lookups:
    user:
      table: public.users
      match: { user_id: id }
      check_only: true
sync:
  mode: incremental
  cursor_field: started_at

Lineage

Reads bq_prod + postgres (public.users) (lookup) · writes postgres (public.sessions).

State

last_sync_at	2026-07-09T22:10:30Z
last_cursor_value	2026-07-09T22:00:00Z
rows_synced	940
last_status	success
last_error	—