sql-correctness

SQL Correctness Rubric

When evaluating SQL in agent traces, check these dimensions:

1. Unity Catalog Namespace

• Must use 3-level namespace: catalog.schema.table
• Never use unqualified table names
• Catalog/schema should match the user's context (not hardcoded main.default unless appropriate)

2. Modern DDL Syntax

• Use CREATE OR REPLACE instead of DROP IF EXISTS + CREATE
• Use ALTER TABLE ... SET TBLPROPERTIES for table properties
• Use COMMENT ON for documentation

3. Tool Selection

• Must use mcp__databricks__execute_sql for SQL execution
• Must NOT use Bash with databricks sql CLI as a workaround
• Must NOT use notebook execution for simple queries