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 email@example.com or firstname.lastname@example.org.
System prerequisites and requirements for using Snowflake.
Instructions for connecting to Snowflake using the Snowflake web interface and other supported clients.
Introduction to the main pages in the Snowflake web interface and the tasks you can perform in each page.
Step-by-step instructions for creating a database and table, loading data into the table from an external file, and querying the table.
Overview of Snowflake architecture and basic concepts.
Description of the services and features included with each edition of Snowflake. Also describes the different regions in which Snowflake is offered.
List of key/major features in the current release of Snowflake.
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.
Introduction to the powerful and unique features that Snowflake provides for ensuring your data is protected, secure, and available.
Assorted “best practices” and “how to” information for using Snowflake.
Describes new features, enhancements, and fixes introduced in recent releases of Snowflake, as well as features that are currently in preview. Also describes changes made to the client software provided by Snowflake and the required versions of the JDBC and ODBC client drivers.
Provides an overview of the Snowflake-provided and 3rd-party tools and technologies that form the ecosystem for connecting to Snowflake. Also provides installation and usage instructions for using the Snowflake-provided clients, connectors, and drivers.
Instructions for installing, configuring, and using the Node.js driver for Snowflake.
Introduction to the Go driver for Snowflake, with links to the driver code and documentation in Github.
Introduction to the Snowflake .NET driver, with links to the driver code and documentation in Github.
Instructions for testing issues related to the CRL and OCSP checks performed by Snowflake clients.
sfsql (CLI Client) — Deprecated (use SnowSQL instead)
Using the Web Interface — Basic usage information for the web interface, as well as more detailed usage information for the Worksheet and History pages:
Virtual Warehouses — Key concepts and tasks for creating and using virtual warehouses to execute queries and perform DML operations, such as loading and unloading data:
Databases, Tables & Views — Key concepts and tasks related to understanding and working with Snowflake databases and tables:
Queries — Key concepts and tasks for executing queries in Snowflake:
Date & Time Data — Reference information and examples for working with dates, times and timestamps, and time zones in Snowflake:
Semi-structured Data — Key concepts and tasks for working with JSON and other types of semi-structured data:
Binary Data — Reference information and examples for working with binary data in Snowflake:
Snowflake Time Travel & Fail-safe — Key concepts and tasks for understanding how Snowflake maintains access to deleted and modified data, and also how Snowflake enables data recovery in the event of loss:
Snowflake Data Sharing — Key concepts and tasks for understanding how to produce and consume shared data:
Sample Data Sets — Key concepts and tasks for using the sample data sets provided with Snowflake:
Provides concepts and tasks for loading (i.e. importing) data into Snowflake database tables, as well as unloading (i.e. exporting) data from tables.
|Data Loading||Before you begin||Overview of Data Loading|
|Summary of Data Loading Features|
|Data Loading Considerations|
|Preparing to load||Preparing to Load Data|
|Loading data using COPY||Loading Data from a Local File System Using COPY|
|Loading Data from Amazon S3 Using COPY|
|Loading Data from Microsoft Azure Using COPY|
|Loading (Limited) Data Using the Web Interface|
|Loading data using Snowpipe||Loading Data Continuously Using Snowpipe|
|Querying or transforming staged data||Querying Staged Data|
|Querying Metadata Columns|
|Transforming Data During a Load|
|Data Unloading||Before you begin||Overview of Data Unloading|
|Summary of Data Unloading Features|
|Data Unloading Considerations|
|Preparing to unload data||Preparing to Unload Data|
|Using COPY to unload data||Unloading into a Snowflake Stage|
|Unloading into Amazon S3|
|Unloading into Microsoft Azure|
Describes the administrative concepts and tasks associated with managing your account in Snowflake. These topics are intended primarily for administrators (i.e. users with the ACCOUNTADMIN, SYSADMIN, or SECURITYADMIN roles).
Describes the administrative concepts and tasks associated with managing account, user, and data security Snowflake. These topics are intended primarily for administrators (i.e. users with the ACCOUNTADMIN, SYSADMIN, or SECURITYADMIN roles).
List of security features, grouped by category (access, authentication, etc.).
Concepts and tasks for controlling site access through network policies and IP whitelisting/blacklisting.
Using AWS PrivateLink to secure private/direct communication between Snowflake and your other VPCs.
Concepts and tasks for managing and using multi-factor authentication for more secure user login.
Concepts related to how Snowflake automatically encrypts your data, as well as additional features you can enable for enhanced levels of encryption.
Provides general reference information for using Snowflake.
List of data types, commands, and other SQL constructs supported by Snowflake. Can be used as an overview or quick reference.
Parameters that specify behavior at the account, user, session, and object level.
Snowflake supported data types.
Formats for specifying conversion of numeric and date/time values to and from text strings.
Rules for defining and using object identifiers, including resolving object names used in SQL statements.
Concepts and reference for defining and using variables in sessions.
Concepts and reference for using transactions with SQL statements.
Concepts and reference for using literals and functions that return a set of rows instead of a single scalar value in queries.
Concepts and reference for the Snowflake Information Schema, which consists of a set of metadata views and table functions that can be used to query/report on objects in Snowflake.
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
Summary of the base DDL commands (ALTER, CREATE, DESC, DROP, SHOW, etc.).
Commands for performing account-level and session operations.
Commands for managing users and roles, and controlling user access to objects through roles.
Commands for performing all operations (CREATE, ALTER, etc.) on warehouses.
Commands for performing all operations (CREATE, ALTER, etc.) on databases and schemas.
Commands for performing all operations (CREATE, ALTER, etc.) on tables and views.
Commands for performing all operations (CREATE, ALTER, etc.) on file formats and stages, which can be used for data loading/unloading.
Commands for performing all user operations (CREATE, ALTER, etc.) on UDFs.
Data Manipulation Language (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.
Provides links to the system-defined operators and functions.
Operators for performing arithmetic, comparison, and logical operations on expressions.
List of all system-defined scalar and table functions.
Functions for performing bitwise operations on expressions.
Functions for working with conditional expressions.
Functions that provide contextual information for the current environment, session, and object.
Functions for performing rounding, truncation, exponent, root, logarithmic, and trigonometric operations on numbers.
Functions for performing operations on string input.
Subset of strings functions for performing operations on items that match a regular expression.
Functions for manipulating dates and timestamps.
Functions for working with semi-structured data (JSON, Avro, etc.).
Functions for converting strings to Snowflake data types.
Functions that operate on values across rows to perform operations including counts, distincts, mathematical operations, approximate cardinality estimation, etc.
Functions that compute an aggregate over a group of rows.
Utility functions, data generation functions, and random distribution functions.