Data marketplace and listings in Snowflake - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to list all available data marketplaces in Snowflake.

Snowflake

SHOW [1];

Drag options to blanks, or click blank then click option'

AMARKETPLACES

BDATABASES

CWAREHOUSES

DUSERS

Attempts:

3 left

💡 Hint

Common Mistakes

Using SHOW DATABASES instead of SHOW MARKETPLACES

Using SHOW USERS which lists users, not marketplaces

The SHOW MARKETPLACES command lists all data marketplaces available in Snowflake.

2fill in blank

medium

Complete the code to create a new data listing in a marketplace.

Snowflake

CREATE [1] my_listing IN MARKETPLACE my_marketplace;

Drag options to blanks, or click blank then click option'

AUSER

BWAREHOUSE

CDATABASE

DLISTING

Attempts:

3 left

💡 Hint

Common Mistakes

Using CREATE WAREHOUSE LISTING which is invalid

Using CREATE USER LISTING which does not exist

The CREATE LISTING command creates a new data listing in a specified marketplace.

3fill in blank

hard

Fix the error in the code to show all listings in a specific marketplace.

Snowflake

SHOW LISTINGS IN [1];

Drag options to blanks, or click blank then click option'

AWAREHOUSE my_marketplace

BDATABASE my_marketplace

CMARKETPLACE my_marketplace

DUSER my_marketplace

Attempts:

3 left

💡 Hint

Common Mistakes

Using DATABASE instead of MARKETPLACE

Using WAREHOUSE which is unrelated

The correct syntax to show listings in a marketplace is SHOW LISTINGS IN MARKETPLACE <name>.

4fill in blank

hard

Fill both blanks to grant access to a data listing for a user.

Snowflake

GRANT [1] ON LISTING my_listing TO [2];

Drag options to blanks, or click blank then click option'

AUSAGE

BREAD

CUSER my_user

DROLE

Attempts:

3 left

💡 Hint

Common Mistakes

Using READ permission which is invalid in this context

Granting to ROLE instead of USER

Granting USAGE on a listing allows access, and the grantee is a USER my_user.

5fill in blank

hard

Fill all three blanks to revoke access from a role on a data listing.

Snowflake

REVOKE [1] ON LISTING [2] FROM [3];

Drag options to blanks, or click blank then click option'

AUSAGE

Bmy_listing

CROLE my_role

DREAD

Attempts:

3 left

💡 Hint

Common Mistakes

Using READ permission which is invalid

Omitting ROLE keyword before the role name

To revoke access, use USAGE permission on the listing name from the specified role.