Example: Creating an Azure Service Principal Authorization Object and Use It with READ_NOS

Example: Creating an Azure Service Principal Authorization Object and Use It with READ_NOS - Teradata Vantage

Teradata® VantageCloud Lake

Deployment

VantageCloud

Edition

Lake

Product

Teradata Vantage

Published

January 2023

Language

English (United States)

Last Update

2024-04-03

dita:mapPath

phg1621910019905.ditamap

dita:ditavalPath

pny1626732985837.ditaval

dita:id

phg1621910019905

Create the authorization object or ask an administrator to create it:
```
CREATE AUTHORIZATION Asp_Simple_Auth
USING
AUTHSERVICETYPE 'AZURE_SERVICE_PRINCIPAL'
CLIENT_ID 'client_id'
CLIENT_SECRET 'client_secret'
TENANT_ID 'tenant_id';
```
Where:
- client_id is the application identification for the Azure service principal.
- client_secret is the password associated with the Azure service principal.
- tenant_id is the identifier of Microsoft Entra ID instance.

Use the authorization object in a query.

For example, use the authorization object with a READ_NOS query:

SELECT * FROM READ_NOS (
USING
LOCATION('/AZ/your-storage.blob.core.windows.net/test-az-sp/ut.csv')
AUTHORIZATION(Asp_Simple_Auth)
RETURNTYPE('NOSREAD_RECORD')
) AS d;