Loading Data into Snowflake¶

These topics describe the concepts and tasks for loading (i.e. importing) data into Snowflake database tables.

• Key concepts related to data loading, as well as best practices.

  • Overview of Data Loading

  • Summary of Data Loading Features

  • Data Loading Considerations

• Overview of supported data file formats and data compression.

  • Preparing to Load Data

• Detailed instructions for loading data in bulk using the COPY command.

  • Bulk Loading Using COPY

• Detailed instructions for loading data continuously using Snowpipe.

  • Loading Continuously Using Snowpipe

• Basic instructions for loading limited amounts of data using the web interface.

  • Loading Data Using the Web Interface

• Key concepts and tasks for executing queries on staged data and transforming data while loading it into tables.

  • Querying Data in Staged Files

  • Querying Metadata for Staged Files

  • Transforming Data During a Load

• Instructions for accessing data in other storage.

  • Working With Amazon S3-compatible Storage