Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Does this work? I am unable to use strip outer array to true using talend