[1.3.1] - 2022-09-09
Highlights
- More refactoring of parse structures in preparation for upcoming refactor of
formatting/whitespace rules. - Fixes some bugs in L003 (indentation).
- New config flag
large_file_skip_byte_limitwhich applies prior to
loading the file.
What’s Changed
- Snowflake: Fix syntax errors in tests #3834 @JamesRTaylor
- Add support for additional magic methods on DummyUndefined #3835 @barrywhart
- MySQL: support variable assignments by assignment operator := #3829 @yoichi
- MYSQL: improve lexing for single-quoted strings #3831 @mdahlman
- MySQL: More support for index definition in CREATE TABLE #3826 @yoichi
- Typed matching and ripping out the rest of .name #3819 @alanmcruickshank
- sparksql dialect to support lambda expressions (->) #3821 @juhoautio
- Fixed broken main branch #3825 @alanmcruickshank
- Enable file name logging for multi-files w/ --show-lint-violations flag #3788 @thechopkins
- Take database and schema out of Snowflake reserved keywords list #3818 @NiallRees
- Remove a chunk of name references #3814 @alanmcruickshank
- Fix typo in Snowflake dialect #3813 @Gal40n04ek
- Allow the use of libraries in macro definitions #3803 @bjgbeelen
- Indentation fixes and rule logging improvements #3808 @alanmcruickshank
- Fixes a recursion error in JinjaTemplater handling of undefined values #3809 @barrywhart
- Snowflake: extend
GRANTsyntax #3807 @Gal40n04ek - add warehouse_type in snowflake dialect #3805 @Gal40n04ek
- add Create Notification Integration syntax #3801 @Gal40n04ek
- T-SQL: fix parsing PARTITION BY NULL in window function #3790 @fmms
- SparkSQL: Update L014 rule to not flag Delta Change Data Feed Session & Table Property #3689 @R7L208
- Snowflake: OVER (ORDER BY) clause required for first_value (fixes #3797) #3798 @JamesRTaylor
- add Alter Pipe syntax for snowflake dialect #3796 @Gal40n04ek
- BigQuery: Parse WEEK() in date_part #3787 @yoichi
- Postgres: Support setting user properties using intrinsic ON & OFF values #3793 @chris-codaio
- extend SF dialect for File Format statements #3774 @Gal40n04ek
- Add QUALIFY to SparkSQL dialect #3778 @ThijsKoot
- fix regex for S3Path #3782 @Gal40n04ek
- Snowflake: add Optional parameter ERROR INTEGRATION for PIPE #3785 @Gal40n04ek
- Add a file size check in bytes #3770 @alanmcruickshank
- Require importlib_metadata >=1.0.0 #3769 @alanmcruickshank
New Contributors
- @Gal40n04ek made their first contribution in #3785
- @ThijsKoot made their first contribution in #3778
- @chris-codaio made their first contribution in #3793
- @JamesRTaylor made their first contribution in #3798
- @fmms made their first contribution in #3790
- @bjgbeelen made their first contribution in #3803
- @thechopkins made their first contribution in #3788