The GitHub Actions job "Tests (AMD)" on 
airflow.git/sqltoolset-allow-describe-show has failed.
Run started by GitHub user kaxil (triggered by kaxil).

Head commit for run:
5b6e8d73bf4595f187dc842258add23688e73855 / Kaxil Naik <[email protected]>
Allow DESCRIBE/SHOW in common.ai SQLToolset read-only queries

In read-only mode the SQLToolset query tool only accepted SELECT-family
statements, so an agent that opened with DESCRIBE (a common first move to
learn a table's columns) hard-failed with SQLSafetyError. That made agent
runs nondeterministic: a run composing SELECTs directly succeeded while one
starting with DESCRIBE failed outright.

The query and check_query tools now also accept read-only metadata statements
(DESCRIBE/DESC and SHOW) via an opt-in allow_read_only_metadata flag on
validate_sql(). The toolset passes the connection's dialect through, so SHOW is
recognized on databases that support it (Snowflake, MySQL); without a supporting
dialect it falls back to a blocked statement. Data-modifying statements stay
blocked, including ones wrapped behind DESCRIBE/EXPLAIN (e.g. EXPLAIN DELETE,
DESCRIBE DROP TABLE): the deep scan now also rejects DDL nodes that became
reachable through the metadata allowlist.

The SQLAlchemy-to-sqlglot dialect mapping is consolidated into a shared
resolve_sqlglot_dialect() helper (reused by LLMSQLQueryOperator) that returns
None for unknown dialects so a misdetected dialect never breaks validation.

Report URL: https://github.com/apache/airflow/actions/runs/27043676674

With regards,
GitHub Actions via GitBox


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to