{
    "action": "tool_call",
    "reasoning": "Profile data quality in one query: row count, distinct keys, nulls, date format conformity, amount parseability and range.",
    "tool": "query_sql",
    "args": {
        "purpose": "Profile data quality: nulls, date formats, amount parseability",
        "source": "raw",
        "sql": "SELECT COUNT(*) AS n, COUNT(DISTINCT \"Sr No\") AS distinct_sr, COUNT(\"Date dd/mm/yyyy\") AS date_nonnull, SUM(CASE WHEN regexp_matches(\"Date dd/mm/yyyy\", '^[0-9]{2}/[0-9]{2}/[0-9]{4}$') THEN 1 ELSE 0 END) AS date_std, COUNT(\"Amount in USD\") AS amt_nonnull, SUM(CASE WHEN TRY_CAST(REPLACE(\"Amount in USD\", ',', '') AS DOUBLE) IS NOT NULL THEN 1 ELSE 0 END) AS amt_numeric, SUM(CASE WHEN \"Amount in USD\" IS NOT NULL AND TRY_CAST(REPLACE(\"Amount in USD\", ',', '') AS DOUBLE) IS NULL THEN 1 ELSE 0 END) AS amt_nonnumeric, MIN(TRY_CAST(REPLACE(\"Amount in USD\", ',', '') AS DOUBLE)) AS amt_min, MAX(TRY_CAST(REPLACE(\"Amount in USD\", ',', '') AS DOUBLE)) AS amt_max, MEDIAN(TRY_CAST(REPLACE(\"Amount in USD\", ',', '') AS DOUBLE)) AS amt_median, COUNT(\"Startup Name\") AS name_nn, COUNT(\"Industry Vertical\") AS ind_nn, COUNT(\"SubVertical\") AS sub_nn, COUNT(\"City  Location\") AS city_nn, COUNT(\"Investors Name\") AS inv_nn, COUNT(\"InvestmentnType\") AS type_nn, COUNT(\"Remarks\") AS remarks_nn FROM raw.startup_funding"
    }
}