DESCRIBE RECIPIENT

  • 아티클

적용 대상:검사 '예'로 표시 Databricks SQL 검사 '예'로 표시 Databricks Runtime 10.4 LTS 이상 검사 '예'로 표시 Unity 카탈로그만 해당

기존 수신자의 메타데이터를 반환합니다. 메타데이터 정보에는 수신자 이름 및 활성화 링크가 포함됩니다.

구문

[ DESC | DESCRIBE ] RECIPIENT recipient_name

매개 변수

  • recipient_name

    기존 수신자의 이름입니다. 이름이 없으면 예외가 throw됩니다.

예제

-- A recipient created for Databricks to Databricks sharing
> CREATE RECIPIENT other_databricks_org USING ID 'azure:westus:f64dcb39-5046-4d4c-9588-c6ac84f9b38a';
> DESCRIBE RECIPIENT other_databricks_org;
 info_name           info_value
 -------------       ----------
 recipient_name      other_databricks_org
 authentication_type DATABRICKS
 owner               alwaysworks@databricks.com
 created_by          alwaysworks@databricks.com
 create_at           2022-01-01T00:00:00.000+0000
 updated_by          alwayswork@databricks.com
 updated_at          2022-01-05T12:00:00.000+0000
 comment
 cloud                 azure
 region                westus
 metastore_id          f64dcb39-5046-4d4c-9588-c6ac84f9b38a

-- A recipient created for sharing outside of Databricks
> CREATE RECIPIENT other_org;
> DESCRIBE RECIPIENT other_org;
 info_name               info_value
 ----------------------- ----------
 recipient_name          other_org
 recipient_id            0123451f-5262-40bb-9b03-3ee12e612345
 authentication_type     TOKEN
 owner                   alwaysworks@databricks.com
 created_by              alwaysworks@databricks.com
 create_at               2022-01-01T00:00:00.000+0000
 updated_by              alwayswork@databricks.com
 updated_at              2022-01-05T12:00:00.000+0000
 comment
 active_token_id         0160c81f-5262-40bb-9b03-3ee12e6d98d7
 active_token_expiration 2023-01-05T12:00:00.000+0000
 activation_link         https://send/this