How to get Snowflake Hands On Essentials Data Sharing Badges Certification

Rajiv Gupta
4 min readMar 26, 2021

--

Do you want to get Data Sharing badge? Want to showcase your hand-on-expertise to your employer, manager, or you are aspiring for a new role in Snowflake world, or you want to learn something really cool and test your learning ? This is the second step toward Snowflake.

Today I would like to share with you my experience and learning toward Snowflake Hands On Essentials — Data Sharing badges.

This is also famous with the name of Workshop 2. This one is totally focused on Secure Data Sharing based workshop and do labs around all feature of sharing functionality in Snowflake and followed by a digital badges in Acclaim Portal. Now the next question came to mind how to start with that and yes this blog is for that only.

Prerequisites

There are 2 prerequisites to this workshop

1> You should have earned the Hand-on Data Warehouse/Web UI Essential badges which you can earn as part of Workshop 1.

2> Snowflake trial account should be in Azure Enterprise Edition Account should be created in Canada Central region.

Why is it so important to have an account in AZURE_CANADACENTRAL?

Exchanges are specific to a particular region. In order for Snowflake to offer this workshop where everyone can create and edit listings, we had to choose a region. We chose Azure as the platform and Canada Central (Toronto) as the regional location.

Why Hand-on Data Warehouse/Web UI Essential badges is made as prerequisite for this workshop?

Workshop 1 is the base for any activity in Snowflake. You should be aware of SQL, Snowflake Web UI to do any activity in Snowflake. Hence, to make this workshop smooth for everybody Snowflake recommend taking Workshop 1 as prerequisite.

Brief about workshop 2:

This workshop has a detail course attached to it. Meaning you get full support for ground up in Snowflake Data Sharing. First your concepts will be cleared for each topic which is followed by hands-on lab. The Course is very beautifully designed keeping in mind that a person may or may not have prior experience. Since this is a unique concept in Snowflake, so I would suggest paying attention toward the lesson. Also, you will get quite few question around this topic in SnowPro Core Certification, so it is a good idea to clear your concept during theory & practical lab session. If you think whether you will be able to complete this course and project than don’t worry this course is designed in such a way that everybody will be successful. Course outlay looks something like this:

Data Sharing Course Flow(Source: Snowflake)

Once you are done with all learning and labs you have to submit your labs output in a PDF format to Snowflake University team for review.

How to present & sample project etc. all are mentioned in checklist module.

Course & Project submission module(Source: Snowflake)

My Workshop 2 Final Project Submission to Snowflake Academy:

Brief About Data Sharing in Snowflake(Source: Snowflake):

Secure Data Sharing enables sharing selected objects in a database in your account with other Snowflake accounts. The following Snowflake database objects can be shared:

  • Tables
  • External tables
  • Secure views
  • Secure materialized views
  • Secure UDFs

Snowflake enables the sharing of databases through shares, which are created by data providers and “imported” by data consumers. All database objects shared between accounts are read-only (i.e. the objects cannot be modified or deleted, including adding or modifying table data).

Snowflake provides three product offerings for data sharing that utilize Snowflake Secure Data Sharing to connect providers of data with consumers.

In this Topic:

Note: Please click on particular links to read more on respective topics.

As compared to other workshop 1 this workshop is quite different in flavor as this is a new concept all together. This is very interesting concept where you can fish lots of data sharing opportunity with proper marketing strategies for your data in data marketplace.

You can do it in phases, but my recommendation is to do it in a single stretch or two so that you don’t have to recall what you did last time.

What you will gain as a skill along with impressive Snowflake digital badges?

Source: Snowflake

I had earned mine, it’s your time to get one.

Hope this blog help you to get insight on how to gain one for you. Feel free to ask a question in the comment section if you have any doubts regarding this workshop. Give a clap if you like the blog. Stay connected to see many more such cool stuff. Thanks for your support.

Did you check my blog on below:

How to get Snowflake Hands On Essentials — Data Applications: DABW Badge Certification

How to get Snowflake Hands On Essentials — Data Warehouse Badges Certification

You Can Find me:

Follow me on Medium: https://rajivgupta780184.medium.com/

Follow me on Twitter: https://twitter.com/RAJIVGUPTA780

Connect with me in LinkedIn: https://www.linkedin.com/in/rajiv-gupta-618b0228/

Subscribe to my YouTube Channel: https://www.youtube.com/channel/UC8Fwkdf2d6-hnNvcrzovktg

#Keep learning #Keep Sharing #Everyday Learning.

References:-

--

--

Rajiv Gupta
Rajiv Gupta

Written by Rajiv Gupta

Director Of Technology at Kipi.ai , Snowflake Data Super Hero, Snowflake SME

Responses (5)