Semi-structured Data

Data can come from many sources, including applications, sensors, and mobile devices. To support these diverse data sources, semi-structured data formats have become popular standards for transporting and storing data.

Snowflake provides built-in support for importing data from (and exporting data to) the following semi-structured data formats:

  • JSON

  • Avro

  • ORC

  • Parquet

  • XML

Snowflake provides native data types (ARRAY, OBJECT, and VARIANT) for storing semi-structured data.

Snowflake also provides native support for querying semi-structured data.

Next Topics: