search

ScalefreeCOM / datavault4coalesce

Scalefree's Coalesce Package for Data Vault 2.0 support!
https://www.scalefree.com
Apache License 2.0
5 stars 2 forks source link

Ghost-Records are not being created for TIMESTAMP_NTZ(9) #9

Closed jabibo closed 10 months ago

jabibo commented 11 months ago

In the function ghost_record_per_datatype the ghost records are created with consideration of the datatypes in the target-table. However in our dataset timestamps are of type TIMESTAMP_NTZ(9). This is not in the list .. Additionaly in our table there is a not-null-constraint..this creates an issue

image Version is 1.0.1

tkirschke commented 11 months ago

Hi @jabibo and thanks for reaching out!

I have modified the ghost_record_per_datatype to catch all datatypes that start with "DATE" or "TIMESTAMP". I tried it with a column having the datatype "TIMESTAMP_NTZ(9)" and it worked like a charm.

Additionaly in our table there is a not-null-constraint..this creates an issue.

This should no longer be a problem now!

The modified code can be found in the attached branch. Please check if this version works for you as well and solves the issue. If so, I will happily merge it into main!

Best regards Tim