An issue I’m having with switching from the `trans...
# troubleshooting
a
An issue I’m having with switching from the
transferwise
variant of
target-snowflake
to the
meltanolabs
variant:
Copy code
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?
FWIW, I ended up just writing a python script to go through and cycle in/out new columns of these types. This specifically affects timestamptz and variant columns in snowflake, which the
meltanolabs
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.