What is Snowflake Marketplace?
Snowflake Marketplace is part of Snowflake's Data Cloud. It lets businesses discover and access datasets from data solution providers. Providers list their datasets on the Marketplace, giving third-party users the opportunity to enrich their own data.
Datasets can be free or available to buy. Predefined filters let you narrow datasets down by data provider, category and more.
The videos below walk through accessing and querying a dataset from the WeDoTech provider. The prerequisites and step-by-step instructions follow.
Accessing and querying WeDoTech datasets on the MarketplaceOpens on YouTube in a new tab
Getting the eThekwini Points of Interest datasetOpens on YouTube in a new tab
Before you start
- You need a Snowflake account to use the Marketplace. If you don't have one, you can sign up for a Snowflake trial account.
- Your account's region can limit which datasets you see. Make sure your account is in the same region as the data you need. Some providers' datasets may not appear in search results for your account, but you can still reach them by clicking the provider's name.
Finding the WeDoTech data provider
- 1Log in to your Snowflake account.
- 2Click the Marketplace menu item.
- 3The Marketplace page opens with some default datasets. Predefined filters at the top help you find the dataset you're interested in.
- 4In the search bar, type the name of the data provider (for example, WeDoTech) and press Enter.
- 5As you type, both the provider and its data products appear.To find a specific data product, click it in the drop-down. To go to the provider's own page, click the provider's name, or press Enter.
- 6You're taken to the WeDoTech page on the Marketplace.
The WeDoTech page
The WeDoTech page on Snowflake Marketplace is split into four sections:
A · DescriptionA concise description of the data provider.
B · CategoryThe category the data provider is associated with.
C · Data productsEvery data product the provider lists, ready for third-party use.
D · ContactA way to email the WeDoTech data provider.
- 7Click a data product. This example uses the eThekwini Points of Interest data product.
- 8The data product page opens, with a description of the product and its metadata.Business needs lists use cases for businesses looking to enrich their data with this product.The data dictionary describes the fields, their data types and the data itself.Usage examples show how to answer specific business questions, with the SQL to do it. You can copy that SQL and paste it into Snowflake.
Getting the dataset
- 9Click Get to acquire the dataset. A dialog opens.Open the Options drop-down to set a database name (or keep the default) and choose which Snowflake roles can access the new database.
- 10Once you've set the options, click Get. A dialog confirms that the dataset is ready to use.
Querying the data
- 11Click Query Data. You're taken to a Snowflake worksheet listing all the queries, with their comments. The database is expanded, with its schemas shown below it.
- 12Select a query in the worksheet and click Run. A results pane shows the query's output, and the data is profiled by default, giving you instant statistics about it.
- 13You can now use the dataset in your own analysis.
That's how to access and query the WeDoTech data provider's datasets on Snowflake Marketplace. The videos above walk through the same steps.