HANDS-ON ESSENTIALS – BADGE 1: DATA WAREHOUSING

In the Warehousing Workshop you’ll get hands-on experience with:

• Viewing and using your assigned roles
• Navigating databases, schemas and objects
• Previewing, querying and downloading data using worksheets
• Creating, editing and using warehouses
• Creating databases, tables, and file formats.
• Loading csv files into a Snowflake database table using the load wizard
• Running simple SQL statements and a few SQL functions
• Setting up a Snowflake Stage to facilitate loading data files from a cloud directory
• Create a Snowflake Sequence for use as a unique record identifier
• Create an XML file format, load XML data and query it.
• Create a JSON file format, load JSON data and query it.
• Use PATH statements to query JSON data.
• Use the FLATTEN function to query JSON data.
• Use the CAST function.
• Create and use a Snowflake View.

The Sharing, Marketplace, & Exchanges Workshop (SMEW)

Start Sharing Workshop

In the Sharing Workshop you’ll get hands-on experience with:

• Using data from the shares included with every Snowflake trial account
• Rename a shared database
• Identify the source of shared data
• Award or revoke access to a share
• Convert a “regular” view to a Secure View
• Set up an outbound share
• Set up and administer a Reader Account
• Navigate to the Snowflake Data Marketplace
• Browse the Snowflake Data Marketplace
• Request data from a standard listing
• 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
• 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
• 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)

The DATA APPLICATION BUILDERS Workshop (DABW)

Start APPS Workshop

In the Sharing Workshop you’ll get hands-on experience with:

• Setting up your Python development environment using Anaconda and PyCharm (Optional)
• Using Python to create a small website (no prior Python experience needed)
• Connecting to your Snowflake account via Python to both send and receive data
• Using a Javascript visual library to display Snowflake data on a webpage
• Setting up a Java development environment using BlueJ (Optional)
• Creating connector classes in Java to send and receive data from Snowflake
• Using a series of third-party tools to move data from your smartphone through the Google Cloud and into Snowflake
• Setting up a Snowflake task and scheduling it to run
• Setting up a Snowflake Snow Pipe that loads only when a new file is received
• Setting up a Google Cloud bucket
• Using a variety of authorization and access protocols to provide access between various applications and services