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 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.

Next Topics:

Before you begin Overview of Data Loading
  Summary of Data Loading Features
  Data Loading Considerations
   
Preparing to load Preparing to Load Data
   
Loading data Loading Data from a Local File System Using COPY
  Loading Data from Amazon S3 Using COPY
  Loading (Limited) Data Using the Web Interface
   
Transforming data Transforming Data During a Load
   
Tutorials Tutorial: Loading Basic CSV Files from a Local File System Using COPY
  Tutorial: Loading Data from a Local File System Using COPY
  Tutorial: Loading Data from Amazon S3 Using COPY