cancel
Showing results for 
Search instead for 
Did you mean: 

Array datatype replication from Postgress to Snowflake-Unsupported data type '_TEXT'

a658664
New Contributor

Hello team, I may need to replicate Array datatype column  from Postgress to Snowflake Was unable to figure out exact options.

Source column : field1 text[] COLLATE pg_catalog."default",

Once Source table is added to Channel datatype of array column goes as  extended <<_TEXT>>

during refresh/replication  to target It throws "DBMS error [SQL compilation error: Unsupported data type '_TEXT']. DBMS error number [2040]. SQL State [42601]

Below Column properties have been added In Channel Actions :

CaptureExpression: array_to_string(ARRAY[{{hvr_col_name}}],",")

IntegrateExpression : STRTOK_TO_ARRAY(ARRAY[{{hvr_col_name}}],",")

CaptureExpressionType: SQL_WHERE_ROW

1 REPLY 1

a658664
New Contributor

Hello HVR team, Could you please help to get the response  to the above question