Anthony Shook
03/27/2025, 3:16 PMtransferwise
variant of target-snowflake
to the meltanolabs
variant:
ERROR:sqlconnector:Error adapting column type for [REDACTED] 'TIMESTAMP_TZ' to 'TIMESTAMP_NTZ' (new sql type)
I’m using Meltano 3.5.4 in a Docker container (python 3.12), with target-snowflake version target-snowflake v0.15.1.post5+20e07d0, Meltano SDK v0.44.3
Is there an easy fix for this, or am I going to have to do a lot of column re-cycling by hand?Anthony Shook
03/30/2025, 9:46 PMmeltanolabs
adapter wants to insert by default as timestampNTZ
and varchar
respectively.
Again, for posterity, the basic operation is:
• Make new column of desired format (e.g., TIMESTAMPNTZ
)
• copy data from original column into that new column in that format.
• drop original column (or rename original column to something like column_backup
)
• Rename new column with the original column’s name.