Creating a DATALAKE using an AWS Glue Catalog - Teradata Vantage

The following example shows how to create an Iceberg DATALAKE object that is using AWS Assume Role Authorization (rolename and external_id are required here):

CREATE AUTHORIZATION iceberg_assume_role_aws
USING
AUTHSERVICETYPE 'ASSUME_ROLE'
ROLENAME '<IAM role name>'
EXTERNAL_ID '<External ID from the Trust Relationship of the IAM Role>';

CREATE DATALAKE datalake_iceberg_glue
EXTERNAL SECURITY CATALOG iceberg_assume_role_aws,
 
EXTERNAL SECURITY STORAGE iceberg_assume_role_aws
USING
   catalog_type ('glue')
   storage_location ('s3://<folder>/')
   storage_region ('us-west-2')
TABLE FORMAT iceberg;

The following example shows how to create a Delta Lake DATALAKE object that is using AWS Assume Role Authorization (rolename and external_id are required here):

CREATE AUTHORIZATION deltalake_assume_role_aws
USING
AUTHSERVICETYPE 'ASSUME_ROLE'
ROLENAME '<IAM role name>'
EXTERNAL_ID '<External ID from the Trust Relationship of the IAM Role>';

CREATE DATALAKE datalake_deltalake_glue
EXTERNAL SECURITY CATALOG deltalake_assume_role_aws,
EXTERNAL SECURITY STORAGE deltalake_assume_role_aws
USING
   catalog_type ('glue')
   storage_location ('s3://<folder>/')
   storage_region ('us-west-2')
TABLE FORMAT deltalake;