From the course: Introduction to Modern Data Engineering with Snowflake
Data sharing on snowflake marketplace - Snowflake Tutorial
From the course: Introduction to Modern Data Engineering with Snowflake
Data sharing on snowflake marketplace
When it comes to data sharing, the data product you're delivering is a dataset or datasets. Of course, you can always share the relevant objects like databases and tables in your Snowflake account with fellow teammates in that account. But beyond your Snowflake account, you're also able to deliver and share datasets with users and Snowflake's Data Cloud by listing them to Snowflake's Marketplace. You can share these datasets by creating a public listing on the Marketplace. This allows other users to discover them and load them into their accounts, just like we did at the beginning of the course. Only this time, you'd be the provider rather than the consumer. And if you don't want to publicly list the dataset on the Marketplace, then you can create a private listing and share datasets with specific consumers. If you browse a Snowflake Marketplace, you'll find all sorts of datasets listed on there, some free, some paid, and across all sorts of industries and use cases. This ought to give you a good sense of that experience for consumers of datasets. Let me quickly demo the flow of publishing a dataset to the Snowflake Marketplace. In Snowflake, navigate to Data Products. That's aptly name, isn't it? Click on Provider Studio. In this studio is where you can create a new listing for a dataset. At the top, you see sections for sharing with the broader Marketplace or just specific consumers, and at the bottom, you'll see some more resources you can use to learn more about this flow. I can create a new listing by clicking on the button at the top right. I'm asked to name the listing. I'll name it HAMBURG_WEATHER. I'll need to specify who can discover the listing. On the left, you'll see the option for creating a public listing, which will require you to first submit a provider profile, and on the right, you'll see the option for creating a private listing. In this demo, I'll walk through the flow for creating a private listing, and that's mostly because I haven't submitted a provider profile, but that's okay. The flows are similar enough for you to get the gist of what's going on. Next, I'll be asked to select what I want to list. For example, I could select one or two or several tables that I might want to share via my listing. I'll select the dynamic table that we created earlier. I can edit the identifier or name for this secure data share. I'll leave it as is for the purposes of this demo. Next, I'll describe the listing, which I can fill out in the text box. I'll add "Daily sales for the city of Hamburg, Germany." You'll also see the publishing as field, which corresponds to what consumers will see on the listings landing page. So for this listing, a consumer would see my account identifier as a provider. Since I'm creating a private listing, I'll need to specify the account identifiers of the accounts I want to share this dataset with. I'll enter a single recipient here with this account identifier. At the bottom, if you expand the More drop-down, you can enter an email here to get notifications about auto-fulfillment, consumer requests, and more. With all of the fields now properly set, I can click on Publish. And here's a success page indicating that my listing is live. The tables that I selected would now be shared with the recipient account that I specified, and the recipient would be able to use them in their account. That was really quick. This is an extremely common and powerful way of delivering a data product, in this case, a dataset, to an end user. You don't have to take it from me. You can simply browse the Marketplace and see all of the curated and high-quality datasets there, some free, some paid, that other users in Snowflake's Data Cloud are able to discover and use to build their pipelines. Coming up, we'll go from sharing of datasets to sharing of data apps.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.