search

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
143 stars 27 forks source link

fix redshift/postgres beginning_of_all_times unknown ghost record values #260

Closed tkiehn closed 1 month ago

tkiehn commented 1 month ago

Description

beginning_of_all_times_date was used instead of beginning_of_all_times, therefore if the defaults were not changed the ghost record value of the unknown records had 00:00:00 instead of 00:00:01 as time. This results in incorrect filtering of the ghost records by timestamp downstream

Type of change

remoteworkflow[bot] commented 1 month ago

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

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