Sample Data on the Snowflake Marketplace

Finding the right dataset for a demo can be a challenge. There are several locations where you can find datasets. Recently I found out about Knoema. On Knoema there is a wealth of datasets either to achieve for free or via a subscription. Snowflake offers an easy alternative for you with Knoema datasets on the Snowflake Marketplace.

Secure Data Sharing

One of my most favourite features of the Snowflake platform is Secure Data Sharing. Snowflake’s architecture supports Data sharing while keeping only one live copy of the data; no copying, no moving, no delays.

  • Direct Share –> one on one data sharing between organisations
  • Data Exchange –> data sharing from your own Snowflake account; multiple organisations, multiple data sets
  • Data Marketplace –> Snowflake ‘App-store’ for data

More on Snowflake Secure Data Sharing on the Snowflake website.

Snowflake Marketplace

Knoema offers it’s datasets on the Snowflake Marketplace. It’s relatively easy to get data form the Data Marketplace. In a few steps you can add a dataset from the Data Marketplace into a Snowflake account.

First select the Data Marketplace button from the Snowflake Menubar.

Snowflake Data Market Place Menu
Explore the Snowflake Data Marketplace

This allows you to explore the Snowflake Data Marketplace. When you sign into the Data Marketplace for the first time in your session, you might have to login another time.

Knoema Snowflake Data Marketplace

From the homepage of the Snowflake Data Marketplace you can search and select various different data providers. You can search on the name of the provider or the category of the dataset, like e.g.; Economy, Weather or Sports. Knoema is one of the many data providers. They offer various data sets in various categories.

> Sports and Recreation Data Atlas”

Get Data Knoema Snowflake Data Marketplace

To be able to select a dataset from the Snowflake Marketplace you need the ACCOUNTADMIN-role. For this example I will select the; ‘Sports and Recreation Data Atlas’-dataset. From the landing page of this dataset you see the contents and a description of this dataset. This dataset consists of 10 different datasets in total. Additional information on this page are possible query’s you can execute on this dataset.

Create Database Knoema Snowflake Data Marketplace

Via a Data Share you create a database ion your account. You can name the database and assign roles you want to be able to select from this database. In this example the name remains the default and read privileges are assigned to PUBLIC. You will have two accept both Snowflake’s as well as Knoema’s terms of use.

Query Database Knoema Snowflake Data Marketplace

That’s it. Now you have a dataset from Knoema available form within your Snowflake account. No need data pipeline necessary. No additional storage cost either. Only compute when you query the data.

When finishing up this blogpost I saw I missed the following post by Snowflake’s Felipe Hoffa

Thanks for reading.


Daan Bakboord

Bekijk ook:

Snowflake Data Cloud Summit - Wrap Up

Snowflake Snowflake Data Cloud Summit — Wrap Up

Snowflake Data Cloud Summit proved that after all this years the core idea remains the same and is still strong. Technology should serve and Snowflake makes things simple. One Single Unified Platform, one product and one engine. Ease of use and Govenance. Maximum efficiency and maximum simplicity.

Bring the processing of data to the data instead of the other way around. Snowflake as a Platform where you build and share your Data, Apps and AI Products. Your data never has to leave the Platform and Snowflake takes care of this Platform.

Lees verder »
Snowflake Data Cloud Summit - Day II

Snowflake Data Cloud Summit – Day II

The second day of Snowflake Summit in the Moscone Center in San Francisco started with Platform Keynote packed with announcements and demo’s. The announcements were not necessarily completely new, but a continuation of things Snowflake was already working on. Lot’s of Developments and Previews have made it to GA status and are now Generally Available to the public. A few announcements were made as wel.

This blogpost a summarization of my notes with were possible a link to Snowflake publications or documentation.

Lees verder »
Snowflake Data Cloud Summit - Day I

Snowflake Data Cloud Summit – Day I

The first day of Snowflake Summit in the Moscone Center in San Francisco was a day with the first two announcements made during the Opening Keynote. These two announcements built upon the theme for this years Summit; “The Era of Enterprise AI”

Lees verder »