Load JSON file to Snowflake Variant Column

[talendstar]

I have a JSON file that I would like to upload to Snowflake using Talend.

Snowflake table has a single column of data type variant.

Using Talend is it possible to load the JSON object into Snowflake? I haven't come across a sample job design for this scenario.

Please advise.

thanks

[JohnRMK]

Hello,

you can try with object type or Document for XML in the schema !

Or i you have an entreprise licence, you can use the dynamic schema

[NNot_defined1646723267]

Does this work? I am unable to use strip outer array to true using talend​