[3.0.6] - 2024-05-06

Highlights

This release primarily fixes an issue introduced by the recent dbt 1.7.14 release, and better support for dbt 1.7+. It also includes a range of dialect improvements and CLI refinements.

This release also includes the groundwork for linting the unrendered sections of Jinja templates. More documentation on this will be released in due course when it's ready for beta testing.

Thanks also to @padraic00 & @burhanyasar who made their first contributions in this release. 🎉🎉🏆🎉🎉

What’s Changed

• [fix_clickhouse] Temporary Table Create AS SELECT (#5843) @konnectr
• Bugfix: ST02 - Compare entire condition expression (#5850) @WittierDinosaur
• Clichouse prewhere (#5849) @konnectr
• BigQuery: Support missing DROP statements (#5848) @kzosabe
• BigQuery: various CREATE statements (#5846) @greg-finley
• BigQuery Alter Schema (#5835) @greg-finley
• Snowflake execute immediate from (#5836) @greg-finley
• Support dbt 1.7 (#5842) @WittierDinosaur
• Postgres: Create extension cascade (#5834) @greg-finley
• Postgres: Add Support for PostGIS operators (#5830) @burhanyasar
• Db2: Support additional CREATE INDEX options (#5827) @keraion
• Allow to align all siblings when respacing (#5826) @borchero
• BigQuery: Support EXECUTE IMMEDIATE (#5820) @keraion
• BigQuery: Support CREATE ROW ACCESS POLICY statement (#5821) @kzosabe
• Fix Jinja variant location correction (#5814) @alanmcruickshank
• Test cases for linter fails. (#5815) @alanmcruickshank
• BigQuery: Support nested BEGIN, Fix CREATE PROCEDURE OPTIONS (#5816) @keraion
• Bring multiple jinja variants through to the parser. (#5794) @alanmcruickshank
• Fix placeholder labelling (#5813) @alanmcruickshank
• Tighten up the return from .process() (#5810) @alanmcruickshank
• BigQuery: Support CREATE MATERIALIZED VIEW AS REPLICA OF (#5811) @kzosabe
• BigQuery: Support OPTIONS in CREATE FUNCTION statement (#5812) @kzosabe
• TSQL: fix ALTER TABLE ... SWITCH PARTITION (#5807) @keen85
• SparkSQL: Add functions that use UNIT keywords (#5806) @keraion
• CLI: Add --stdin-filename option (#5805) @keraion
• TSQL: parse CREATE/ALTER/DROP MASTER KEY (#5802) @keen85
• Jinja Variant Configuration (#5785) @alanmcruickshank
• Small refactor in jinja templater (#5786) @alanmcruickshank
• BigQuery: Support FOR SYSTEM_TIME AS OF in CREATE TABLE CLONE statement (#5798) @kzosabe
• TSQL: support for CREATE/ALTER PARTITION FUNCTION/SCHEME (#5793) @keen85
• BigQuery: Support DEFAULT COLLATE segment (#5790) @kzosabe
• TSQL: support computed columns (#5792) @keen85
• Simplify one of the lexer methods (#5788) @alanmcruickshank
• Improve light colour highlight (#5784) @alanmcruickshank
• SparkSQL: Support TIMESTAMP_LTZ and TIMESTAMP_NTZ types (#5783) @padraic00

New Contributors

• @padraic00 made their first contribution in #5783
• @burhanyasar made their first contribution in #5830