topic Re: Load JSON file to Snowflake Variant Column in Talend Studio

Load JSON file to Snowflake Variant Column

talendstar — Thu, 23 Jul 2020 17:23:52 GMT

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 — Fri, 24 Jul 2020 10:13:05 GMT

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 — Mon, 11 Apr 2022 06:18:51 GMT

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