Define Authorization Objects for Unity Catalog - Teradata Vantage

The AUTHORIZATION object storages the credentials to access the Unity Catalog and ADLS Gen2 storage. The CREATE AUTHORIZATION DDL can be used to create the authorization objects.

The Authorization object for Azure contains the Azure Active Directory service principal client id (user) and the Azure Active Directory service principal client secret key(password).

CREATE AUTHORIZATION auth_invoker_unity  
   AS INVOKER TRUSTED
   USER '<azure_principal_clientid> ' -- Azure AD service principal client id
   PASSWORD '<client_secret_key>';    -- Azure AD service principal client secret key