Data marketplace and listings in Snowflake - Commands & Configuration

Introduction

A data marketplace lets you find and use data shared by others easily. Listings show available data sets you can explore and use in your Snowflake account.

When you want to find external data sets to enrich your business reports without building your own data pipelines.

When you need to share your data securely with partners or customers using Snowflake's platform.

When you want to browse and subscribe to data products offered by other organizations.

When you want to manage and control access to shared data listings within your Snowflake account.

When you want to quickly integrate third-party data into your analytics without manual data transfers.

Commands

This command lists all available data marketplace listings you can browse and subscribe to in your Snowflake account.

Terminal

SHOW DATA MARKETPLACE LISTINGS;

Expected Output

name                 | provider_name | description                      | created_on          

---------------------|---------------|--------------------------------|---------------------

weather_data_listing | WeatherCorp   | Global weather data sets        | 2024-05-01 10:00:00

stock_prices_listing | FinanceInc    | Historical stock prices         | 2024-04-15 09:30:00

This command switches your session to use the selected data marketplace listing so you can query its data.

Terminal

USE DATA MARKETPLACE LISTING weather_data_listing;

Expected Output

Using data marketplace listing 'weather_data_listing'.

This command queries the first 5 rows from the global weather data set in the selected marketplace listing.

Terminal

SELECT * FROM weather_data_listing.global_weather LIMIT 5;

Expected Output

date       | location    | temperature | precipitation

-----------|-------------|-------------|--------------

2024-06-01 | New York    | 25          | 0.0

2024-06-01 | London      | 18          | 1.2

2024-06-01 | Tokyo       | 22          | 0.5

2024-06-01 | Sydney      | 15          | 0.0

2024-06-01 | Mumbai      | 30          | 0.0

This command gives the data_analyst role permission to use the weather_data_listing data marketplace listing.

Terminal

GRANT USAGE ON DATA MARKETPLACE LISTING weather_data_listing TO ROLE data_analyst;

Expected Output

Grant succeeded.

Key Concept

If you remember nothing else, remember: data marketplace listings let you find and use shared data sets easily inside Snowflake.

Common Mistakes

Trying to query data from a marketplace listing without switching to it first.

Snowflake requires you to set the active data marketplace listing before querying its data.

Run USE DATA MARKETPLACE LISTING listing_name; before querying data from that listing.

Not granting proper roles access to the data marketplace listing.

Without permissions, users cannot query or use the shared data.

Use GRANT USAGE ON DATA MARKETPLACE LISTING listing_name TO ROLE role_name; to give access.

Summary

Use SHOW DATA MARKETPLACE LISTINGS; to see available shared data sets.

Switch to a listing with USE DATA MARKETPLACE LISTING listing_name; before querying its data.

Grant roles access with GRANT USAGE ON DATA MARKETPLACE LISTING to control who can use the data.