Skip to content

Releases: get-select/dbt-snowflake-monitoring

3.0.0

26 Feb 18:12
7716514
Compare
Choose a tag to compare

dbt-snowflake-monitoring 3.0.0 - February 26, 2023

After attempting to use only query comments or query tags in versions 1 and 2, we've learned we actually need both. The reasons for that are:

  • The is_incremental macro is only available from within the query tag dbt context, and is needed to determine whether a model run is incremental or not.
  • Query tags have a maximum character limit of 2000, which is easily exceeded by a list of refs containing more than a few models.

To upgrade from 2.x.x, follow the latest instructions in the Quickstart. The package is still able to process query metadata generated by previous versions of the package, so no data will be lost on upgrade.

Breaking Changes

  • Use query comments and query tags to avoid query tag character limit (#87)

2.0.2

21 Feb 08:07
51b91a6
Compare
Choose a tag to compare

dbt-snowflake-monitoring 2.0.2 - February 21, 2023

Fixes

  • Use the model database and schema for UDF creation (#83)

2.0.1

20 Feb 19:03
2a6179e
Compare
Choose a tag to compare

dbt-snowflake-monitoring 2.0.1 - February 17, 2023

Features

  • Add spend_net_cloud_services (#80)

2.0.0

13 Feb 13:25
aef2e53
Compare
Choose a tag to compare

dbt-snowflake-monitoring 2.0.0 - February 13, 2023

The most significant change in 2.0.0 is using query tags instead of comments to attach dbt metadata to queries. To upgrade from previous versions:

  1. Remove the query comment configuration from dbt_project.yml
  2. Follow the instructions to configure the query tag in the Quickstart.

Breaking Changes

  • Switch to using query tags instead of comments (#78)

1.6.1

06 Feb 11:02
899410f
Compare
Choose a tag to compare

dbt-snowflake-monitoring 1.6.1 - February 03, 2023

Fixes

  • Fixes is_incremental in get_query_comment macro (#77)

1.6.0

01 Feb 14:22
Compare
Choose a tag to compare

dbt-snowflake-monitoring 1.6.0 - February 01, 2023

Features

  • Add query_object_access and query_table_access models (#73)

1.5.0

25 Jan 16:37
2c83d2d
Compare
Choose a tag to compare

dbt-snowflake-monitoring 1.5.0 - January 25, 2023

Fixes

  • Fix query_text_no_comments regex (#72)

1.4.3

20 Jan 16:44
Compare
Choose a tag to compare

dbt-snowflake-monitoring 1.4.3 - January 20, 2023

Fixes

  • Fix error on initial compile with no models created yet (#70)

1.4.2

12 Jan 09:56
Compare
Choose a tag to compare

dbt-snowflake-monitoring 1.4.2 - January 12, 2023

Fixes

  • Inner join daily_rates to avoid $0 entries in daily_spend for incomplete days (#66)

1.4.1

07 Jan 04:59
Compare
Choose a tag to compare

dbt-snowflake-monitoring 1.4.1 - January 06, 2023

Fixes

  • Increase incremental lookback window to account for changing cost data (#64)