Sample Header Ad - 728x90

How can you insert data into a ARRAY column on a Snowflake table using SQL?

2 votes
2 answers
16887 views
I am having difficultly finding documentation on how to insert data into an ARRAY column type using SQL on a Snowflake table. Snowflake Documentation: https://docs.snowflake.net/manuals/sql-reference/data-types-semistructured.html#array // example table CREATE OR REPLACE TABLE array_test_table ( id number, ids array ); // This does not work INSERT INTO array_test_table (id, ids) VALUES (1, '[1,2,3]' ); I have tried using using postgres's syntax like ones described here: https://stackoverflow.com/questions/33335338/inserting-array-values I originally asked this question here: Snowflake Community
Asked by Arthur Putnam (553 rep)
Sep 13, 2018, 03:19 PM
Last activity: Nov 30, 2023, 10:38 PM