Alter an organizational listing¶
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.
Note
You must always include the existing manifest (manifest_yaml
) when you make changes to an organizational listing.
Otherwise you will overwrite the current settings. Use DESCRIBE LISTING to check the current settings.
You can’t change the ULL or remove the data product after the listing has been published.
The following examples alter the same listing to change the organizational targets and the locations.
This ALTER statement includes the existing manifest from the listing, captured from the output of 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>"
$$;
To modify a listing, open the listing page to change the details.
Open the listing page
Sign in to Snowsight.
Select Data Products » Provider Studio » Listings.
Select Shared with » Internal Marketplace.
To further limit your search, select Status and choose a status, such as Draft or Live. You can sort the result set by any column.
Select the listing tile to open the listing page.
Edit the listing
To edit the listing title, select the title. The Edit listing title dialog appears.
For other metadata on the listing page, select the Edit button near the item you want to change.
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.
Example manifests for altering an organizational listing¶
This example 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>"
This example 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>"
This example 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"
This example 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"
Remove a listing from Internal Marketplace¶
To remove a listing from the Internal Marketplace, you must change its status.
ALTER LISTING <organizational_listing_name> UNPUBLISH;
Sign in to Snowsight.
Select Data Products » Provider Studio » Listings.
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.
Delete a listing¶
You must unpublish a listing before you can delete it.
To delete a listing, run the following command:
DROP LISTING <organizational_listing_name>;
Sign in to Snowsight.
Select Data Products » Provider Studio » Listings.
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.