Example: Creating a Azure Service Principal Authorization Object and Use It with WRITE_NOS - Teradata Vantage

CREATE AUTHORIZATION Asp_Simplified_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.

CREATE FOREIGN TABLE Asp_Tab,
EXTERNAL SECURITY Asp_Simplified_Auth
USING( 	  
LOCATION('/AZ/your-storage.blob.core.windows.net/test-az-sp/ut.csv'));

SELECT * FROM WRITE_NOS (
ON (SELECT * FROM Asp_Tab)
USING
LOCATION('AZ/your-storage.blob.core.windows.net/test-az-sp/new/')
MAXOBJECTSIZE('16MB')
AUTHORIZATION(Asp_Simplified_Auth)
STOREDAS('CSV')
) AS d;