SHOW ALL IN SHARE

  • 项目

重要

Delta Sharing 目前为公共预览版。 要使用预览版，必须在 Azure Databricks 帐户控制台中启用外部数据共享功能组。 请参阅为帐户启用外部数据共享功能组。

Delta Sharing 受适用条款约束。 启用外部数据共享功能组即表示接受这些条款。

列出共享的内容。

起始版本：Databricks Runtime 10.3

语法

SHOW ALL IN SHARE share_name

参数

  • share_name

    现有共享的名称。 如果该名称不存在，则会引发异常。

示例

-- Create share `customer_share` only if share with same name doesn't exist, with a comment.
> CREATE SHARE IF NOT EXISTS customer_share COMMENT 'This is customer share';

-- Add 2 tables to the share.
-- Expose my_schema.tab1 a different name.
-- Expose only two partitions of other_schema.tab2
> ALTER SHARE customer_share ADD TABLE my_schema.tab1 AS their_schema.tab1;
> ALTER SHARE customer_share ADD TABLE other_schema.tab2 PARTITION (c1 = 5), (c1 = 7);

-- List the content of the share
> SHOW ALL IN SHARE customer_share;
  name              type  shared_object          added_at                     added_by                   comment partitions
  ----------------- ----- ---------------------- ---------------------------- -------------------------- ------- ------------------
  other_schema.tab2 TABLE main.other_schema.tab2 2022-01-01T00:00:01.000+0000 alwaysworks@databricks.com NULL
  their_schema.tab1 TABLE main.myschema.tab2     2022-01-01T00:00:00.000+0000 alwaysworks@databricks.com NULL    (c1 = 5), (c1 = 7)