tobymao / sqlglot

Python SQL Parser and Transpiler
https://sqlglot.com/
MIT License
6.7k stars 701 forks source link

Support Spark 3.5's new View Schema Binding Options #3738

Closed aersam closed 4 months ago

aersam commented 4 months ago
import sqlglot

sqlglot.parse_one(
    "create or replace view silver.princess_schema_drift__current with schema evolution as select * from asf",
    dialect="databricks",
)

Docs: https://docs.databricks.com/en/sql/language-manual/sql-ref-syntax-ddl-create-view.html

aersam commented 4 months ago

In general most DBMS have very different behavior regarding schema drift on view's, I don't think there's something meaningful to transpile here