I am trying to import a JSON array into Snowflake as either an ARRAY or VARIANT data type.
When I try to configure this in my import mapping, the result is this error:
SQL compilation error:
Unsupported data type 'VARIANT'.
Error ID: 484461026
Classification : Connection
In snowflake this JSON array is mapped to a column with either the ARRAY or VARIANT data type (both fail with the same error above.
Please sign in to leave a comment.