dbt-date 0.5.1

What's Changed

• Fix week_start on Snowflake by @clausherther in #54

Full Changelog: 0.5.0...0.5.1

dbt-date 0.5.0

What's Changed

• Upgrade project to support dbt 0.1.x by @clausherther in #50

This release is NOT backwards-compatible with versions of dbt < 1.0.0. Please use 0.4.2 if you're not yet ready to upgrade to dbt v1.

Full Changelog: 0.4.2...0.5.0

dbt-date 0.4.2

What's Changed

• Patch release to support dbt 0.1.x by @clausherther in #51

Full Changelog: 0.4.1...0.4.2

dbt-date 0.4.1

dbt-date v0.4.1

What's Changed

• fix readme for days, weeks, and months away by @scott-capmo in #44
• Super small link fix in README by @fivetran-joemarkiewicz in #46
• Support dbt 0.21.x by @clausherther in #47

New Contributors

• @scott-capmo made their first contribution in #44
• @fivetran-joemarkiewicz made their first contribution in #46

Full Changelog: 0.4.0...0.4.1

dbt-date 0.4.0

dbt-date v0.40

Breaking Changes

• Updates calls to adapter.dispatch to support dbt >= 0.20 (see Changes to dispatch in dbt v0.20 #34)

• Requires dbt >= 0.20

• Changes dbt-utils URL to dbt-labs

Under the hood

• Adds tests for timestamp and timezone macros (previously untested, new dbt version highlighted that)

dbt-date 0.3.1

dbt-date v0.3.1

Patch release

Fixes

• Fixed a bug in snowflake__from_unixtimestamp that prevented the core functionaility from being called (#38 by @swanderz)

Under the hood

• Simplified join syntax (#36)

dbt-date 0.3.0

dbt-date v0.3.0

Breaking Changes

• Switched day_of_week column in get_date_dimension from ISO to not ISO to align with the rest of the package. #33 (@davesgonechina)

Features

• Added day_of_week_iso column to get_date_dimension #33 (@davesgonechina)

• Added prior_year_iso_week_of_year column to get_date_dimension

Fixes

• Refactored Snowflake's day_name to not be ISO dependent #33 (@davesgonechina)

• Fixed data types for day_of_* attributes in Redshift (#28 by @sparcs)

• Fixed / added support for date parts other than day in get_base_dates (#30)

Under the hood

• Making it easier to shim macros for other platforms (#27 by @swanderz)

dbt-date 0.2.6

Removes dependency on spark-utils.

Users running this package on non-core (Snowflake, BigQuery, Redshift, Postgres) platforms, will need to use a package like spark_utils to shim macros.

For example, in packages.yml, you will need to include the relevant package:

  - package: fishtown-analytics/spark_utils
    version: <latest or range>

And reference in the dispatch list for dbt_utils in dbt_project.yml:

vars:
    dbt_utils_dispatch_list: [spark_utils]

dbt-date 0.2.5

• Adds better support for BigQuery (#16 #17 @VasiliiSurov)

dbt-date 0.2.4

• Updates get_base_dates macro to work better across platforms (thanks @b-per!)