Basic connection parameters - Amazon Athena

Basic connection parameters

The following sections describe the basic connection parameters for the JDBC 3.x driver.

Region

The AWS Region where queries will be run. For a list of regions, see Amazon Athena endpoints and quotas.

Parameter name Alias Parameter type Default value
Region AwsRegion (deprecated) Mandatory (but if not provided, will be searched using the DefaultAwsRegionProviderChain) none

Catalog

The catalog that contains the databases and the tables that will be accessed with the driver. For information about catalogs, see DataCatalog.

Parameter name Alias Parameter type Default value
Catalog none Optional AwsDataCatalog

Database

The database where queries will run. Tables that are not explicitly qualified with a database name are resolved to this database. For information about databases, see Database.

Parameter name Alias Parameter type Default value
Database Schema Optional default

Workgroup

The workgroup in which queries will run. For information about workgroups, see WorkGroup.

Parameter name Alias Parameter type Default value
WorkGroup none Optional primary

Output location

The location in Amazon S3 where query results will be stored. For information about output location, see ResultConfiguration.

Parameter name Alias Parameter type Default value
OutputLocation S3OutputLocation (deprecated) Mandatory (unless the workgroup specifies an output location) none