{
    "action": "tool_call",
    "reasoning": "I've inspected the main tables and found some quality signals (high stddev in close_value, 37% zeros, skewed distributions in accounts). Now I need to check referential integrity - whether sales_agent, product, and account values in the pipeline actually exist in their respective dimension tables. This is a critical data quality check.",
    "tool": "query_sql",
    "args": {
        "sql": "SELECT 'orphaned_products' AS issue_type, COUNT(DISTINCT p.product) AS count FROM raw.b2b_sales_funnel_pipeline p WHERE p.product NOT IN (SELECT product FROM raw.products) UNION ALL SELECT 'orphaned_accounts', COUNT(DISTINCT p.account) FROM raw.b2b_sales_funnel_pipeline p WHERE p.account NOT IN (SELECT account FROM raw.accounts) UNION ALL SELECT 'orphaned_sales_agents', COUNT(DISTINCT p.sales_agent) FROM raw.b2b_sales_funnel_pipeline p WHERE p.sales_agent NOT IN (SELECT sales_agent FROM raw.sales_teams)",
        "purpose": "Check for referential integrity issues - pipeline records referencing non-existent products, accounts, or sales agents",
        "source": "raw"
    }
}