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 the current release and previous releases.

Introduction to Snowflake

Introduces the Snowflake architecture and basic features.

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

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

Tutorials & Other Resources

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

Connecting to Snowflake

Describes how to use the provided clients, connectors, and drivers to connect to Snowflake. Note that Snowflake also provides a web-based user interface, for executing queries and performing most other Snowflake operations, including tasks such as managing Snowflake users, starting/stopping virtual warehouses, and creating/managing databases and tables.

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.

All Commands — Alphabetical

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