NOTE: This is an alpha release for testing purposes. There are several new features
here, and breaking changes to configuration. We welcome testing feedback from the
community, but know that this release may feel less polished than usual.
Highlights
This is the third alpha release for 2.0.0. It contains primarily bugfixes from 2.0.0a2 to allow continued testing. In particular, some of the recent 2.0.0-related changes to the dbt templater have been reverted, primarily due to performance and other issues. If those issues can be resolved, the changes will be re-introduced. The long-term goal of this work is to ease maintenance of the templater by separating dbt integration concerns from SQLFluff concerns.
There will likely be more changes to rule classification before a full release of 2.0.0, so anticipate that configuration files may change slightly again in future alpha releases.
What’s Changed
- Move ISSUE from Snowflake reserved keywords to unreserved ones #4279 @KaoutherElhamdi
- Due to performance and other issues, revert the osmosis implementation of the templater for now #4273 @barrywhart
- Simplify lexing #4289 @alanmcruickshank
- Fix #4255 (Fix exception on mixed indent description) #4288 @alanmcruickshank
- Fix #4253 (incorrect trigger of L006 around placeholders) #4287 @alanmcruickshank
- Fix #4249 (TSQL block comment indents) #4286 @alanmcruickshank
- Fix #4252 (Resolve multiple sensible indents) #4285 @alanmcruickshank
- Parser Performance: Cache segment string repr to reduce function calls #4278 @WittierDinosaur
- Snowflake: GRANT SUPPORT CASES #4283 @WittierDinosaur
- Dialect: duckdb #4284 @WittierDinosaur
- Snowflake: Add variable pattern to CopyIntoTable #4275 @WittierDinosaur
- Postgres: Non-reserved keyword bugfix #4277 @WittierDinosaur
- Hive: Add Table constraints DISABLE VALIDATE #4281 @WittierDinosaur
- Snowflake: Add Python and Java UDF support #4280 @WittierDinosaur
- SparkSQL: Support DIV binary operator #4282 @WittierDinosaur
- BigQuery: Add ALTER TABLE #4272 @yoichi
- Snowflake: Update bare functions #4276 @WittierDinosaur
- Improve Dockerfile to reduce image size #4262 @tdurieux