{"runs":[{"run_id":"run-99a7933c1ba5","started_at":"2026-08-27T23:45:12.394428+00:00","finished_at":"2026-08-27T23:46:41.500015+00:00","failure":{"scheduler":"demo","model_name":"dim_customers","run_id":"run-99a7933c1ba5","error":"POST https://bigquery.googleapis.com/bigquery/v2/projects/dm-agentic-hackathon-2026/jobs?prettyPrint=false: Name customer_id not found inside c at [16:22]\n\nLocation: US\nJob ID: 72cf5a52-cedd-4797-82fc-72dfc580944b\n"},"result":{"tool_calls":6,"validated":true,"confidence":"high","pr_url":"https://github.com/damowdhar/pipeline-medic/pull/5","run_id":"run-99a7933c1ba5","model_name":"dim_customers","explanation":"Updated references from c.customer_id to c.cust_id in the SELECT list, JOIN condition, and GROUP BY clause to match the upstream raw_customers schema while keeping customer_id as the output column alias.","fixed_sql":"SELECT\n    c.cust_id                            AS customer_id,\n    c.full_name                          AS customer_name,\n    c.signup_date                        AS signup_date,\n    COUNT(o.order_id)                    AS lifetime_orders,\n    COALESCE(SUM(o.amount), 0)           AS lifetime_value,\n    MAX(o.ordered_on)                    AS last_order_date\nFROM `medic_demo.raw_customers` AS c\nLEFT JOIN `medic_demo.raw_orders` AS o\n    ON o.cust_id = c.cust_id\nGROUP BY\n    c.cust_id,\n    c.full_name,\n    c.signup_date","dry_run_attempts":1,"root_cause":"The upstream table raw_customers renamed the customer_id column to cust_id, causing references to c.customer_id to fail."},"status":"fixed"},{"run_id":"run-e4094be82813","started_at":"2026-08-27T23:40:44.144013+00:00","finished_at":"2026-08-27T23:44:08.700896+00:00","failure":{"scheduler":"demo","model_name":"dim_customers","run_id":"run-e4094be82813","error":"POST https://bigquery.googleapis.com/bigquery/v2/projects/dm-agentic-hackathon-2026/jobs?prettyPrint=false: Name customer_id not found inside c at [16:22]\n\nLocation: US\nJob ID: ad0ceda6-1b2a-45b3-8c08-e47284905bc4\n"},"result":{"tool_calls":6,"validated":true,"confidence":"high","pr_url":"https://github.com/damowdhar/pipeline-medic/pull/4","run_id":"run-e4094be82813","model_name":"dim_customers","explanation":"Updated references from c.customer_id to c.cust_id in the SELECT clause, JOIN condition, and GROUP BY clause to match the upstream raw_customers schema while keeping customer_id as the downstream alias.","fixed_sql":"SELECT\n    c.cust_id                            AS customer_id,\n    c.full_name                          AS customer_name,\n    c.signup_date                        AS signup_date,\n    COUNT(o.order_id)                    AS lifetime_orders,\n    COALESCE(SUM(o.amount), 0)           AS lifetime_value,\n    MAX(o.ordered_on)                    AS last_order_date\nFROM `medic_demo.raw_customers` AS c\nLEFT JOIN `medic_demo.raw_orders` AS o\n    ON o.cust_id = c.cust_id\nGROUP BY\n    c.cust_id,\n    c.full_name,\n    c.signup_date","dry_run_attempts":1,"root_cause":"The upstream table raw_customers renamed the customer_id column to cust_id, causing queries referencing c.customer_id to fail."},"status":"fixed"},{"run_id":"run-verify-retry-01","started_at":"2026-08-27T23:17:02.892397+00:00","finished_at":"2026-08-27T23:20:38.165507+00:00","failure":{"run_id":"run-verify-retry-01","model_name":"dim_customers","scheduler":"demo","error":"Name customer_id not found inside c at [16:22]"},"result":{"tool_calls":6,"validated":true,"confidence":"high","pr_url":"https://github.com/damowdhar/pipeline-medic/pull/3","run_id":"run-verify-retry-01","model_name":"dim_customers","explanation":"Updated references from c.customer_id to c.cust_id in the SELECT list, JOIN condition, and GROUP BY clause to match the upstream raw_customers schema while preserving customer_id as the downstream column alias.","fixed_sql":"SELECT\n    c.cust_id                            AS customer_id,\n    c.full_name                          AS customer_name,\n    c.signup_date                        AS signup_date,\n    COUNT(o.order_id)                    AS lifetime_orders,\n    COALESCE(SUM(o.amount), 0)           AS lifetime_value,\n    MAX(o.ordered_on)                    AS last_order_date\nFROM `medic_demo.raw_customers` AS c\nLEFT JOIN `medic_demo.raw_orders` AS o\n    ON o.cust_id = c.cust_id\nGROUP BY\n    c.cust_id,\n    c.full_name,\n    c.signup_date","dry_run_attempts":1,"root_cause":"The upstream table raw_customers renamed the customer_id column to cust_id, causing references to c.customer_id to fail."},"status":"fixed"},{"run_id":"run-15ec22bb5bcc","started_at":"2026-08-27T23:06:54.544705+00:00","finished_at":"2026-08-27T23:09:22.416273+00:00","failure":{"scheduler":"demo","model_name":"dim_customers","run_id":"run-15ec22bb5bcc","error":"POST https://bigquery.googleapis.com/bigquery/v2/projects/dm-agentic-hackathon-2026/jobs?prettyPrint=false: Name customer_id not found inside c at [16:22]\n\nLocation: US\nJob ID: aeb9ed30-74a4-4019-bfb4-1186bb845bfb\n"},"result":{"error":"triage raised; see logs"},"status":"error"},{"run_id":"run-pr-demo-01","started_at":"2026-08-27T18:05:41.176297+00:00","finished_at":"2026-08-27T18:10:30.445445+00:00","failure":{"scheduler":"demo","model_name":"dim_customers","run_id":"run-pr-demo-01","error":"Name customer_id not found inside c at [16:22]"},"result":{"tool_calls":6,"validated":true,"confidence":"high","pr_url":"https://github.com/damowdhar/pipeline-medic/pull/2","run_id":"run-pr-demo-01","model_name":"dim_customers","explanation":"Updated references from c.customer_id to c.cust_id in the SELECT list, JOIN condition, and GROUP BY clause to match the upstream raw_customers table schema while preserving the output customer_id alias.","fixed_sql":"SELECT\n    c.cust_id                            AS customer_id,\n    c.full_name                          AS customer_name,\n    c.signup_date                        AS signup_date,\n    COUNT(o.order_id)                    AS lifetime_orders,\n    COALESCE(SUM(o.amount), 0)           AS lifetime_value,\n    MAX(o.ordered_on)                    AS last_order_date\nFROM `medic_demo.raw_customers` AS c\nLEFT JOIN `medic_demo.raw_orders` AS o\n    ON o.cust_id = c.cust_id\nGROUP BY\n    c.cust_id,\n    c.full_name,\n    c.signup_date","dry_run_attempts":1,"root_cause":"The upstream table raw_customers renamed the column customer_id to cust_id, causing queries referencing c.customer_id to fail."},"status":"fixed"},{"run_id":"run-fa3c696b46ce","started_at":"2026-08-27T17:57:47.366228+00:00","finished_at":"2026-08-27T17:58:17.176676+00:00","failure":{"scheduler":"demo","model_name":"dim_customers","run_id":"run-f4fae5fbefb1","error":"POST https://bigquery.googleapis.com/bigquery/v2/projects/dm-agentic-hackathon-2026/jobs?prettyPrint=false: Name customer_id not found inside c at [16:22]\n\nLocation: US\nJob ID: 64a2bd8a-b009-4507-8889-2654f106eb4f\n"},"result":{"tool_calls":6,"validated":true,"confidence":"high","pr_url":"https://github.com/damowdhar/pipeline-medic/pull/1","run_id":"run-fa3c696b46ce","model_name":"dim_customers","explanation":"Updated references from c.customer_id to c.cust_id in the SELECT, JOIN, and GROUP BY clauses to align with the current raw_customers table schema while maintaining customer_id as the downstream column alias.","fixed_sql":"SELECT\n    c.cust_id                            AS customer_id,\n    c.full_name                          AS customer_name,\n    c.signup_date                        AS signup_date,\n    COUNT(o.order_id)                    AS lifetime_orders,\n    COALESCE(SUM(o.amount), 0)           AS lifetime_value,\n    MAX(o.ordered_on)                    AS last_order_date\nFROM `medic_demo.raw_customers` AS c\nLEFT JOIN `medic_demo.raw_orders` AS o\n    ON o.cust_id = c.cust_id\nGROUP BY\n    c.cust_id,\n    c.full_name,\n    c.signup_date","dry_run_attempts":1,"root_cause":"The upstream raw_customers table renamed the customer_id column to cust_id, causing queries referencing c.customer_id to fail."},"status":"fixed"},{"run_id":"run-96f75f4febbb","started_at":"2026-08-27T17:36:14.841732+00:00","finished_at":"2026-08-27T17:38:24.743560+00:00","failure":{"run_id":"run-96f75f4febbb","model_name":"dim_customers","scheduler":"demo","error":"POST https://bigquery.googleapis.com/bigquery/v2/projects/dm-agentic-hackathon-2026/jobs?prettyPrint=false: Name customer_id not found inside c at [16:22]\n\nLocation: US\nJob ID: 84ebbd84-b5d9-435c-81fe-5d1374ed3aa4\n"},"result":{"tool_calls":5,"validated":true,"confidence":"high","run_id":"run-96f75f4febbb","model_name":"dim_customers","explanation":"Updated references from c.customer_id to c.cust_id in the SELECT, JOIN, and GROUP BY clauses to align with the current raw_customers schema while maintaining customer_id as the downstream column alias.","fixed_sql":"SELECT\n    c.cust_id                            AS customer_id,\n    c.full_name                          AS customer_name,\n    c.signup_date                        AS signup_date,\n    COUNT(o.order_id)                    AS lifetime_orders,\n    COALESCE(SUM(o.amount), 0)           AS lifetime_value,\n    MAX(o.ordered_on)                    AS last_order_date\nFROM `medic_demo.raw_customers` AS c\nLEFT JOIN `medic_demo.raw_orders` AS o\n    ON o.cust_id = c.cust_id\nGROUP BY\n    c.cust_id,\n    c.full_name,\n    c.signup_date","dry_run_attempts":1,"root_cause":"The upstream raw_customers table renamed the customer_id column to cust_id, causing references to c.customer_id to fail."},"status":"fixed"},{"run_id":"run-6c9462e2f1af","started_at":"2026-08-26T05:43:26.552053+00:00","finished_at":"2026-08-26T05:44:56.949964+00:00","failure":{"scheduler":"demo","model_name":"dim_customers","run_id":"run-6c9462e2f1af","error":"POST https://bigquery.googleapis.com/bigquery/v2/projects/dm-agentic-hackathon-2026/jobs?prettyPrint=false: Name customer_id not found inside c at [16:22]\n\nLocation: US\nJob ID: 246244f2-2dfd-4996-91e0-a0afe678120a\n"},"result":{"tool_calls":5,"validated":true,"confidence":"high","run_id":"run-6c9462e2f1af","model_name":"dim_customers","explanation":"Updated references from c.customer_id to c.cust_id in the SELECT clause, JOIN condition, and GROUP BY clause to match the upstream raw_customers schema while retaining customer_id as the output column alias.","fixed_sql":"SELECT\n    c.cust_id                            AS customer_id,\n    c.full_name                          AS customer_name,\n    c.signup_date                        AS signup_date,\n    COUNT(o.order_id)                    AS lifetime_orders,\n    COALESCE(SUM(o.amount), 0)           AS lifetime_value,\n    MAX(o.ordered_on)                    AS last_order_date\nFROM `medic_demo.raw_customers` AS c\nLEFT JOIN `medic_demo.raw_orders` AS o\n    ON o.cust_id = c.cust_id\nGROUP BY\n    c.cust_id,\n    c.full_name,\n    c.signup_date","dry_run_attempts":1,"root_cause":"The upstream table raw_customers renamed the customer_id column to cust_id, causing queries referencing c.customer_id to fail."},"status":"fixed"},{"run_id":"run-cloudrun-demo-02","started_at":"2026-08-26T05:24:17.837797+00:00","finished_at":"2026-08-26T05:26:11.505446+00:00","failure":{"run_id":"run-cloudrun-demo-02","model_name":"dim_customers","scheduler":"demo","error":"Name customer_id not found inside c at [16:22]"},"result":{"tool_calls":5,"validated":true,"confidence":"high","run_id":"run-cloudrun-demo-02","model_name":"dim_customers","explanation":"Updated references from c.customer_id to c.cust_id in the SELECT clause, JOIN condition, and GROUP BY clause to align with the raw_customers schema while keeping customer_id as the downstream alias.","fixed_sql":"SELECT\n    c.cust_id                            AS customer_id,\n    c.full_name                          AS customer_name,\n    c.signup_date                        AS signup_date,\n    COUNT(o.order_id)                    AS lifetime_orders,\n    COALESCE(SUM(o.amount), 0)           AS lifetime_value,\n    MAX(o.ordered_on)                    AS last_order_date\nFROM `medic_demo.raw_customers` AS c\nLEFT JOIN `medic_demo.raw_orders` AS o\n    ON o.cust_id = c.cust_id\nGROUP BY\n    c.cust_id,\n    c.full_name,\n    c.signup_date","dry_run_attempts":1,"root_cause":"The upstream table raw_customers renamed the customer_id column to cust_id, causing queries referencing c.customer_id to fail."},"status":"fixed"},{"run_id":"run-19248a265e93","started_at":"2026-08-26T04:44:56.560788+00:00","finished_at":"2026-08-26T04:45:21.292913+00:00","failure":{"scheduler":"demo","model_name":"dim_customers","run_id":"run-daad5bf679f0","error":"POST https://bigquery.googleapis.com/bigquery/v2/projects/dm-agentic-hackathon-2026/jobs?prettyPrint=false: Name customer_id not found inside c at [16:22]\n\nLocation: US\nJob ID: 68135f90-99a1-4708-b458-c39eda2c2b6c\n"},"result":{"tool_calls":6,"validated":true,"confidence":"high","run_id":"run-19248a265e93","model_name":"dim_customers","explanation":"Updated references from c.customer_id to c.cust_id in the SELECT list, JOIN condition, and GROUP BY clause to match the updated raw_customers table schema while maintaining customer_id as the output alias.","fixed_sql":"SELECT\n    c.cust_id                            AS customer_id,\n    c.full_name                          AS customer_name,\n    c.signup_date                        AS signup_date,\n    COUNT(o.order_id)                    AS lifetime_orders,\n    COALESCE(SUM(o.amount), 0)           AS lifetime_value,\n    MAX(o.ordered_on)                    AS last_order_date\nFROM `medic_demo.raw_customers` AS c\nLEFT JOIN `medic_demo.raw_orders` AS o\n    ON o.cust_id = c.cust_id\nGROUP BY\n    c.cust_id,\n    c.full_name,\n    c.signup_date","dry_run_attempts":1,"root_cause":"The upstream table raw_customers renamed the customer_id column to cust_id, causing references to c.customer_id to fail."},"status":"fixed"},{"run_id":"run-d0c98b700cbd","started_at":"2026-08-26T04:44:07.415869+00:00","failure":{"scheduler":"demo","model_name":"dim_customers","run_id":"run-453d69908502","error":"POST https://bigquery.googleapis.com/bigquery/v2/projects/dm-agentic-hackathon-2026/jobs?prettyPrint=false: Name customer_id not found inside c at [16:22]\n\nLocation: US\nJob ID: 7f922b07-9600-455f-915b-00067235b266\n"},"status":"in_progress"}]}