I am trying to ETL from Postgres to Snowflake. The datatype of the column in Postgres is "jsonb" and can someone please let me know what the target column data type in Snowflake should be?
1 Answers
In Snowflake you can use the VARIANT datatype for semi-structured data like JSON.
Or if your root object will always be an OBJECT or ARRAY, you can use one of those.
Related