SnowFlake BUG , NULLIF in timestamp_ntz (Failed to cast variant value "" to TIMESTAMP_NTZ)

dbt-labs / dbt-external-tables

dbt macros to stage external sources

https://hub.getdbt.com/dbt-labs/dbt_external_tables/latest/

Apache License 2.0

294 stars 119 forks source link

SnowFlake BUG , NULLIF in timestamp_ntz (Failed to cast variant value "" to TIMESTAMP_NTZ) #185

Closed JoseRFJuniorLLMs closed 7 months ago

JoseRFJuniorLLMs commented 1 year ago

Describe the bug

Generating external tables in SnowFlake works very well, but when you use the dbt to do this, it generates errors in the validation of fields that come null for timestamp_ntz.

CREATE OR REPLACE EXTERNAL TABLE EX_USERS ( deleted_at timestamp_ntz as (NULLIF(value :deleted_at, '')::timestamp_ntz)

dbt

name: deleted_at data_type: timestamp_ntz description: "deleted_at"`

Failed to cast variant value "" to TIMESTAMP_NTZ

github-actions[bot] commented 7 months ago

This issue has been marked as Stale because it has been open for 180 days with no activity. If you would like the issue to remain open, please comment on the issue or else it will be closed in 7 days.

github-actions[bot] commented 7 months ago

Although we are closing this issue as stale, it's not gone forever. Issues can be reopened if there is renewed community interest. Just add a comment to notify the maintainers.