CODEWITHSUNDEEP
jsonfile-uploadcopysnowflake-cloud-data-platformsnowflake-schema
Lesly Premsingh C
Lesly Premsingh C

Reputation: 65

Load data into snowflake table which has more than 1 column from json file

I got this link from snowflake site "https://youtu.be/H0sbMDqdYQ8" ,were they are trying load from json file with copy command ,where the table has 4 column of the 2 are variant.i am trying the same ,but when try load the json file with copy command with file format as JSON ,its throws error "SQL compilation error: JSON/XML/AVRO file format can produce one and only one column of type variant or object or array. Use CSV file format if you want to load more than one column." how to load a json file into a table which has more than one column.my requirement is same as the above youtube link ...

Upvotes: 0

Views: 5865

Answers (1)

Angelica Coleman
Angelica Coleman

Reputation: 11

In the example from Snowflake's docs, data-load-transform check out the section Load semi-structured Data into Separate Columns and you'll be able to load multiple columns of a table.

Upvotes: 1

Related Questions