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.
Before you begin Overview of Data Loading Summary of Data Loading Features Data Loading Considerations Preparing to load Preparing to Load Data Using COPY to load data Bulk Loading from a Local File System Using COPY Bulk Loading from Amazon S3 Using COPY Bulk Loading from Microsoft Azure Using COPY Using Snowpipe to load data Loading Continuously Using Snowpipe Using the Interface to load data Loading Using the Web Interface (Limited) Querying or transforming staged data Querying Staged Data Querying Metadata for Staged Files Transforming Data During a Load