ScalefreeCOM / datavault4dbt

Scalefree's dbt package for a Data Vault 2.0 implementation congruent to the original Data Vault 2.0 definition by Dan Linstedt including the Staging Area, DV2.0 main entities, PITs and Snapshot Tables.

https://www.scalefree.com/

Apache License 2.0

144 stars 27 forks source link

FIX:databricks/postgres/redshift: replace unsupported timestamp_sub- and dateadd-functions #280

Closed tkiehn closed 2 weeks ago

tkiehn commented 3 weeks ago

Description

timestamp_sub is not supported in databricks and postgres, therefore it needed to be replaced with arithmetic syntax. dateadd in conjunction with referencing a column did cause an error in redshift, therefore it was also replaced with arithmetic syntax

Type of change

[x] Bug fix (non-breaking change which fixes an issue)

tkirschke commented 2 weeks ago

@tkiehn after merging this, pls create new minor release 👍

remoteworkflow[bot] commented 2 weeks ago

Link to workflow summary: https://github.com/ScalefreeCOM/datavault4dbt-ci-cd/actions/runs/11680184218

RESULTS for Synapse: :white_check_mark: dbt-tests
:white_check_mark: dbt-macro-tests

RESULTS for Postgres: :white_check_mark: dbt-tests :white_check_mark: dbt-macro-tests

RESULTS for BigQuery: :white_check_mark: dbt-tests :white_check_mark: dbt-macro-tests

RESULTS for Redshift: :x: dbt-tests :white_check_mark: dbt-macro-tests

RESULTS for Snowflake: :white_check_mark: dbt-tests :white_check_mark: dbt-macro-tests

RESULTS for Exasol: :x: dbt-tests :x: dbt-macro-tests

RESULTS for Fabric: :white_check_mark: dbt-tests :white_check_mark: dbt-macro-tests

RESULTS for Oracle: :white_check_mark: dbt-tests :white_check_mark: dbt-macro-tests

RESULTS for Databricks: :x: dbt-tests :white_check_mark: dbt-macro-tests

remoteworkflow[bot] commented 2 weeks ago

Link to workflow summary: https://github.com/ScalefreeCOM/datavault4dbt-ci-cd/actions/runs/11708198609

RESULTS for Synapse: :white_check_mark: dbt-tests
:white_check_mark: dbt-macro-tests

RESULTS for Postgres: :white_check_mark: dbt-tests :white_check_mark: dbt-macro-tests

RESULTS for BigQuery: :white_check_mark: dbt-tests :white_check_mark: dbt-macro-tests

RESULTS for Redshift: :white_check_mark: dbt-tests :white_check_mark: dbt-macro-tests

RESULTS for Snowflake: :white_check_mark: dbt-tests :white_check_mark: dbt-macro-tests

RESULTS for Exasol: :x: dbt-tests :white_check_mark: dbt-macro-tests

RESULTS for Fabric: :white_check_mark: dbt-tests :white_check_mark: dbt-macro-tests

RESULTS for Oracle: :white_check_mark: dbt-tests :white_check_mark: dbt-macro-tests

RESULTS for Databricks: :white_check_mark: dbt-tests :white_check_mark: dbt-macro-tests