<invoke name="tool_call"> <parameter name="reasoning">Dates are VARCHAR with mixed hyphen characters; parse them to get true min/max per table. </parameter> <parameter name="tool">query_sql</parameter> <parameter name="args">{"sql": "WITH d AS (SELECT 'raw_kaggle' AS tbl, try_strptime(replace(\"Date\", '‑', '-'), '%d-%b-%Y') AS dt FROM raw.raw_kaggle UNION ALL SELECT 'return_kaggle', try_strptime(replace(\"Date\", '‑', '-'), '%d-%b-%Y') FROM raw.return_kaggle UNION ALL SELECT 'serve_kaggle', try_strptime(replace(\"Date\", '‑', '-'), '%d-%b-%Y') FROM raw.serve_kaggle) SELECT tbl, CAST(MIN(dt) AS DATE) AS min_date, CAST(MAX(dt) AS DATE) AS max_date, COUNT(*) AS n_rows, COUNT(dt) AS parsed_rows FROM d GROUP BY tbl ORDER BY tbl", "purpose": "Compute true date range per fact table", "source": "raw"}</parameter> </invoke>