check_sql
Validate SQL queries against a schema snapshot to catch non-existent or stale table and column names before running them. Returns close matches for corrections without executing the query.
Instructions
Tables and columns in sql that don't exist in the snapshot, with close matches. Does not run the query.
dialect: bigquery, snowflake, databricks, postgres, duckdb ... (default: the snapshot's).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | ||
| dialect | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |