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

Release Notes

Describes new features, enhancements, and fixes introduced in 2017, as well as features that are currently in preview. Also describes changes made to the client software provided by Snowflake and the version requirements for the JDBC and ODBC client drivers.

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 10 Minutes

    Seven easy steps to creating a table, loading data into the table from an external file, and querying the table.

Tutorials, Videos & Other Resources

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

Introduction to Snowflake

Introduces the Snowflake architecture and basic features.

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

  • Summary of Supported SQL

    List of data types, commands, and other SQL constructs supported by Snowflake. Can be used as an overview or quick reference.

  • Summary of Data Loading Features

    Lists the main features supported for bulk loading data into Snowflake tables. Can be used as an overview or quick reference.

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

Connecting to Snowflake

Describes how to use the provided clients, connectors, and drivers to connect to Snowflake.

Using Snowflake

Describes the concepts and tasks associated with using Snowflake.

General 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

  • DDL Commands

    List of the base DDL commands (ALTER, CREATE, DESC, DROP, SHOW, etc.).

  • User & Security DDL

    Commands for managing users and roles, and controlling user access to objects through roles.

  • Warehouse & Resource Monitor DDL

    Commands for performing all operations (CREATE, ALTER, etc.) on warehouses.

  • Database & Schema DDL

    Commands for performing all operations (CREATE, ALTER, etc.) on databases and schemas.

  • Table, View & Sequence DDL

    Commands for performing all operations (CREATE, ALTER, etc.) on tables and views.

  • Stage & File Format DDL

    Commands for performing all operations (CREATE, ALTER, etc.) on file formats and stages, which can be used for data loading/unloading.

  • User-Defined Function DDL

    Commands for performing all user operations (CREATE, ALTER, etc.) on UDFs.

  • Miscellaneous DDL

    Commands for cloning objects, creating sequences, and performing other, various DDL operations.

Data Manipulation Language (DML) Commands

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

Function Reference

Provides links to the system-defined operators and functions.

Appendices