Connection URL

Specifying the Host and Port

The 2.x version provides an alternative way to specify the AWS region.

1.x Version	2.x Version
`jdbc:awsathena://athena.{REGION}.amazonaws.com:443` Where `{REGION}` is a region identifier, such as `us-west-2`	`jdbc:awsathena://athena.{REGION}.amazonaws.com:443` Or `jdbc:awsathena://AwsRegion={REGION}` Where `{REGION}` is a region identifier, such as `us-west-2`. If `{REGION}` is specified using both endpoint URL and `AwsRegion`, the value specified in `AwsRegion` takes precedence.

Changes are not required in this case, but be aware the 2.x version provides an alternative way to specify the AWS region in the connection URL.

The connectors use different attribute separators in their connection URLs.

1.x Version	2.x Version
`&` and `?`	`;`

The following is an example connection URL using the 1.x version syntax:

jdbc:awsathena://athena.us-west-1.amazonaws.com:443?s3_staging_dir=s3://query-resultsbucket/folder/&query_results_encryption_option=SSE_S3

The following shows the equivalent URL constructed using the 2.x version syntax:

jdbc:awsathena://athena.us-west-1.amazonaws.com:443;s3_staging_dir=s3://query-resultsbucket/folder/;query_results_encryption_option=SSE_S3