Badge 2: Collaboration, Marketplace & Cost Estimation Workshop
A course covering Snowflake's revolutionary collaboration technologies. Learn to create listings, get listings sent by other accounts, and shop for data sets on the Snowflake Marketplace. Understand how your organization can get rid of nightly extracts and cumbersome ETL processes. This course also helps those new to SQL brush up on some important SQL skills including basics like DISTINCT, GROUP BY, ORDER BY, JOINS, and control-of-flow like BEGIN, END, DECLARE and FOR. Finally, the course covers cost categories, cost estimation, and some beginner-level cost control mechanisms.
Course Number
CMCWSelf-Paced
About This Hands-On Workshop
This workshop is the second workshop in the Hands-On Badge Series. In this course, you deep dive into Snowflake's revolutionary collaboration technologies including the Marketplace and direct share listings.
Start by exploring the inbound shares that come with every trial account. Understand how shared and local data can be used together. Create a listing to share with another Snowflake account, and accept a listing shared with your Trial. Shop for listings on the Snowflake Marketplace, add a free data set from WeatherSource and combine that data with local data to generate new insights. Understand how your organization's business partners can be given access to your data shares. Learn how to control costs with Resource Monitors.
Prior Knowledge & Experience
We strongly recommmend completing the Data Warehousing Workshop (Badge 1) before attempting this workshop. Many foundational concepts are covered in Badge 1. The course instruction presumes you have completed Badge 1 and does not explain all concepts from the introductory level.
Hands-On Essentials Series
This course is third in the Hands On Essentials Series. This series allows you to earn a Badge for display on LinkedIn and other social media. The Essentials Series uses active learning principles to give you a fast-paced, hands-on experience. Short videos, step-by-step labs, reflection questions, and challenge labs work together to build your knowledge and skills as you build a solution.
Scenario Based
We meet Martín Rojas who works for World Data Emporium alongside Alinta Wenitong. Martin and Alinta are hoping to move their business partners to Snowflake Accounts so they can stop midnight fire drills when their file extracts don't get delivered as planned. We also meet Lottie Sellers, the Chief Data Strategist for ACME Car Dealership in Detriot, MI, USA. Lottie is considering a move to Snowflake when she hears that she can stop receiving extracts and get always-up-to-date data shares instead. Max Manuf doesn't want to share his companies data or logic, but he would like to make his functionality available to partners. Max creates a listing that contains a UDTF. Lottie and her staff at ACME use Max's functionality to enhance their data instantly!
Grading
To complete the workshop you will watch short videos, answer questions, and complete labs. This course is not suitable for learners who want to be given exact step-by-step instructions for every task. Badge earners are equipped to to advise managers on how any organization can join the data cloud, save money by removing file transfers and uploads, and monitor costs via Resource Monitors, budgets and controlled use of compute power.
Lab Environment
Don't sign up for a trial account until you are given specific requirements within the course flow.