更改组织列表¶

您可以更改列表，以添加、更改或移除组织列表的设置，如标题、ULL、目标账户或角色、自动履行等。

备注

更改组织列表时，必须始终包含现有清单 (manifest_yaml)。否则，将覆盖当前设置。使用 DESCRIBE LISTING 查看当前设置。

发布列表后，您无法更改 ULL 或移除数据产品。

以下示例更改了同一列表，以更改组织目标和位置。

ALTER 语句包含从 DESCRIBE LISTING 命令输出中获取的列表中的现有清单。

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

用于更改组织列表的示例清单¶

此示例针对一个 Snowflake 区域中的所有账户。

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

此示例针对一个 Snowflake 区域中的两个账户，每个账户有两个角色。

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

此示例针对三个 Snowflake 区域的所有账户。

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

此示例针对所有区域的所有账户。

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

从 Internal Marketplace 移除列表¶

要从 Internal Marketplace 移除列表，必须更改其状态。

ALTER LISTING <organizational_listing_name> UNPUBLISH;

Copy

删除列表¶

您必须先取消发布列表，然后才能删除列表。

要删除列表，请运行以下命令：

DROP LISTING <organizational_listing_name>;

Copy