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.
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.
Introduces the Snowflake architecture and basic features.
Overview of Snowflake architecture and basic concepts.
Description of the services and features included with each edition of Snowflake.
Description of the different geographical 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 “how to” and “best practices” 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.
Obsoleted — sfsql (use SnowSQL instead)
Provides concepts and tasks for loading (i.e. importing) data into Snowflake database tables, as well as unloading (i.e. exporting) data from tables.
Describes the concepts and tasks associated with using Snowflake.
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:
Sample Data Sets — Key concepts and tasks for using the sample data sets provided with Snowflake:
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:
Parameters — parameters that can be used control system behavior at the account, user, session, and object level.
Data Types — supported data types (VARCHAR, NUMBER, DATE, etc.) in Snowflake.
SQL Format Models — formats for specifying conversion of numeric and date/time values to and from text strings.
Object Identifiers — rules for defining and using object identifiers, including resolving object names used in SQL statements:
Constraints — concepts and reference information for defining and maintaining unique, primary key, and foreign key constraints in tables:
SQL Variables — concepts and reference for defining and using variables in sessions.
Transactions — concepts and reference for using transactions with SQL statements.
Table Literals / Functions — concepts and reference for using literals and functions that return a set of rows instead of a single scalar value in queries.
Information Schema — concepts and reference for the Snowflake Information Schema, which consists of a set of metadata views and historical table functions for querying/reporting on objects in Snowflake.
Account Usage — concepts and reference for the SNOWFLAKE shared database, which is provided by Snowflake for querying/reporting on your account and object usage.
Links to all the SQL commands (DDL, DML, and query syntax):
Summary of Commands — combined list of all the commands and query syntax. Can be used as a quick-reference.
Commands (Alphabetical) — alphabetical list of all the commands.
DDL Commands (by Category) — commands categorized by the type of objects they control:
DML Commands (by Category) — commands for performing the following DML operations:
- Inserting, deleting, updating, and merging data in Snowflake tables.
- Bulk copying data into and out of Snowflake tables.
- Staging files for bulk copying.
Query Constructs — structure of SQL queries in Snowflake:
Links to the system-defined operators and functions:
Summary of Operators & Functions — combined list of all the system-defined operators and functions. Can be used as a quick-reference.
Operators — operators for performing arithmetic, comparison, and logical operations on expressions.
Functions (Alphabetical) — alphabetical list of all system-defined functions (scalar and table).
Functions (by Category) — scalar functions categorized by type:
- Bitwise Expression Functions
- Conditional Expression Functions
- Context Functions
- Numeric Functions
- String & Binary Functions
- Regular Expression (String) Functions
- Date & Time Functions
- Semi-structured Data Functions
- Conversion Functions
- Aggregate Functions
- Analytic / Window Functions
- Miscellaneous Functions