• Docs »
  • Welcome to the Snowflake Documentation

Welcome to the Snowflake Documentation

In these topics, you will find all the information you need to access your Snowflake account and perform all the administrative and user tasks associated with using the Snowflake service. The documentation also provides conceptual overviews, tutorials, and a detailed reference for all supported SQL commands, functions, and operators.

You can start by browsing the contents on the left or searching the documentation (and other information resources provided by Snowflake). If you do not find the information you are looking for, please don’t hesitate to reach out to us at doc-feedback@snowflake.net or support@snowflake.net.

Getting Started

  • Before You Begin

    System prerequisites and requirements for using Snowflake.

  • Logging into Snowflake

    Instructions for connecting to Snowflake using the Snowflake web interface and other supported clients.

  • Quick Tour of the Web Interface

    Introduction to the main pages in the Snowflake web interface and the tasks you can perform in each page.

  • Snowflake in 20 Minutes

    Step-by-step instructions for creating a database and table, loading data into the table from an external file, and querying the table.

Introduction to Snowflake

  • Key Concepts & Architecture

    Overview of Snowflake architecture and basic concepts.

  • Snowflake Editions & Regions

    Description of the services and features included with each edition of Snowflake. Also describes the different regions in which Snowflake is offered.

  • Overview of Key Features

    List of key/major features in the current release of Snowflake.

  • Overview of the Data Lifecycle

    Introduction to the main tasks (and corresponding SQL commands) for getting your data into Snowflake and then using it to perform queries and other SQL operations.

  • Continuous Data Protection

    Introduction to the powerful and unique features that Snowflake provides for ensuring your data is protected, secure, and available.

Tutorials, Videos & Other Resources

Assorted “best practices” and “how to” information for using Snowflake.

Release Notes

Describes new features, enhancements, and fixes introduced in recent releases of Snowflake, as well as features that are currently in preview. Also describes changes made to the client software provided by Snowflake and the required versions of the JDBC and ODBC client drivers.

Connecting to Snowflake

Provides an overview of the Snowflake-provided and 3rd-party tools and technologies that form the ecosystem for connecting to Snowflake. Also provides installation and usage instructions for using the Snowflake-provided clients, connectors, and drivers.

Using Snowflake

Loading Data in Snowflake

Provides concepts and tasks for loading (i.e. importing) data into Snowflake database tables, as well as unloading (i.e. exporting) data from tables.

Data Loading Before you begin Overview of Data Loading
    Summary of Data Loading Features
    Data Loading Considerations
  Preparing to load Preparing to Load Data
  Loading data using COPY Loading Data from a Local File System Using COPY
    Loading Data from Amazon S3 Using COPY
    Loading Data from Microsoft Azure Using COPY
    Loading (Limited) Data Using the Web Interface
  Loading data using Snowpipe Loading Data Continuously Using Snowpipe
  Querying or transforming staged data Querying Staged Data
    Querying Metadata Columns
    Transforming Data During a Load
Data Unloading Before you begin Overview of Data Unloading
    Summary of Data Unloading Features
    Data Unloading Considerations
  Preparing to unload data Preparing to Unload Data
  Using COPY to unload data Unloading into a Snowflake Stage
    Unloading into Amazon S3
    Unloading into Microsoft Azure

Managing Your Snowflake Account

Describes the administrative concepts and tasks associated with managing your account in Snowflake. These topics are intended primarily for administrators (i.e. users with the ACCOUNTADMIN, SYSADMIN, or SECURITYADMIN roles).

Managing Security in Snowflake

Describes the administrative concepts and tasks associated with managing account, user, and data security Snowflake. These topics are intended primarily for administrators (i.e. users with the ACCOUNTADMIN, SYSADMIN, or SECURITYADMIN roles).

General SQL Reference

Provides general reference information for using Snowflake.

SQL Command Reference

Provides links to all the SQL commands, first listed alphabetically and then grouped by type (DDL or DML) and category.

Commands in Alphabetical Order

Data Definition Language (DDL) Commands

Data Manipulation Language (DML) Commands

  • Overview of DML Commands

    Commands for performing the following operations:

    • Inserting, deleting, updating, and merging data in Snowflake tables.
    • Bulk copying data into and out of Snowflake tables.

Operator & Function Reference

Provides links to the system-defined operators and functions.