Categories:: System functions (System Information)

SYSTEM$GET_CMK_AKV_CONSENT_URL¶

返回与客户管理的密钥相关的 Azure Key Vault 账户的同意 URL。

See also:: Customer-managed keys

语法

SYSTEM$GET_CMK_AKV_CONSENT_URL( '<account_identifier>' , '<tenant_id>' )

实参

'account_identifier'

Specifies the account identifier for your Snowflake account on Azure.

必填。

'tenant_id'

Specifies the unique identifier for the tenant (https://docs.microsoft.com/en-us/azure/key-vault/general/basic-concepts) in your Azure subscription. This value is in the GUID/UUID format, such as b3ddabe4-e5ed-4e71-8827-0cefb99af240.

必填。

To locate this value, follow the instructions in How to find your Azure Active Directory tenant ID (https://docs.microsoft.com/en-us/azure/active-directory/fundamentals/active-directory-how-to-find-tenant).

使用说明

此功能仅适用于 Microsoft Azure 上的 Snowflake 账户。
Only account administrators (i.e. users with the ACCOUNTADMIN role) or a role that is granted the global MONITOR SECURITY privilege can call this function.

示例

Return the consent URL to the Azure Key Vault account related to customer-managed keys, where my-account is the Snowflake account identifier in the account name format for your Snowflake account on Azure and b3ddabe4-e5ed-4e71-8827-0cefb99af240 is the tenant identifier for your Azure subscription:

SELECT SYSTEM$GET_CMK_AKV_CONSENT_URL('my-account' , 'b3ddabe4-e5ed-4e71-8827-0cefb99af240');
返回：
https://login.microsoftonline.com/tenantId/oauth2/authorize?client_id=myClientId&response_type=code