Data Loading

Snowflake supports bulk import (i.e. loading) of data from one or more files into a table in Snowflake databases using the COPY command. Snowflake also supports loading limited amounts of data through the web interface.

Snowflake supports loading data from the following file formats:

  • Any flat, delimited plain text format (CSV, TSV, etc.).
  • Semi-structured data in JSON, Avro, ORC, Parquet, or XML format (XML is currently supported as a preview feature).

As data is loaded, Snowflake compresses the data and converts it into an optimized internal format for efficient storage, maintenance, and retrieval.

Next Topics: