05-31-2023 06:59 AM
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
06-06-2023 10:42 PM
Hello HVR team, Could you please help to get the response to the above question