Highlights
This release resolves compatibility issues with a set of dbt-core versions.
dbt-core1.5.2 onwards is now properly supported.- support for
dbt-core1.1 to 1.4 has now been re-enabled after support had to be abandoned a few releases ago.
NOTE: We cannot guarantee that SQLFluff will always continue to remain compatible with all dbt versions, particularly as the folks at dbt-labs have often backported breaking changes to their internal APIs to previous versions of dbt-core. This release does at least bring more extensive internal testing to catch when this does occur to allow our community to react.
This release fixes also resolves a potential security issue for when using external libraries (and the library_path config setting), and also contains various dialect improvements.
What’s Changed
- docs(templater): Add documentation for
SQLFLUFF_JINJA_FILTERS#4932 @dmohns - Re-enable dbt 1.1 & 1.2 #4944 @alanmcruickshank
- Re-enable dbt 1.4 & 1.3 #4941 @alanmcruickshank
- Fix compatibility with dbt 1.5.2+ #4939 @alanmcruickshank
- Security option for library path #4925 @alanmcruickshank
- Remove extra code escapes from release notes docs #4921 @tunetheweb
- Postgres frame_clause quoted interval #4915 @greg-finley
- Snowflake: CREATE TAG #4914 @greg-finley
- TSQL: support for
DROP EXTERNAL TABLE#4919 @keen85 - fix(dialect-clickhouse): Support create database #4620 @germainlefebvre4
- Snowflake: Actualize the CreateProcedureStatementSegment and CreateFunctionStatementSegment #4908 @moreaupascal56
- Oracle: Add support for
$and#in identifier #4903 @ulixius9 - docs(templater): Refactor templater configuration docs #4835 @dmohns
- Handle brackets in from clause with joins #4890 @ulixius9
- Postgres: Add support for dollar literal & mark collation as non-reserved #4883 @ulixius9
- MySQL: ON UPDATE NOW #4898 @greg-finley
- Support ROLLUP/CUBE in AM06 #4892 @tunetheweb