Getting started with organizational listings¶

Organizational listings in Snowflake allow you to share data products securely within your organization, making it easier for internal teams to discover and use trusted resources. As a provider, you can create listings that centralize access to datasets, Native Apps, and other resources, simplifying data sharing and collaboration across your teams. This guide will help you understand the steps and requirements to create and manage organizational listings effectively, ensuring that your data products are accessible while maintaining control over who can see and use them.

Before you begin, make sure you have the necessary privileges to create and manage organizational listings on behalf of the organization.

Create an organizational listing¶

Use the following steps to create a new organizational listing:

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

Before you begin, select an existing share you can add to this listing. If you don’t have one, create a share first using the following example. Otherwise skip ahead to the next code block.

CREATE SHARE <share_name> SECURE_OBJECTS_ONLY=FALSE

Copy

The following example provides a script to create an organizational listings from a share.

CREATE ORGANIZATION LISTING <organizational_listing_name>
SHARE <share_name> AS
$$
title : 'My title'
organization_profile: INTERNAL
organization_targets:
  access:
    - all_accounts : true
locations:
  access_regions:
    - name: "ALL"
$$;

Copy

View a list of organizational listings¶

You can view organizational listings by using Snowsight or SQL.

To view organizational listings in SQL, run the following commands:

SHOW LISTINGS;
DESCRIBE LISTING <organizational_listing_name>;

Copy