Example: Datalake Definition for Iceberg Polaris with Cloud AWS S3 as storage - Teradata Vantage

This section explains how to use OTF with the Iceberg table format, utilizing Apache Gravitino as the catalog and Cloud AWS S3 for data storage. The following statements illustrate the necessary authorizations and datalake configuration.

CREATE AUTHORIZATION polaris_catalog_auth  
USER '<catalog_oauth_service_user>'  
PASSWORD '<catalog_oauth_service_user >'; 

CREATE AUTHORIZATION cloud_aws_storage_auth  
USER '<storage_cloud_aws_s3_access_key_id'  
PASSWORD '<storage_cloud_aws_s3_secret_key'; 

CREATE DATALAKE iceberg_gravitino_storagegrid_rest  
EXTERNAL SECURITY CATALOG polaris_catalog_auth ,  
EXTERNAL SECURITY STORAGE cloud_aws_storage_auth  
USING  
catalog_type ('rest') 
catalog_location ('http://hostname:port/api/catalog/') 
catalog_name('tdotf_aws_polaris_catalog')  
idp_location('http://hostname:port/api/catalog/v1/oauth/tokens') 
idp_token_scope('PRINCIPAL_ROLE:ALL')   
storage_region ('us-east-1') 
storage_location ('s3://tdotf-aws-polaris/')  
TABLE FORMAT iceberg;