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

136 stars 25 forks source link

Add macros for global beginning and end of all times dates #249

Closed tkiehn closed 4 weeks ago

tkiehn commented 4 weeks ago

Description

The global variables for beginning and end of all times as a date are currently set as dictionaries inside the dbt_project.yml. This PR introduces the macros that parse these variables and call them in the ghost_records_per_datatype.

Type of change

Please delete options that are not relevant.

[x] Bug fix (non-breaking change which fixes an issue)
[x] New feature (non-breaking change which adds functionality)
[x] This change requires a documentation update ~~- Global variables need to be updated in the Wiki~~

How Has This Been Tested?

Pipeline when opening this PR

Checklist:

[x] I have performed a self-review of my code
[x] I have made corresponding changes to the documentation or included information that needs updates (e.g. in the Wiki)

remoteworkflow[bot] commented 4 weeks ago

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

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 :x: dbt-macro-tests