Legacy Pipeline Atlas worker-1snapshot 2026-07-15

sub-job

Commonwealth · Cutover-Load-Custom-Properties

We'll be moving the logic of this custom property load to dagster to make a custom property asset. We'll sync that table to a staging table and load the precomputed values instead

called by Cutover-Load-Account-Data

sub-job Commonwealth/Cutover-Load-Custom-Properties · db Commonwealth_ProdMirror · updated 2026-05-22

task tree

What the sub-job runs

Tasks in order, each with what it does — typed stepsfrom the MDClarity task docs (click to open the reference), sub-jobsyou can expand inline (▶) to reveal their own tasks, and SQL steps summarized by Gemini (✨). Every step shows the tables it writes/reads and which earlier step it feeds from(sqlglot lineage).

sub-job

Cutover-Load-Custom-Properties

2 tasks · Commonwealth
sub-job / Flow action SQL / native step▶ expand a sub-job inline · ↗ open it as its own page · a typed step opens its doc
  1. Load Claim ID Custom PropertyUpdateCustomPropertyFromQuery
    · reads StagingAccountStagingAccountChargeStagingAccountInsuranceStagingAccountRemitStagingCustomPropertyMember
    entity=Accountcustom property key=CustomProperty-[id]auto querybatch mode
  2. SyncBatchSyncBatch
    Synchronizes processed data from batch staging tables to production tables, updating visits, quotes, and custom property mappings.
    writes CustomPropertyMap · reads CustomPropertyMapBatch
    sync custom property map