Skip to content

Latest commit

 

History

History
340 lines (214 loc) · 8.61 KB

CHANGELOG.md

File metadata and controls

340 lines (214 loc) · 8.61 KB
Raw

Changelog

All notable changes to this project will be documented in this file.

The format is based on Keep a Changelog, adheres to Semantic Versioning, and is generated by Changie.

v.1.9.0

Added

  • Snapshot support

Fixed

  • Fixed an issue when indexes would break on columns containing spaces

v.1.8.3

Changed

  • Enabled tests that were disabled due to the feature gaps

Fixed

  • Fixed default arguments for copy stategy when they would appear empty when not specified.

v.1.8.2

Fixed

  • Partition drop logic using the old SQL format.

v.1.8.1

Added

  • Added host connection parameter alias

v.1.8.0

Added

  • dbt 1.8 support

v.1.7.0

Added

  • dbt 1.7 support with tests and refactoring

Fixed

  • Incompatible tests

v.1.6.4

Added

  • Ability to specify AWS key id and secret when creating external tables.
  • Added a way to use COPY FROM command as an alternative to EXTERNAL TABLE.

Changed

  • External table authentication to inlcude optional role external id.
  • Changed list_relations_without_caching to account for changed information schema view

Fixed

  • Fixed tests that were failing due to the new Firebolt syntax.
  • Fixed seed full refresh resolution.

v.1.6.3

Fixed

  • Broken whitesace when compression was specified in external tables

v.1.6.2

Changed

  • Limit dbt-core to 1.8 to avoid breakage

v.1.6.1

Fixed

  • Prevent comments at the end of a model from breaking the SQL

v.1.6.0

Added

  • Stubs for materialised view
  • Stubs for dbt clone
  • Additional tests

Deprecated

  • Deprecated dev CI runs

Removed

  • Removed Python 3.7 support

v.1.5.0

Added

  • constraints support and enforcement

Changed

  • Changed tests to verify new NOW() behaviour

v.1.4.4

Added

  • Ability to connect to new and old Firebolt

Fixed

  • Error message on schema mismatch now shows the exact mismatch
  • Refactored deprecated error message parsing

v.1.4.3

Fixed

  • Incorrect column resolution when using get_columns_in_relation macro

v.1.4.2

Added

  • Allowed multithreaded execution of dbt models
  • delete+insert incremental strategy

Fixed

  • updated get_test_sql macro to fix dbt test in jaffle shop demo repository

v.1.4.1

Added

  • Added a stub for get dcl statement macro

Fixed

  • corrected a grant error when run from dbt seed
  • Fixed query_comment issue when no config specified

v.1.4.0

Added

  • query_comments are now supported

Fixed

  • Timestamp functions

v.1.3.0

Added

  • New array macros and refactor for dbt-core==1.3 compatibility

Changed

  • Using temp views instead of temp tables in incremental for performance

v.1.2.0

Features

  • get_catalog now returns database and schema names along with the column indexes
  • Implemented firebolt-specific macros: bool_or, cast_bool_to_text, dateadd, datediff, listagg, position, right, split_part
  • Fixed doc generation
  • Implemented connection retry
  • Added explicit error for grants

Under the hood

  • Using new test framework
  • Added clarifications for skipped tests

v.1.1.3

Features

  • dbt-firebolt now quotes database name allowing for case-sensitive operations.

Under the hood

v.1.1.2

Features

  • dbt-firebolt now passes through more useful error messages on API timeouts.

Under the hood

  • dbt-firebolt now requires firebolt-sdk>=0.10.0.

v.1.1.1

Under the hood

  • dbt-firebolt now requires firebolt-sdk>=0.9.2.

v.1.1.0

Features

  • dbt-firebolt now supports the insert/overwrite incremental model.

Under the hood

  • dbt-firebolt now requires firebolt-sdk>=0.8.1.

Breaking changes

  • dbt-firebolt uses firebolt-sdk's new auth token method, thus requires firebolt-sdk >= 0.8.1.

v.1.0.6

Under the hood

  • dbt-firebolt now requires dbt v1.1.
  • dbt-firebolt now requires firebolt-sdk>=0.7.

Breaking changes

  • dbt-firebolt now requires dbt v1.1

v.1.0.5

Under the hood

  • Added FireboltColumn class to handle string type.
  • Added mypy to pre-commit tests.
  • Fixed output from dbt runs so that successful table creation outputs “Success” rather than “False.”

v.1.0.4

Features

  • dbt-firebolt now supports the append-only incremental model.
  • We now return better/more accurate responses from the cursor for logging/debugging.

Under the hood

  • Rendering of SQL output was reformatted to increase legibility of debug output and log files.
  • Removed all uses of SHOW VIEWS and SHOW TABLES and replaced them with calls to information_schema.views and information_schema.tables, respectively.
  • Updated to give better/more accurate responses from cursor.
  • Fixed an error where names for aggregating and join indexes with only single values for indexes were being improperly generated.

Breaking changes

  • Join and key column field names in aggregating and join indexes are now pluralized: join_column becomes join_columns and key_column becomes key_columns in index config blocks.

v.1.0.3

Under the hood

  • Dev requirements are now in setup.cfg and not dev-requirements.txt.
  • dbt-firebolt now requires firebolt-sdk v.0.6 to allow for SET variables to be set in pre-hooks.

v.1.0.2

Features

  • dbt-firebolt now supports aggregating indexes with multiple-column keys.

Under the hood

  • Bug fix to check for data_type and regex fields when necessary on external tables.
  • Changed default behavior on external table insert to DROP IF EXISTS.

Breaking changes

  • Models with aggregating and join indexes now require index_type field in index config blocks rather than type.

v.1.0.1

Under the hood

  • Updated seed behavior. Seed now does a DROP <table_name> CASCADE followed by a CREATE TABLE <table_name> rather than TRUNCATE, which was not working consistently.

v.1.0.0

  • dbt-firebolt now supports dbt 1.0+!

v.0.21.10

Breaking changes

  • We now use our DB-API rather than our JDBC.

v.0.21.9

Under the hood

  • Bug fixes to do with pull request linting. – Also for PRs, moved to conventional commmits.

v.0.21.8

Under the hood

  • Updated pre-commit linting and added pull request linting.

v.0.21.7

Changes

  • Disallowed setting of threads in profiles.yml to a value greater than 1.

Under the hood

  • Added automatic PR security scanning via Sonar Cloud adn Fossa.

v.0.21.6

Changes

  • Updated readme to link to Firebolt JDBC page, in order to assure latest driver is always linked.

v.0.21.5

Under the hood

  • Resolved unknown import error.

v.0.21.4

Changes

  • Views are now officially supported with dbt-firebolt! #22 and #25.

Under the hood

  • Added GitHub templates for PRs and issues.
  • Added linting using Black, Flake8, and iSort. This necessitated the addition of a setup.cfg file, so an additional linter, setup-cfg-fmt was added to check that file. These linters are all pre-commit hooks, so will force any future commits to abide by our style. #20.
  • Indefinitely removed setup.cfg from project #29.

v.0.21.3

Changes

  • Temporary workaround implemented for #11 where running models twice fails #12.

v.0.21.2

Readme

  • Updated and edited various sections of readme, adding new tables and examples for clarity. #6.

Breaking Changes

  • engine_name has been renamed to engine please update your profiles.yml accordingly #4.

Features

  • Added ability to specify an account for users who have more than one account associated with their credentials #4.

Fixes

  • Fixed bug where database connection URL used backslashes on Windows due to os.path.join #5.

v.0.21.1

Fixes

  • Removed log statements and an extra firebolt__get_create_index_sql macro error via #2.

  • Added ability to specify an account for users who have more than one account associated with their credentials.

v.0.21.0

Features

  • Initial release for PyPI!

Fixes

  • Many

Under the Hood

  • A lot of work!

Contributors