Example: Using AWS Assume Role Authorization with CREATE FOREIGN TABLE - Teradata Vantage

CREATE AUTHORIZATION S3Invoker_auth
AS INVOKER TRUSTED
USING
AUTHSERVICETYPE 'ASSUME_ROLE'
ROLENAME 'arn:aws:iam::844102931058:role/STSAssumeRole_TestRole'
EXTERNALID '3f68bc61-a455-4742-8039-8a03f0600db5';

CREATE FOREIGN TABLE foreign_table,
EXTERNAL SECURITY INVOKER TRUSTED S3Invoker_auth
USING (
LOCATION('/s3/s3.amazonaws.com/stsassumerole-testbucket/BILLING_STATMNT_CHARGE.csv')
);