What is JSON?
In comparison to flat files like CSVs, which use relational “columns and rows”, JSON files store data in nested Objects and Arrays, which themselves contain values. This structure is highly adaptable to the addition of new data, meaning that the collection of data doesn’t need to be limited by the columns within the data source.
Analytics for for SEMI-Structured DATA with Snowflake
Snowflake is unusual in that it can natively support JSON (and other semi-structured data) alongside relational data. Most databases and data stores only support one format. With Snowflake, users can choose to “flatten” nested objects into a relational table, or store the Objects and Arrays in their native format within the VARIANT data type. Semi-structured data can be manipulated with ANSI-standard SQL, with the addition of dot notation.