Hands On ESSENTIALS

WebUI Essentials Lesson 1 – User Roles

After this lesson you’ll be able to answer the following questions:

• What is the functional effect of the default role setting?
• What are the four roles set up automatically by Snowflake in each Snowflake account?
• How do the navigation options vary by role?

And you’ll be able to carry out tasks like:

• Change your current role. 
• Identify your default role. 

WebUI Essentials Lesson 2 – Database Navigation

After this lesson, you’ll be able to carry out tasks like: 

• Identify the current database, schema, and object when shown a breadcrumb trail. 
• View/hide the privileges of a database or database object. 
• Drill into a database or database object. 
• Orient yourself in the Databases area using the tab highlight and breadcrumb in the GUI. 

WebUI Essentials Lesson 3 – Data Exploration

After this lesson, you’ll be able to carry out tasks like: 

• Identify the navigation tree, results/preview pane and SQL entry pane in the Worksheets area. 
• Use the navigation tree to preview data from a table.
• Use a shortcut to input a fully-qualified database object name into the SQL entry pane. 
• Run a simple SQL query. 
• Output results to the system clipboard. 
• Output results to a CSV or TSV file. 

WebUI Essentials Lesson 4 – Introduction to Warehouses

After this lesson you’ll  be able to answer the following questions:  

• What two settings are needed to configure an elastic warehouse that are not needed for a single cluster warehouse? 
• What is “code highlight” and what are the benefits to having it turned on?

And you’ll be able to carry out tasks like: 

• Create a warehouse
• Edit an existing warehouse
• Toggle the Code Highlight feature off and on. 
• Use the Context Menu in the Worksheets area to set the warehouse and view the current size and state of your warehouses.
• Identify your current account as multi-cluster/elastic or single cluster by viewing warehouses in the Warehouse area.
• Write a SQL statement that changes the current warehouse context. 

WebUI Essentials Lesson 5 – Creating Database Objects

After this lesson, you’ll be able to carry out tasks like: 

• Create a database. 
• Create a table. 
• Create a file format.
• Load a file using the load wizard. 

And, you’ll be able to answer questions like: 

•  What is the difference between a column separator and a field enclosure in a Snowflake file format? 
• Which of the two settings allows for custom (“other”) characters like tildes and which is limited to just a few options or “none”?

WebUI Essentials Lesson 6 – Transforming Data

After this lesson you’ll  be able to answer the following questions: 

• What do ETL and ELT stand for?
• What are some simple SQL functions that can be used to transform data? 

And you’ll be able to carry out tasks like: 

• Use the REPLACE function in a SQL statement. 
• Use the CONCAT function in a SQL statement. 
• Use the pipe symbol to concatenate data in a SQL statement. 
• Load an external script into the Snowflake Worksheets area. 
• Use comments in SQL worksheets. 

WebUI Essentials Lesson 7 – Advanced Warehousing Concepts

After this lesson you’ll  be able to answer the following questions: 

• How do the concepts of real-world warehouses map to data warehousing? 
• How do Snowflake warehouses compare to and differ from data marts? 
• What is the difference between scaling up and down versus scaling in and out? 
• Which scaling processes are manual and which are automated? 
• What two settings can be configured for elastic warehouses that are not available for standard warehouses? 
• Which Snowflake Editions have elastic warehouses? 
• How is the process of adding servers to a warehouse different than adding clusters? 

WebUI Essentials Lesson 8 – Data Stages

After this lesson you’ll be able to carry out tasks like: 

• Create and configure and external stage (Amazon S3)
• Navigate files and query data within an external stage. 
• Load data from an external stage into a table using the COPY INTO command. 
• Define “stage” or “staging area” in a way that covers both real-world warehouses and data warehouses.

And, answer questions like:

• What are the two types of Snowflake Stages and which type requires a cloud services account?
• What are the three cloud services providers supported by Snowflake for use with external stages?
• What are the three components needed to configure an External Stage in Snowflake? (S3)

WebUI Essentials Lesson 9 – Data Storage Structures

After this lesson you’ll be able to carry out tasks like:

• Create a sequence. 
• Use the Sequence Next Value function in a select statement.
• Use the Sequence Next Value function in a table column’s default value.
• Describe how a sequence can be used when assigning a unique id to a database record. 
• Interpret a simplified ERD.
• Predict the values output from Sequence object, based on the initial value and interval settings. 
• Match the concepts of entity, attribute and value to their storage counterparts of table, column and row.

WebUI Essentials Lesson 10 – Semi-Structured Data

After this lesson you’ll be able to answer questions like: 

• What are the five semi-structured data formats that can be easily ingested into Snowflake? 
• What data type is used when creating a table column that will hold semi-structured data? 
• What file format setting for a semi-structured file format will separate each record into its own row? 
• What do the terms DDL and DML mean, and what are some examples of each type? 

And, you’ll be able to carry out tasks like: 

• Create an XML file format, load XML data and query it. 
• Create a JSON file format, load JSON data and query it.  

WebUI Essentials Lesson 11 – Nested Semi-Structured Data

After this lesson you’ll be able to carry out tasks like: 

• Describe the general structure of Twitter data, including the concept of nested entities. 
• Describe how an understanding of object models are necessary to use PATH statements in JSON queries. 
• Describe the role of the FLATTEN function for saving development time and resources so that semi-structured data can be viewed and queried more like normalized data. 
• Use the CAST function. 
• Create a View. 

WebUI Essentials Module Exam

Each lesson in the module includes Knowledge Check questions to ensure the learner has a chance to synthesize concepts from the video and lab. At the end of the module, learners are asked to do a final knowledge check that covers the same concepts. This delayed but comprehensive exam helps the user retain information from the various modules and increases the likelihood they will feel capable of putting all the concepts into practice.

The Sharing, Marketplace, & Exchanges Workshop (SMEW)

Start Sharing Workshop

SMEW Essentials Lesson 1 – Inbound Shares

After this lesson, you’ll be able to carry out tasks like: 

• Name the two inbound shares included with each Snowflake Trial account 
• Describe the purpose of the inbound shares and how they can be identified as shares. 
• Identify the source of shared data and what the share is called by the Provider

SMEW Essentials Lesson 2 – Using Shared Data

After this lesson, you’ll be able to carry out tasks like: 

• Rename the database associated with an inbound share
• Query shared data and use in a view
• Award and/or revoke access to share to user roles 

SMEW Essentials Lesson 3 – Outbound Shares

After this lesson, you’ll be able to carry out tasks like: 

• Convert a regular view to a secure view
• Set up an outbound data share 

SMEW Essentials Lesson 4 – Reader Accounts

After this lesson, you’ll be able to carry out tasks like: 

• Set up a Reader Account for a business partner new to Snowflake
• Set up your Outbound Share as an Inbound Share in the reader account
• Perform basic administrative functions to get the Reader account ready to use

SMEW Essentials Lesson 5 – Readers vs Full Accounts

After this lesson, you’ll be able to carry out tasks like: 

• Describe the benefits of having a full account instead of a reader account
• Encourage business partners to establish full accounts

SMEW Essentials Lesson 6 – Shop the Marketplace

After this lesson, you’ll be able to carry out tasks like: 

• Navigate to the Snowflake Data Marketplace
• Browse the Snowflake Data Marketplace
• Request data from a standard listing

SMEW Essentials Lesson 7 – List on the Marketplace

After this lesson, you’ll be able to carry out tasks like: 

• Describe the requirements for data on the Marketplace
• Differentiate between Standard and Personalized listings
• Create an outbound share that uses an Entitlements table based on the CURRENT_ACCOUNT function

SMEW Essentials Lesson 8 – Data Exchanges

After this lesson, you’ll be able to carry out tasks like: 

• Use a private data exchange to request and receive a pair of listings 
• Understand how bi-directional data sharing allows for data enhancement and return between two Snowflake accounts

SMEW Essentials Final Lab Project

In the final lab exercise, you’ll:

• Create a Provider Profile for a fictional company or organization
• Set up a Standard Listing
• Set up a Personalized Listing
• Request Data from a Personalized Listing (Created by a peer learner)
• Deny a Request for your Personalized Listing (Sent to you by a peer learner)