Welcome to the Snowflake Documentation¶
In these topics, you will find the information you need to access your Snowflake account and perform all administration and user tasks. The documentation also provides conceptual overviews and a reference for all supported SQL commands, functions, and operators.
Provides a synopsis of supported functionality in the current release, including any notable restrictions or limitations. Also describes new features, enhancements, and fixes introduced in the current release and all previous releases.
Overview of Snowflake architecture and technology, including key concepts and terminology.
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.
Eight 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.
Describes how to use the provided clients, connectors, and drivers to connect to Snowflake.
Instructions for installing, configuring, and using the Node.js driver for Snowflake.
In addition, Snowflake provides a web-based user interface, for executing queries and performing most other Snowflake operations, including tasks such as managing Snowflake users, starting/stopping virtual warehouses, and creating/managing databases and tables.
- Preview — Managing Resource Monitors — Concepts and tasks for creating and managing resource monitors, used to control credit usage by warehouses.
Instructions for setting account, session, and object parameters for your account.
- Using Multi-Factor Authentication — Enabling and using multi-factor authentication for user login.
- Enabling Federated Authentication and SSO — Enabling SSO for user login.
- Understanding the Access Control Model — Enabling and using access control to secure objects in Snowflake.
- Migrating to the Access Control Model — Instructions for enabling access control on an existing account.
- Access Control Considerations — Best practices, general guidelines, and important considerations for configuring access control.
Describes the concepts and tasks associated with using Snowflake.
Introduction to organizing, storing, querying, maintaining, and removing data in Snowflake.
Key concepts and tasks related to understanding and working with Snowflake databases and tables:
Key concepts and tasks for bulk copying data into a Snowflake table from external files:
- Overview of Data Loading
- Requirements and Options for Data Loading/Unloading
- Metadata for Data Loading/Unloading
- Configuring S3 Buckets
- Preparing to Load
- Loading from Snowflake Locations
- Loading from External Locations
- Loading Semi-structured Data
- Monitoring Data Loading/Managing Data Files
- Data Loading Considerations
- Tutorial: Loading Data from an Internal Stage
- Tutorial: Loading Data from an External Amazon S3 Location
Key concepts and tasks for bulk copying of data into external files from a Snowflake table:
Reference information and examples for working with dates, times and timestamps, and time zones in Snowflake:
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 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, a set of metadata views 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.
List of SELECT, DDL, and DML commands in alphabetical order.
Data Definition Language (DDL)
List of the base DDL commands (ALTER, CREATE, DESC, DROP, SHOW, etc.).
Commands for managing users and roles, and controlling user access to objects through roles.
Commands for performing all user operations (CREATE, ALTER, etc.) on warehouses.
Commands for performing all user operations (CREATE, ALTER, etc.) on databases and schemas.
Commands for performing all user operations (CREATE, ALTER, etc.) on tables and views.
Commands for performing all user 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.
Commands for cloning objects, creating sequences, and performing other, various DDL operations.
Data Manipulation Language (DML)
Commands for performing the following operations:
- Inserting, deleting, updating, and merging data in Snowflake tables.
- Bulk copying data into and out of Snowflake tables.
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.