IAM profile
You can configure a named profile to connect to Amazon Athena using the ODBC driver. To
use the credentials available in your hosting Amazon EC2 instance profile, set the
credential_source parameter to Ec2InstanceMetadata. If you
want to use a custom credentials provider in a named profile, specify a value for the
plugin_name parameter in your profile configuration.
Authentication type
| Connection string name | Parameter type | Default value | Connection string example |
|---|---|---|---|
| AuthenticationType | Required | IAM Credentials |
AuthenticationType=IAM Profile; |
Amazon profile
The profile name to use for your ODBC connection. For more information about profiles, see Using named profiles in the Amazon Command Line Interface User Guide.
| Connection string name | Parameter type | Default value | Connection string example |
|---|---|---|---|
| AmazonProfile | Required | none |
AWSProfile=default; |
Preferred role
The Amazon Resource Name (ARN) of the role to assume. The preferred role parameter
is used when the custom credentials provider is specified by the
plugin_name parameter in your profile configuration. For more
information about ARN roles, see AssumeRole in the
Amazon Security Token Service API Reference.
| Connection string name | Parameter type | Default value | Connection string example |
|---|---|---|---|
| preferred_role | Optional | none |
preferred_role=arn:aws:IAM::123456789012:id/user1; |
Session duration
The duration, in seconds, of the role session. For more information about session
duration, see AssumeRole in the
Amazon Security Token Service API Reference. The session duration
parameter is used when the custom credentials provider is specified by the
plugin_name parameter in your profile configuration.
| Connection string name | Parameter type | Default value | Connection string example |
|---|---|---|---|
| duration | Optional | 900 |
duration=900; |
Plugin name
Specifies the name of a custom credentials provider used in a named profile. This
parameter can take the same values as those in the Authentication
Type field of the ODBC Data Source Administrator, but is used only by
AWSProfile configuration.
| Connection string name | Parameter type | Default value | Connection string example |
|---|---|---|---|
| plugin_name | Optional | none |
plugin_name=AzureAD; |