v0.21.0rc2

major difference

experiment with reimplementing dbt-sqlserver's custom test materialization inside of dbt-synapse. ultimately wasn't needed...

What's Changed

• ensure pool pauses after run by @swanderz in #57
• v0.20.0 by @swanderz in #55

Full Changelog: v0.20.0...v0.21.0rc2

dbt-synapse v0.21.0rc1

What's Changed

• ensure pool pauses after run by @swanderz in #57
• v0.20.0 by @swanderz in #55

Full Changelog: v0.20.0...v0.21.0rc1

dbt-synapse v0.20.0

dbt-synapse v0.20.0

Features

• brings compatibility with dbt-core v0.20.0 and dbt-sqlserver 0.20.0

Under the hood

• Fix a bug where snapshots on tables with non-indexable datatypes would throw the error "The statement failed. Column 'XXXXX' has a data type that cannot participate in a columnstore index. (35343) (SQLExecDirectW)" #56 thanks MarvinSchenkel
• 10+ synapse__ macros no longer have to be defined as they're now auto-defined as part of the v0.20.0 upgrade. Code footprint is now >37 lines smaller!

dbt-synapse v0.20.0rc1

dbt-synapse v.0.20.0rc1

Features

• brings compatibility with dbt-core v0.20.0rc1

Under the hood

• 10+ synapse__ macros no longer have to be defined as they're now auto-defined as part of the v0.20.0 upgrade. Code footprint is now >37 lines smaller!

dbt-synapse v.0.19.2

v.0.19.2

Under the hood

• fix bug introduced v0.19.1 where the new macros in dbt-sqlserver#126 were still being used somehow
• no longer pin agate<1.6.2 because it now done as part of dbt 0.19.1

dbt-synapse v.0.19.1

v.0.19.1

Under the hood

• override new functionality in dbt-sqlserver dbt-sqlserver #126 that allows for cross-database queries. Azure Synapse does not support this, so sqlserver__ adapter macros that were previously used by dbt-synapse had to be re-implemented as synapse__ macros. #49
• make CI testing auto-start and auto-pause Synapse cluster to save $$$ #47

dbt-synapse v.0.19.0.1

v.0.19.0.1

Fixes

• Resolves bug where snapshot and seeds materializations weren't working correctly #45 thanks [@alieus]

Under the hood

• dbt-synapse will allow all patches to dbt and dbt-sqlserver version 0.19. dbt v0.19.1 coming soon!
• Per issue with pyICU package (fishtown-analytics/dbt/#3161), temporarily pin agate to between 1.6.0 and 1.6.2, inclusive, until dbt 0.19.1 is released.

dbt-synapse v0.19.0

v.0.19.0

BREAKING CHANGES

• you must change your profile so that type=synapse instead of type=sqlserver. The reason is that now dbt-synapse now fully inheirits from dbt-sqlserver rather than being a fork. The benefit now is that you can have dbt-sqlserver and dbt-synapse coexist in the same environment.

New features:

• Brings support for
  • dbt v0.19.0 (release notes) and
  • dbt-sqlserver v0.19.0.1 & v0.19.0 (release notes)

Under the hood

• the snapshot materialization, except for the MERGE workaround, now depends entirely on dbt-core's global project. Made possible due to tempdb.INFO_SCHEMA workaround #42
• make the adapter inheirit from dbt-sqlserver #32 #33 thanks @jtcohen6 @chaerinlee1
• the snapshot materialization, now depends entirely on dbt-core's global project. See dbt-sqlserver release notes for more info #44

dbt-synapse v0.19.0rc1

quick release cut

dbt-synapse v0.18.1

• DEPRECATION this will be the last release to use type=sqlserver. In future releases, it will be type=synapse
• many changes via dbt-sqlserver see dbt-sqlserver v0.18.1 for more info
• authentication with az login! thanks to @JCZuurmond for #35
• fix for seeding failing for presence of a a blank, or, a single quote (') within the string (e.g. O'Brien) thanks to @NandanHegde15 for #24 and #31
• update snapshot_merge to execute the update and insert in a single transaction, allowing the update to be rolled back upon failure #23
• external tables now live in fishtown-analytics/dbt-external-tables. Check them out! Our team loves them!