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 the following file formats for data loading:
- Any flat, delimited plain text format (comma-separated values, tab-separated values, 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 converts the data into an optimized internal format for efficient storage, maintenance, and retrieval.