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 the Snowflake web interface and other supported clients.

  • Quick Tour of the Web Interface

    Introduction to the main pages in the Snowflake web interface and the tasks you can perform in each page.

  • Snowflake in 20 Minutes

    Step-by-step instructions for using the command line interface to create a database and table, load data into the table from an external file, and query the table.

Also, if you have a Snowflake trial account, you may be interested in this Hands-on Lab.

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 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.

Tutorials, Videos & Other Resources

This topic provides links to assorted “how to” tutorials/labs and “best practices”, as well as videos, 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 Account

Managing Security in Snowflake

Developing Applications in Snowflake

To begin developing applications in Snowflake, you need to first become familiar with some Snowflake basics. This topic will guide you through the foundational tasks required for developing applications in Snowflake. In this topic, you will learn how to:

  • Install and configure the SnowSQL CLI client.

  • Create a virtual warehouse, database, and table.

  • Load data into the table and query the table.

  • Use Python to connect to Snowflake, perform queries, and manipulate the returned data.

You can then use this knowledge to explore the more advanced features and capabilities available in Snowflake.

General Reference

SQL Command Reference

SQL Function Reference

Appendices