Welcome to Snowflake Documentation

_images/sf-hero.jpg

WELCOME TO SNOWFLAKE

DOCUMENTATION

In these topics, you will find the information you need to access your Snowflake account and perform all the administrative and user tasks associated with using Snowflake. 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 using the search box at the top to search across the documentation and other Snowflake resources. If you do not find the information you are looking for, please feel free to reach out to Snowflake Documentation or Snowflake Support using the buttons at the bottom of each page.

Introduction to Snowflake

  • Key Concepts & Architecture

    Overview of Snowflake architecture and basic concepts.

  • Supported Cloud Platforms

    Overview of the cloud computing platforms on which Snowflake is offered.

  • Supported Cloud Regions

    Description of the different cloud platform regions in which Snowflake is offered.

  • Snowflake Editions

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

  • Snowflake Releases

    Description of the Snowflake release process and instructions for requesting 12-hour early access for Enterprise Edition and Business Critical Edition accounts, or 24-hour early access for Virtual Private Snowflake (VPS) accounts.

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

  • Regulatory compliance

    Description of the major regulatory compliance standards Snowflake meets to ensure the highest levels of data assurance, security, and governance for data in Snowflake.

Tutorials and Other Resources

This topic provides links to assorted “how to” tutorials/labs and “best practices” for using Snowflake.

Using Snowflake

Managing Your Snowflake Account

  • Account identifiers

    Detailed descriptions of the two unique account identifiers supported for connecting to Snowflake and using features that span multiple accounts.

  • Trial accounts

    Instructions for signing up for a trial account, adding a credit card to the account, and canceling the account.

  • Parameter management

    Instructions for setting account, session, and object parameters for your account.

  • User management

    Instructions for creating and managing users in your account.

  • Behavior change management

    Instructions for enabling and disabling behavior change releases in your account.

General reference

SQL command reference

  • Query syntax — structure of SQL queries in Snowflake.

  • Query operators — arithmetic, logical, and other types of operators.

  • Data Definition Language (DDL) commands — overview of DDL commands.

  • Data Manipulation Language (DML) commands — commands for performing DML operations, including:

    • Inserting, deleting, updating, and merging data in Snowflake tables.

    • Bulk copying data into and out of Snowflake tables.

    • Staging files for bulk copying.

  • All commands (alphabetical) — alphabetical list of all the commands.

  • Commands categorized by the type of objects and operations they control, including:

    • General account-level objects (accounts, users, roles, security policies, integrations, etc.) and operations (failover & recovery, etc.).

    • Session-based operations (session context, queries, variables, transactions, etc.).

    • Virtual warehouses (for loading data and performing queries) and resource monitors (for controlling credit usage).

    • Databases, schemas, tables, and other schema-level objects (views, sequences, etc.).

    • Snowflake extensions and application development (user-defined functions, stored procedures, scripting, etc.).

    • Objects for sharing data (shares, listings, etc.).

    • Objects for classifying, protecting, and governing data (masking policies, row-access policies, tags, etc.).

Function and stored procedure reference

Snowflake Scripting reference

Appendices