Welcome to the Snowflake Documentation

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

Release Notes

Provides a synopsis of supported functionality in the current release, including any notable restrictions or limitations. Also describes new features, enhancements, and fixes introduced in the current release and all previous releases.

Getting Started

  • Introduction to Snowflake

    Overview of Snowflake architecture and technology, including key concepts and terminology.

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

In addition, Snowflake 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.

Managing Snowflake

Using Snowflake

/user-guide/sample-data

Describes the concepts and tasks associated with using Snowflake.

General Reference

SQL Command Reference

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

Data Definition Language (DDL)

  • DDL Command Summary

    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 user operations (CREATE, ALTER, etc.) on warehouses.

  • Database & Schema DDL

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

  • Table & View DDL

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

  • Stage & File Format DDL

    Commands for performing all user 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)

  • 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

Appendices