Create an organizational listing¶

1. Create an organizational listing.

   1. Sign in to Snowsight.

   2. Select Data Products » Provider Studio in the left-side navigation menu.

   3. Select + Create Listing » Internal Marketplace.

   4. Select + Data Product.

   5. In the + Data Product dialog, click + Select.

   6. Navigate to a data product such as a table, view or other data product.

      Alternatively, search for and choose a data product to share.

   7. Select Done when complete.

   8. Select Save.

2. Specify who can access the listing (the target accounts, roles, and regions).

   1. Select + Access Control. The Access and discovery dialog displays.

   2. Complete the Grant access section:

      Field	Description
      Who can access this data product?	Select one of the following: Entire organization: Anyone in the organization can access the listing. If Entire organization is selected and cross-cloud auto-fulfillment is enabled on your account, then you’ll be prompted to review the auto-fulfillment refresh settings for the listing. Selected accounts and roles: Only selected accounts and roles can access. No accounts or roles are pre-approved: (Default) Data product will only be available by request.
      Accounts	If Selected accounts and roles is selected, select one or more accounts. Optional. Select + Add another account to add second and subsequent accounts. By default, all roles in the selected accounts can access the listing. Select Selected roles to grant access only to specific roles each selected account.

   3. Complete the Allow discovery section:

      Field	Description
      Who else can discover the listing and request access?	Select one of: Entire organization: (Default) Anyone in the organization can discover listing and request access. This field is selected and disabled if Entire organization is specified for in the Grant access section. Selected accounts and roles: Only selected accounts and roles can discover listing and request access. Not discoverable by users without access: Only users with access can discover this listing.
      Accounts	If Select accounts and roles is selected, select one or more accounts. Optional. Select + Add another account to add second and subsequent accounts and grant access to specific roles.
      Selected user roles	If Selected roles is selected, enter one or more roles to grant access.

   4. If Allow discovery is Selected accounts and roles, then select Set up request approval flow.

      • In the Set up request approval flow dialog, select one of the following options in the How should the request approval happen? list:

        • Manage requests in Snowflake: Enter the email address of the request approver and optionally specify additional roles that can approve requests.

        • Manage requests outside of Snowflake: Enter an email address for the request approver or enter a URL that points to an internal ticketing system.

        Note

        The Set up request approval flow button isn’t available if the data product is accessible by the entire organization or if the data product is not discoverable by users without access.

3. Provide a title, and review the generated Uniform Listing Locator (ULL).

   Changing a listings title is optional but recommended. For more information, see Uniform Listing Locator.

   1. Select Untitled Listing.

   2. For Listing title, enter a descriptive title for your data product.

   3. Select Save or Cancel.

4. Complete the listing.

   Enter addition information about listing page to guide consumers, such as description, data dictionary, usage examples, attributes and more.

   Note that Support Contact is required.

5. Select Publish to make the listing available in the Internal Marketplace.

   If you exit without publishing, the listing is saved as a draft that’s ready for review or for the addition of descriptive metadata.

Create an organizational listing from the share with the required attributes included in YAML (entered in $$ delimiters).

This part of the manifest yaml specifies the accounts that will be able to use the organizational listing:

organization_targets:
  access:

This example creates a listing using the required settings in the manifest YAML. It targets one role in one account in one region and includes support and approver contacts:

USE ROLE <organizational_listing_role>;

CREATE ORGANIZATION LISTING <organization_listing_name>
SHARE <share_name> AS
$$
title: "My title"
description: "One region, all accounts"
organization_profile: "INTERNAL"
organization_targets:
  discovery:
  - account: "<account_name>"
    roles:
    - "<role>"

  access:
  - account: "<account_name>"
    roles:
    - "<role>"

support_contact: "support@somedomain.com"
approver_contact: "approver@somedomain.com"
locations:
  access_regions:
  - name: "PUBLIC.<snowflake_region>"
$$;

For a complete list of all fields and values for an organizational listing see Organization listing manifest reference. For additional examples, see Set who can discover and access an organizational listing.