Snowflake Hands-On | 50 Live Assignments with Practice MCQs

Create a free 30-day Snowflake trial with $400 of usage, set up the standard account on AWS, and activate via email to sign in with your unique URL.

Create a standard Snowflake warehouse of size x-small with auto resume enabled and auto suspend enabled, then run the create warehouse query and verify with show warehouses.

Learn to set the demo warehouse, create a sales DB and a sales table in Snowflake, insert dummy data, and validate results with a select.

Learn to load a CSV file from an AWS S3 bucket into Snowflake using the copy into command, including configuring the CSV file format with comma delimiter and header skip.

Design a stage named S3_stage to load csv data from an S3 bucket into a Snowflake table, verify results with a select, then drop the objects.

Practice transforming data during loading from an S3 stage into a Snowflake table by trimming the complete address to its first five characters using a copy command and a stage.

Load a subset of columns from an S3 file into a Snowflake table using the copy command, creating a stage and a two-column table for order id and customer name.

Tackle assignment seven by loading a csv from S3 into a Snowflake table, creating a warehouse, database, table, and S3 stage, and diagnosing a delimiter error during copy.

Learn to use validation mode with Snowflake's copy command to return errors and reveal detailed load issues, including records rejected due to a comma in the address field in csv.

Learn how on error = continue skips invalid rows during Snowflake loads. Create a database, table, and S3 stage, then run a copy with continue for a partial data load.

Create a sales db and table, set up an S3 stage, and load csv files with copy using on error skip file to skip faulty data and import valid rows.

Design a custom csv file format with a comma delimiter, optional double-quoted fields, and header skip, then load data from an S3 stage into a Snowflake table.

Apply validation mode in the Snowflake copy command to return two rows from an S3 CSV file, validate before loading, then disable validation to load the full data.

Learn how to load data into a Snowflake table using a stage and copy with on error continue and return failed only, capturing failed rows while completing partial loads.

Assignment 15 demonstrates loading data with a ten-character limit on the complete address column, triggering failures, using a stage and copy command with on error continue, verifying results, and cleanup.

Enable truncate columns in Snowflake's copy command to automatically truncate data beyond the defined string length, demonstrated with a ten-character address column during table load.

Explore snowflake load history view to filter error count greater than zero, inspect last load time before yesterday, and diagnose partially loaded or failed data with table, schema, and csv rows.

Create a json database and a json data table in Snowflake with id and variant, load from S3 via a stage and copy, then flatten to extract name, age, city.

Load parquet data from S3 into Snowflake by creating a database and table, configuring an S3 parquet stage, and copying data for verification.

Load avro format data from S3 into a Snowflake table, creating an Avro DB and an Avro data table, then load via a copy command and verify with a select.

Discover how Snowflake Snowpipe loads data in real time from S3 into Snowflake, using serverless auto-scaling and transformation; the assignment guides creating a warehouse, database, table, stage, and CSV format.

Demonstrates creating a Snowpipe named sales pipe with auto ingest, linking to a stage and file format from assignment 21, using a copy query, and verifying no data is loaded.

Recreate and pause a snowpipe using the demo warehouse and database, adding an on error continue feature for robust error handling, then verify the paused execution state.

Set the warehouse to demo and the database to sales db snowpipe, list pipes, unpause the pipe, and trigger a refresh to load data into the table, then monitor status.

Perform end-to-end snowpipe testing with a demo warehouse and s3 stage, recreate snowpipe with error handling, trigger and verify data (order ids 11-15), then drop all resources.

Learn to create a Snowflake task that automates SQL execution, schedules every minute, resumes and suspends the task, and verifies data in a demo database with a sales data task.

Build a task tree in Snowflake with a root task that inserts data every minute and a dependent child task that runs after the root completes.

Create and schedule a daily task in Snowflake using a cron expression set to 10 a.m. UTC, triggered automatically and using the demo warehouse with a dummy insert.

Create a data task in Snowflake that runs every minute, inserts a dummy row, and monitors its status and schedule via information schema task history, then suspend and drop it.

Learn snowflake time travel by creating a demo table, inserting data, updating records, and using offset to retrieve data as it existed minutes earlier.

Demonstrate Snowflake time travel by updating a record, capturing the last query ID, and using before statement to recover original data within a one-day retention window.

Create a database and a permanent table, load data through a stage and copy command, verify with a select, and preview temporary, transient, and external table options.

Explore how to create and use temporary tables in Snowflake, load data via a stage and copy, and verify that temp tables persist only within a session after logout.

Learn to create a transient table in Snowflake, load data from an S3 stage with a copy command, and compare transient and permanent tables on time travel and cost.

Use Snowflake external tables to query data on S3, GCP, or Azure without storing it in Snowflake; create an S3 stage and a CSV external table to query remotely.