Create an organizational listing

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

Create an organizational listings 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:
Copy

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

USE ROLE <organizational_listing_role>;

CREATE ORGANIZATION LISTING <organizational_listing_name>
SHARE <share_name> 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