Tutorials to get started with Snowflake¶

The tutorials in this topic provide hands-on examples that get you started with Snowflake. To explore these tutorials, you must have a Snowflake account and a user with the required roles and access to a virtual warehouse:

If you have signed up for a trial account, the trial account user has the required roles and a virtual warehouse that you can use for several of these tutorials.
If you use another account to explore these tutorials, you must sign in as a user that has the required roles and that can use a virtual warehouse.

Each tutorial describes the prerequisites that must be met before completing its tasks, including the roles required for the user who performs the tasks. Several tutorials require the ACCOUNTADMIN and SYSADMIN roles.

Note

Snowflake bills a minimal amount for the on-disk storage that you use for any sample data in these tutorials. Snowflake requires a virtual warehouse to load the data and execute queries. A running virtual warehouse consumes Snowflake credits. After you finish a tutorial, you can drop objects that are created in the tutorial to minimize costs.

If you are using a 30-day trial account, which provides free credits, you won’t incur any costs.

The following sections contain links to tutorials that get you started with Snowflake tasks and features:

Tutorial that introduces you to Snowflake¶

Snowflake provides the following tutorial to introduce you to key concepts and tasks:

Snowflake in 20 minutes: Use SnowSQL, a Snowflake command-line client, to learn about key concepts and tasks.

Tutorials to get started with data engineering¶

Snowflake provides the following tutorials to get you started with data engineering:

Note

These tutorials show you how to load data into a table by using the COPY INTO <table> command. For information about other options for loading data, see Overview of data loading.

Load data¶

Load and query sample data using SQL: Uses a fictitious food truck brand named Tasty Bytes to show you how to load and query data in Snowflake using SQL. You can access a pre-loaded Snowsight template worksheet to complete these tasks.
Load data from cloud storage: Amazon S3: Shows you how to load data from an Amazon S3 bucket into Snowflake using SQL. You can access a pre-loaded Snowsight template worksheet to complete these tasks.
Load data from cloud storage: Microsoft Azure: Shows you how to load data from Microsoft Azure cloud storage into Snowflake using SQL. You can access a pre-loaded Snowsight template worksheet to complete these tasks.
Load data from cloud storage: Google Cloud Storage: Shows you how to load data from Google Cloud Storage into Snowflake using SQL. You can access a pre-loaded Snowsight template worksheet to complete these tasks.

Bulk load data¶

Bulk load from a local file system using COPY: Describes how to bulk load data from files in your local file system into a table.
Bulk load from Amazon S3 using COPY: Describes how to bulk load data from files in an existing Amazon Simple Storage Service (Amazon S3) bucket into a table.

Work with semi-structured data¶

Learn the basics of using JSON with Snowflake: Describes the basics of using JSON with Snowflake.
Load JSON data into a relational table: Uses a COPY INTO <table> command with a SELECT statement to load individual elements in a staged JSON file into a table.
Load and unload Parquet data: Describes how you can upload Parquet data by transforming elements of a staged Parquet file directly into table columns using the COPY INTO <table> command. The tutorial also describes how you can use the COPY INTO <location> command to unload table data into a Parquet file.

Tutorial to get started with security¶

Snowflake provides the following tutorial to get you started with security:

Create users and grant roles: Shows you how to create a user and grant a role to it by using SQL commands. You can access a pre-loaded Snowsight template worksheet to complete these tasks.

Other learning resources¶

These other learning sources are available:

Tutorials: Explore a large repository of tutorials with hands-on examples that help you learn about Snowflake’s features.
Snowflake Education Services: Discover instructor-led classes, on-demand courses, and self-directed learning to get you started with Snowflake.
Snowflake for Developers: Discover product quickstarts, industry-specific use cases, administration best practices, and reference architectures from Snowflake experts and partners.
Snowflake Developers YouTube Channel: Discover Snowflake product tips, demos, and tutorials.