Open Table Connector > Connections for Open Table > Connect to Open Table
  

Connect to Open Table

Let's configure the Open Table connection properties to connect to AWS Glue Catalog.

Before you begin

Before you get started, you'll need to add the Athena JDBC driver and configure the authentication-specific prerequisites.
Permanent IAM Credentials authentication requires the access key and secret key values of the IAM user. Keep the access key and secret key handy before creating the connection. For more information about creating an access key and secret key, see the AWS documentation.
Check out Prerequisites to learn more about how to configure policies and role to access Apache Iceberg and Delta Lake tables.

Connection details

The following table describes the Open Table connection properties:
Property
Description
Connection Name
Name of the connection.
Each connection name must be unique within the organization. Connection names can contain alphanumeric characters, spaces, and the following special characters: _ . + -,
Maximum length is 255 characters.
Description
Description of the connection. Maximum length is 4000 characters.
Type
Open Table
Runtime Environment
The name of the runtime environment where you want to run tasks.
Select a Secure Agent, Hosted Agent, or serverless runtime environment.
Open Table Format
The Open Table format that you want to use to read from or write data to a catalog.
Catalog Type
The catalog that you want to connect to manage the metadata of the Open Table format.
Storage Type
The storage type that you want to use to store the Open Table format tables.
Athena JDBC URL
Enter the JDBC URL in the following format:
jdbc:athena://Region=<AWS_Region>;OutputLocation=<S3_Location>
For example, jdbc:athena://Region=us-west1;OutputLocation=s3://working/dir.
Authentication Type
The authentication type to access Open Table formats.
Access Key
The key to access the AWS Glue Catalog.
Secret Key
The secret key to access the AWS Glue Catalog. The secret key is associated with the access key and uniquely identifies the account.