Snowflake in 20 Minutes

This tutorial uses the Snowflake command line client, SnowSQL, to introduce key concepts and tasks, including:

• Creating required Snowflake objects (databases, tables, etc.) for storing and querying data.

• Loading a small amount of sample data from CSV files into a table.

• Querying the table.

Note

This tutorial requires a virtual warehouse to load the sample data and execute queries. A running virtual warehouse consumes Snowflake credits; however, the number of credits consumed in this tutorial will be minimal because the entire tutorial can be completed in under 30 minutes.

In addition, your account will be billed a minimal amount for the on-disk storage required for the sample data in this tutorial, unless you choose to drop the table at the end of the tutorial.

Before You Begin:

• Prerequisites

Steps:

• Step 1. Log into SnowSQL
• Step 2. Create Snowflake Objects
• Step 3. Stage the Data Files
• Step 4. Copy Data into the Target Table
• Step 5. Query the Loaded Data
• Step 6. Summary and Clean Up