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>"
$$;

Copy

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>"

Copy

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>"

Copy

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"

Copy

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"

Copy

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;

Copy

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>;

Copy