Tutorials and Other Resources¶

This topic provides links to assorted “how to” tutorials/labs and “best practices” for using Snowflake.

Tutorials¶

Snowflake provides several tutorials for getting started.

You will need a Snowflake account to explore these tutorials. If you sign up for a trial account, the trial account has a user with necessary roles (ACCOUNTADMIN and SYSADMIN) and a virtual warehouse (COMPUTE_WH) needed to explore this tutorial. If you use any other account to explore this tutorial, then make sure your user is granted these roles and the account has the virtual warehouse.

For new users, we recommend you start with these tutorials:

• Snowflake in 20 minutes — A simple tutorial using SnowSQL, the Snowflake command-line client, to introduce key concepts and tasks.
• Getting Started with Snowflake - Zero to Snowflake (https://quickstarts.snowflake.com/guide/getting_started_with_snowflake/index.html) — A comprehensive tutorial that uses both SnowSQL and Snowsight covers data loading, querying, working with semi-structured data, accessing historical data using Snowflake’s Time Travel feature, sharing, and so on.
• Getting Started with Python (https://quickstarts.snowflake.com/guide/getting_started_with_python/index.html) — A tutorial in which you set up the Python Connector and then explore the basic operations you can do with it.

For tutorials on bulk loading, see:

• Bulk Loading from a Local File System
• Bulk Loading from Amazon S3

In addition, you might explore the following pages that introduce important concepts about semi-structured data:

• JSON Basics
• Loading JSON Data into a Relational Table
• Loading and Unloading Parquet Data

Best Practices¶

Snowflake best practices are provided throughout the documentation. The following are links to important practices related to Snowflake features:

• Roles and Access Control
• Virtual Warehouses
• Table Design
• Data Storage
• Data Loading
• Data Unloading
• Semi-structured Data

Sample Data Sets¶

The following benchmarking datasets are available for all Snowflake accounts:

• TPC-DS
• TPC-H

In addition, Snowflake Marketplace is where you can find additional data sets, provided by third-parties, for use with Snowflake. For related documentation, refer to Introduction to the Snowflake Marketplace.