TO_TIMESTAMP casted to TIMESTAMP in Redshift

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

TO_TIMESTAMP casted to TIMESTAMP in Redshift #223

Closed MatheHostel closed 1 month ago

MatheHostel commented 1 month ago

This will cast the correct TIMESTAMP (WITHOUT TIME ZONE) in all Redshift LDTS and Timestamp used fields.

thoffmann-sf commented 1 month ago

Hey MatheHostel, thank you for your contribution! This issue is already fixed in the redshift-patch branche https://github.com/ScalefreeCOM/datavault4dbt/tree/redshift-patch we are currently waiting for the next major release wich will include this fix as well. Have a nice weekend :)

Tim

MatheHostel commented 1 month ago

Hi, yes this was a test. But please check the macro "redshift__control_snap_v0" which is fixed in this branch but not in your branch.

thoffmann-sf commented 1 month ago

The macro is fixed now, thanks for the head-up :)