Manage organizational listings¶

You can alter a listing to add, change, or remove the settings of the organizational listing, such as the title, ULL, target accounts or roles, auto-fulfillment, and more.

View available organizational listings¶

Sign in to Snowsight.
Select Data Products » Marketplace in the left-side navigation menu.
Select the Internal Marketplace tab.
Browse the available data products or use the search bar to find a specific listing.

Use SHOW AVAILABLE LISTINGS to find listings in your organization which are available to you.

SHOW AVAILABLE LISTINGS
  IS_ORGANIZATION = TRUE;

Copy

Use SHOW LISTINGS to find listings on which you are granted USAGE, MODIFY, or OWNERSHIP.

SHOW LISTINGS;

Copy

Edit an organizational listing¶

Note

To avoid overwriting the existing settings of an organizational listing, you must include the existing manifest (manifest_yaml) when you make changes. Use DESCRIBE LISTING to view the current settings.

You can’t change the Uniform Listing Locator(ULL) or remove the data product after the listing has been published.

Open the listing:
1. Sign in to Snowsight.
2. Select Data Products » Provider Studio. in the left-side navigation menu.
3. Select the Listings tab.
4. Select Shared with » Internal Marketplace.
5. To further refine your search, select Status and choose a status, such as Draft or Live. You can sort the result set by any column.
6. Select the listing title to open the listing page.
Edit the listing:
1. To edit the listing title, select the title. The Edit listing title dialog appears.
2. To edit other metadata on the listing page, select the Edit button near the item you want to change.
3. To edit the data product information, select the Data Product icon. You can change the description of the data product or change the table or view selections.

In the following example, the organization target and the locations of an organizational listing named my-org-listing1 are changed. The ALTER statement includes the existing listing manifest, captured with the DESCRIBE LISTING command.

USE ROLE <organizational_listing_role>;

ALTER LISTING my-org-listing1
AS
$$
title: "My title"
description: "One region, all accounts"
organization_profile: "INTERNAL"
organization_targets:
  access:
  - account: "<account_name>"
    roles:
    - "<role>"
locations:
  access_regions:
  - name: "PUBLIC.<snowflake_region>"
$$;

Copy

This example manifest targets all accounts in one Snowflake region.

title: "My title"
description: "One region, all accounts"
organization_profile: "INTERNAL"
organization_targets:
  access:
  - account: "<account_name>"
    roles:
    - "<role>"
locations:
  access_regions:
  - name: "PUBLIC.<snowflake_region>"

Copy

This example manifest targets two accounts, with two roles each, in one Snowflake region.

title: "My title"
description: "One region, two accounts, four roles"
organization_profile: "INTERNAL"
organization_targets:
  access:
  - account: "<account_name>"
    roles:
    - "<role>"
    - "<role>"
  - account: "<account_name>"
    roles:
    - "<role>"
    - "<role>"
locations:
  access_regions:
  - name: "PUBLIC.<snowflake_region>"

Copy

This example manifest targets all accounts in three Snowflake regions.

title : 'My title'
description: "Three region, all accounts"
organization_profile: INTERNAL
organization_targets:
  access:
  - all_accounts : true
locations:
  access_regions:
  - names:
  "PUBLIC.<snowflake_region>"
  "PUBLIC.<snowflake_region>"
  "PUBLIC.<snowflake_region>"
auto_fulfillment:
  refresh_type: "SUB_DATABASE"
  refresh_schedule: "10 MINUTE"

Copy

This example manifest targets all accounts in all regions.

title : 'My title'
description: "Three region, all accounts"
organization_profile: INTERNAL
organization_targets:
  access:
  - all_accounts : true
locations:
  access_regions:
  - names: "ALL"
auto_fulfillment:
  refresh_type: "SUB_DATABASE"
  refresh_schedule: "10 MINUTE"

Copy

Remove a listing from Internal Marketplace¶

To remove a listing from the Internal Marketplace, you must change its status.

Sign in to Snowsight.
Select Data Products » Provider Studio.
Select the Listings tab.
Select Shared with » Internal Marketplace.
Locate the listing you want to remove.
Select the listing tile to open the listing page.
To unpublish the listing, select ⋮ » Unpublish.

ALTER LISTING <organizational_listing_name> UNPUBLISH;

Copy

Delete a listing¶

You must unpublish a listing before it can be deleted.

Sign in to Snowsight.
Select Data Products » Provider Studio
Select the Listings tab.
Select Shared with » Internal Marketplace.
Locate the unpublished listing you want to remove.
Select the listing tile to open the listing page.
To delete a listing, select the ⋮ icon. From the list that appears, select Delete.

To delete a listing, run the following command:

DROP LISTING <organizational_listing_name>;

Copy