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 firstname.lastname@example.org or email@example.com.
Describes new features, enhancements, and fixes introduced in 2017, as well as features that are currently in preview. Also describes changes made to the client software provided by Snowflake and the version requirements for the JDBC and ODBC client drivers.
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.
Seven easy steps to creating a table, loading data into the table from an external file, and querying the table.
Assorted “best practices” and “how to” information for using Snowflake.
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.
Describes how to use the provided clients, connectors, and drivers to connect to Snowflake.
Provides a list of the Snowflake-provided clients, drivers, and connectors, as well as other vendors, tools, and technologies that form the ecosystem for connecting to Snowflake. Also includes links to additional documentation and external resources for installing and configuring the various tools and technologies.
Snowflake CLI Client (sfsql) — Deprecated (use SnowSQL instead)
Instructions for installing, configuring, and using the Node.js driver for Snowflake.
Describes the administrative concepts and tasks associated with managing Snowflake.
Describes the concepts and tasks associated with using Snowflake.
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:
Data Loading — Key concepts and tasks for bulk copying data into a Snowflake table from external files:
- Overview of Data Loading
- Loading Data Using the Web Interface (Limited)
- Loading Data Using SnowSQL
- Transforming Data During a Load
- Data Loading Considerations
- Tutorial: Loading Basic CSV Files Using SnowSQL
- Tutorial: Loading Data from an Internal Stage
- Tutorial: Loading Data from an External Amazon S3 Location
Data Unloading — Key concepts and tasks for bulk copying of data into external files from a Snowflake table:
Queries — Key concepts and tasks for executing queries in Snowflake:
Dates & Timestamps — 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 Data Sharing — Key concepts and tasks for understanding how to produce and consume shared data:
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:
Sample Data Sets — Key concepts and tasks for using the sample data sets provided with Snowflake:
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 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 functions that return a set of rows instead of a single scalar value.
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 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.