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.

Getting Started

  • Before You Begin

    System prerequisites and requirements for using Snowflake once your account has been provisioned.

  • Logging into Snowflake

    Instructions for connecting to Snowflake using Partner Connect and supported clients.

  • Snowsight Quick Tour

    Introduction to the main pages in the Snowsight and the tasks you can perform in 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 24-hour early access for Enterprise Edition (and higher) 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.

Release Notes

These topics describe the new features, enhancements, and fixes introduced in recent and previous releases of Snowflake, as well as the features that are currently in preview. They also describe the required versions for the client software provided by Snowflake and the changes introduced in each client version.

Connecting to Snowflake

Loading Data into Snowflake

Unloading Data from Snowflake

Using Snowflake

Managing Your Snowflake Organization

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.

Managing Security in Snowflake

Managing Cost in Snowflake

General Reference

SQL Command Reference

  • Query Syntax — structure of SQL queries in Snowflake.

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

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

  • DML (Data Manipulation Language) 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, includng:

    • General account-level objects (accounts, users, roles, securty 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.).

    • Snoflake 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 polcies, row-access polcies, tags, etc.).

SQL Function Reference

API Reference

APIs for connecting to Snowflake

Connector / Driver / Client API

Resources

Go Driver

JDBC Driver

.NET Driver

Node.js Driver

ODBC Driver

PHP PDO Driver

Snowflake Connector for Kafka

Snowflake Connector for Python

Snowflake Connector for Spark

Snowflake SQL API


APIs for extending Snowflake:

Extensibility Feature

Resources

User-Defined Functions (UDFs)

Snowpark for Scala

Snowpark for Java

Snowpark for Python

External Functions

Stored Procedures

Appendices

Back to top