ADF Copy activity unable to write the JSON data in snowflake table

pankaj chaturvedi 86 Reputation points

Hi Team,

I am extracting JSON data from blob container and loading to snowflake table using Copy Activity in ADF.

I created table CREATE TABLE API_TEST(JSONDATA VARIANT) in snowflake and loading data into API_TEST table . I am not passing any schema mapping. When I passed schema mapping then data is loaded to snowflake but that's not the way to load the JSON data in snowflake as we know Snowflake does support VARIANT Data type feature which hold all the JSON data.

Could you please let me know does ADF support that feature which can load the JSON data in snowflake that table has VARIANT data type field.

I am looking forward your response.

Many thanks,

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,070 questions
{count} votes