{
    "action": "tool_call",
    "reasoning": "Check duplicate rows on the inferred key (WEBSITE, YEAR, PAGE URL) to validate the grain before analysis.",
    "tool": "query_sql",
    "args": {
        "sql": "SELECT COUNT(*) AS dup_keys, COALESCE(SUM(c),0) AS rows_in_dup_keys, COALESCE(MAX(c),0) AS max_rep FROM (SELECT WEBSITE, YEAR, \"PAGE URL\", COUNT(*) AS c FROM raw.Website_Analytics GROUP BY ALL HAVING COUNT(*) > 1)",
        "purpose": "Check duplicate rows on the inferred key (website, year, page URL)",
        "source": "raw"
    }
}