ETL Debug

Latest ETL Run: 20260509223003 | Status: SUCCESS

Source tables: total=9, loaded=9, failed=0, rows=4263

{"summary": {"total_tables": 9, "loaded_tables": 9, "failed_tables": 0, "loaded_rows": 4263}, "counts": {"raw_server1.campaign_fieldrep": 498, "raw_server1.campaign_campaignfieldrep": 695, "raw_server1.campaign_campaign": 5, "raw_server2.campaign_management_campaign": 16, "raw_server2.collateral_management_campaigncollateral": 20, "raw_server2.collateral_management_collateral": 20, "raw_server2.sharing_management_sharelog": 39, "raw_server2.sharing_management_collateraltransaction": 56, "raw_server2.doctor_viewer_doctor": 2914}, "errors": {}}

Gold campaign schemas: 24

Schema: raw_server1

Table	Exists	Row Count	Error
campaign_fieldrep	Yes	5964	-
campaign_campaignfieldrep	Yes	13052	-
campaign_campaign	Yes	109	-

Schema: raw_server2

Table	Exists	Row Count	Error
campaign_management_campaign	Yes	183	-
collateral_management_campaigncollateral	Yes	184	-
collateral_management_collateral	Yes	184	-
sharing_management_sharelog	Yes	368	-
sharing_management_collateraltransaction	Yes	197	-
doctor_viewer_doctor	Yes	117498	-

Schema: bronze

Table	Exists	Row Count	Error
campaign_fieldrep	Yes	500	-
campaign_campaignfieldrep	Yes	950	-
campaign_campaign	Yes	10	-
campaign_management_campaign	Yes	16	-
collateral_management_campaigncollateral	Yes	20	-
collateral_management_collateral	Yes	20	-
sharing_management_sharelog	Yes	39	-
sharing_management_collateraltransaction	Yes	67	-
doctor_viewer_doctor	Yes	2914	-

Schema: silver

Table	Exists	Row Count	Error
dim_field_rep	Yes	896	-
dim_doctor	Yes	2914	-
dim_collateral	Yes	20	-
bridge_campaign_collateral_schedule	Yes	20	-
fact_collateral_transaction	Yes	67	-
map_brand_campaign_to_campaign	Yes	21	-
bridge_brand_campaign_doctor_base	Yes	41	-
doctor_action_first_seen	Yes	46	-

Schema: gold_global

Table	Exists	Row Count	Error
campaign_registry	Yes	17	-
campaign_health_history	Yes	137	-
benchmark_last_10_campaigns	Yes	1	-

Schema: control

Table	Exists	Row Count	Error
etl_run_log	Yes	123	-

Per-Campaign GOLD Schemas

gold_campaign_c_01b05f26_3a14_43d4_8f6b_d1519a4bae9c

Table	Exists	Row Count	Error
fact_doctor_collateral_latest	Yes	1	-
kpi_weekly_summary	Yes	4	-
weekly_action_items	Yes	0	-

gold_campaign_c_1151a492947b4c9183ac5a224b2d07b1

Table	Exists	Row Count	Error
fact_doctor_collateral_latest	Yes	2	-
kpi_weekly_summary	Yes	5	-
weekly_action_items	Yes	0	-

gold_campaign_c_12

Table	Exists	Row Count	Error
fact_doctor_collateral_latest	Yes	1	-
kpi_weekly_summary	Yes	5	-
weekly_action_items	Yes	0	-

gold_campaign_c_13

Table	Exists	Row Count	Error
fact_doctor_collateral_latest	Yes	1	-
kpi_weekly_summary	Yes	5	-
weekly_action_items	Yes	0	-

gold_campaign_c_14

Table	Exists	Error
fact_doctor_collateral_latest	Yes	-
kpi_weekly_summary	Yes	-
weekly_action_items	Yes	-

gold_campaign_c_162

Table	Exists	Row Count	Error
fact_doctor_collateral_latest	Yes	2	-
kpi_weekly_summary	Yes	5	-
weekly_action_items	Yes	0	-

gold_campaign_c_1c17550b_e003_4449_a64e_a28ff312ac26

Table	Exists	Error
fact_doctor_collateral_latest	Yes	-
kpi_weekly_summary	Yes	-
weekly_action_items	Yes	-

gold_campaign_c_2

Table	Exists	Row Count	Error
fact_doctor_collateral_latest	Yes	1	-
kpi_weekly_summary	Yes	4	-
weekly_action_items	Yes	0	-

gold_campaign_c_28c37765_3ec0_4554_a377_b8a93460b109

Table	Exists	Row Count	Error
fact_doctor_collateral_latest	Yes	1	-
kpi_weekly_summary	Yes	5	-
weekly_action_items	Yes	0	-

gold_campaign_c_3

Table	Exists	Error
fact_doctor_collateral_latest	Yes	-
kpi_weekly_summary	Yes	-
weekly_action_items	Yes	-

gold_campaign_c_3a1f3b3f046449a9abbe84a348869a91

Table	Exists	Row Count	Error
fact_doctor_collateral_latest	Yes	10	-
kpi_weekly_summary	Yes	5	-
weekly_action_items	Yes	0	-

gold_campaign_c_3df8f676_ec6b_4a79_8e84_f60a18e3138b

Table	Exists	Error
fact_doctor_collateral_latest	Yes	-
kpi_weekly_summary	Yes	-
weekly_action_items	Yes	-

gold_campaign_c_4

Table	Exists	Row Count	Error
fact_doctor_collateral_latest	Yes	1	-
kpi_weekly_summary	Yes	4	-
weekly_action_items	Yes	0	-

gold_campaign_c_4025e9dbbcb645bfa3e43df06bf213d2

Table	Exists	Row Count	Error
fact_doctor_collateral_latest	Yes	2	-
kpi_weekly_summary	Yes	5	-
weekly_action_items	Yes	0	-

gold_campaign_c_599a20233ab94227b82c5f0a1bc36579

Table	Exists	Row Count	Error
fact_doctor_collateral_latest	Yes	6	-
kpi_weekly_summary	Yes	5	-
weekly_action_items	Yes	0	-

gold_campaign_c_6

Table	Exists	Error
fact_doctor_collateral_latest	Yes	-
kpi_weekly_summary	Yes	-
weekly_action_items	Yes	-

gold_campaign_c_7

Table	Exists	Row Count	Error
fact_doctor_collateral_latest	Yes	1	-
kpi_weekly_summary	Yes	4	-
weekly_action_items	Yes	0	-

gold_campaign_c_8021a389_3201_4986_bd9b_f6431f12d421

Table	Exists	Row Count	Error
fact_doctor_collateral_latest	Yes	1	-
kpi_weekly_summary	Yes	5	-
weekly_action_items	Yes	0	-

gold_campaign_c_82

Table	Exists	Row Count	Error
fact_doctor_collateral_latest	Yes	2	-
kpi_weekly_summary	Yes	5	-
weekly_action_items	Yes	0	-

gold_campaign_c_83ce7fc7_c965_433a_b2b9_717394abe3c1

Table	Exists	Row Count	Error
fact_doctor_collateral_latest	Yes	3	-
kpi_weekly_summary	Yes	5	-
weekly_action_items	Yes	0	-

gold_campaign_c_83ce7fc7c965433ab2b9717394abe3c1

Table	Exists	Row Count	Error
fact_doctor_collateral_latest	Yes	3	-
kpi_weekly_summary	Yes	5	-
weekly_action_items	Yes	0	-

gold_campaign_c_9

Table	Exists	Error
fact_doctor_collateral_latest	Yes	-
kpi_weekly_summary	Yes	-
weekly_action_items	Yes	-

gold_campaign_f3337814_79d2_48ce_af01_b9e20849de77

Table	Exists	Row Count	Error
fact_doctor_collateral_latest	Yes	1	-
kpi_weekly_summary	Yes	5	-
weekly_action_items	Yes	0	-

gold_campaign_f7261e2e_177c_41a8_9ccc_f8cf38426be4

Table	Exists	Error
fact_doctor_collateral_latest	Yes	-
kpi_weekly_summary	Yes	-
weekly_action_items	Yes	-

ETL Debug Snapshot