Data marketplace and listings in Snowflake - Mini Project: Build & Apply

Data Marketplace and Listings in Snowflake

📖 Scenario: You are working as a cloud data engineer. Your company wants to create a simple data marketplace listing using Snowflake. This marketplace will show available datasets with their names and descriptions.Think of it like a small online store, but instead of products, you list datasets that others can use.

🎯 Goal: Build a Snowflake table to hold marketplace listings with dataset names and descriptions. Then, create a view to show only active listings.

📋 What You'll Learn

Create a table named marketplace_listings with columns dataset_name (string), description (string), and is_active (boolean).

Insert exactly three listings with given dataset names, descriptions, and active status.

Create a variable active_status set to true to filter active listings.

Create a view named active_marketplace_listings that selects only listings where is_active matches active_status.

💡 Why This Matters

🌍 Real World

Data marketplaces help organizations share and discover datasets easily in cloud platforms like Snowflake.

💼 Career

Cloud data engineers and architects often build and manage data catalogs and marketplaces to enable data sharing and governance.

1

Create the marketplace listings table

Create a table called marketplace_listings with columns dataset_name as VARCHAR, description as VARCHAR, and is_active as BOOLEAN.

Snowflake

-- Your code here to create the table

Need a hint?

Use CREATE OR REPLACE TABLE with the exact column names and types.

2

Insert dataset listings

Insert three rows into marketplace_listings with these exact values:
1. 'CustomerData', 'Contains customer info', true
2. 'SalesData', 'Monthly sales records', false
3. 'ProductCatalog', 'Product details and prices', true

Snowflake

CREATE OR REPLACE TABLE marketplace_listings (
    dataset_name VARCHAR,
    description VARCHAR,
    is_active BOOLEAN
);
-- Your code here to insert the three listings

Need a hint?

Use a single INSERT INTO statement with three value tuples.

3

Create a variable for active status

Create a variable called active_status and set it to true to represent active listings.

Snowflake

CREATE OR REPLACE TABLE marketplace_listings (
    dataset_name VARCHAR,
    description VARCHAR,
    is_active BOOLEAN
);

INSERT INTO marketplace_listings (dataset_name, description, is_active) VALUES
('CustomerData', 'Contains customer info', true),
('SalesData', 'Monthly sales records', false),
('ProductCatalog', 'Product details and prices', true);

-- Your code here to create the variable active_status

Need a hint?

Use SET active_status = true; to create the variable.

4

Create a view for active listings

Create a view named active_marketplace_listings that selects dataset_name and description from marketplace_listings where is_active equals the variable active_status.

Snowflake

CREATE OR REPLACE TABLE marketplace_listings (
    dataset_name VARCHAR,
    description VARCHAR,
    is_active BOOLEAN
);

INSERT INTO marketplace_listings (dataset_name, description, is_active) VALUES
('CustomerData', 'Contains customer info', true),
('SalesData', 'Monthly sales records', false),
('ProductCatalog', 'Product details and prices', true);

SET active_status = true;

-- Your code here to create the view active_marketplace_listings

Need a hint?

Use CREATE OR REPLACE VIEW and filter with WHERE is_active = $active_status.