ETL Debug

Latest ETL Run: 20260311053932 | Status: SUCCESS

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

{"summary": {"total_tables": 9, "loaded_tables": 9, "failed_tables": 0, "loaded_rows": 113}, "counts": {"raw_server1.campaign_fieldrep": 15, "raw_server1.campaign_campaignfieldrep": 24, "raw_server1.campaign_campaign": 13, "raw_server2.campaign_management_campaign": 5, "raw_server2.collateral_management_campaigncollateral": 6, "raw_server2.collateral_management_collateral": 6, "raw_server2.sharing_management_sharelog": 14, "raw_server2.sharing_management_collateraltransaction": 11, "raw_server2.doctor_viewer_doctor": 19}, "errors": {}}

Gold campaign schemas: 13

Schema: raw_server1

Table	Exists	Row Count	Error
campaign_fieldrep	Yes	225	-
campaign_campaignfieldrep	Yes	870	-
campaign_campaign	Yes	537	-

Schema: raw_server2

Table	Exists	Row Count	Error
campaign_management_campaign	Yes	208	-
collateral_management_campaigncollateral	Yes	227	-
collateral_management_collateral	Yes	227	-
sharing_management_sharelog	Yes	435	-
sharing_management_collateraltransaction	Yes	426	-
doctor_viewer_doctor	Yes	661	-

Schema: bronze

Table	Exists	Row Count	Error
campaign_fieldrep	Yes	15	-
campaign_campaignfieldrep	Yes	25	-
campaign_campaign	Yes	13	-
campaign_management_campaign	Yes	5	-
collateral_management_campaigncollateral	Yes	6	-
collateral_management_collateral	Yes	6	-
sharing_management_sharelog	Yes	14	-
sharing_management_collateraltransaction	Yes	11	-
doctor_viewer_doctor	Yes	19	-

Schema: silver

Table	Exists	Row Count	Error
dim_field_rep	Yes	28	-
dim_doctor	Yes	19	-
dim_collateral	Yes	6	-
bridge_campaign_collateral_schedule	Yes	6	-
fact_collateral_transaction	Yes	11	-
map_brand_campaign_to_campaign	Yes	13	-
bridge_brand_campaign_doctor_base	Yes	23	-
doctor_action_first_seen	Yes	25	-

Schema: gold_global

Table	Exists	Row Count	Error
campaign_registry	Yes	13	-
campaign_health_history	Yes	57	-
benchmark_last_10_campaigns	Yes	1	-

Schema: control

Table	Exists	Row Count	Error
etl_run_log	Yes	64	-

Per-Campaign GOLD Schemas

gold_campaign_c_01b05f26_3a14_43d4_8f6b_d1519a4bae9c

Table	Exists	Row Count	Error
fact_doctor_collateral_latest	Yes	6	-
kpi_weekly_summary	Yes	4	-
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	Row Count	Error
fact_doctor_collateral_latest	Yes	1	-
kpi_weekly_summary	Yes	5	-
weekly_action_items	Yes	0	-

gold_campaign_c_1c17550b_e003_4449_a64e_a28ff312ac26

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

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_3

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

gold_campaign_c_3df8f676_ec6b_4a79_8e84_f60a18e3138b

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

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_6

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

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_9

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

gold_campaign_f7261e2e_177c_41a8_9ccc_f8cf38426be4

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

ETL Debug Snapshot