If you are using AWS Assume Role authorization, configure your external object storage to allow Analytics Database to access it.
Depending on how you configured access to your AWS external object storage, the following variables can be used to create the authorization object. See Example: Using AWS Assume Role Authorization with WRITE_NOS and CREATE AUTHORIZATION.
The following variables are used in the CREATE AUTHORIZATION command. After you create the authorization object, use it to control access in the CREATE FOREIGN TABLE, READ_NOS, and WRITE_NOS commands.
| Keyword | Access Variable Value |
|---|---|
| AUTHSERVICETYPE | The authorization type for the storage service, such as ASSUME_ROLE. For AUTHSERVICETYPE values, see "AuthorizationsV[X] in Teradata Vantage™ - Data Dictionary, B035-1092. |
| ROLENAME | The Amazon Resource Name (ARN) of the role to assume. |
| EXTERNALID | The external ID that assumes the role. |
| DURATION_SECONDS | The duration, in seconds, of the role session. |