• 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

Introduces the Snowflake architecture and basic features.

  • Key Concepts & Architecture

    Overview of Snowflake architecture and basic concepts.

  • Snowflake Editions

    Description of the services and features included with each edition of Snowflake.

  • Snowflake Regions

    Description of the different geographical 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 “how to” and “best practices” 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.

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
     
  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 UI 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
     
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
     
Data Loading Tutorials   Using the Tutorials
    Tutorial: Bulk Loading from a Local File System Using COPY
    Tutorial: Bulk Loading from Amazon S3 Using COPY
    Script: Loading JSON Data into a Relational Table
    Script: Loading and Unloading Parquet Data

Using Snowflake

Describes the concepts and tasks associated with using Snowflake.

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 Reference

SQL Command Reference

/sql-reference/ddl-table /sql-reference/ddl-stage /sql-reference/ddl-udf

Links to all the SQL commands (DDL, DML, and query syntax):

Appendices