How can I connect to s3 table bucket using athena jdbc driver v3?

To connect to S3 table buckets using the Athena JDBC v3 driver, you need to register the S3 table bucket catalog as a data source in Athena first, and then reference it in your JDBC connection.

When working with S3 table buckets, the catalog is typically in the format s3tablescatalog/your-bucket-name. This is different from the default AWS Glue Data Catalog that Athena normally uses.

For the JDBC connection, you would need to specify this catalog using the Catalog parameter in your connection string. The confusion arises because in the Athena console UI, this is referred to as a "data source," while in the JDBC driver parameters, it's called a "catalog."

Your JDBC connection string should look something like this:

jdbc:athena://AwsRegion=us-east-1;Catalog=s3tablescatalog/your-bucket-name;Schema=your_namespace;

Where:

• s3tablescatalog/your-bucket-name is your S3 table bucket catalog
• your_namespace is the namespace where your table is stored

Make sure that you have properly registered the S3 table bucket catalog in Athena before attempting to connect via JDBC. Also ensure that the user or role you're using with the JDBC driver has the necessary Lake Formation permissions to access the S3 tables, as insufficient permissions are a common cause of connection issues.
Sources
Querying Amazon S3 tables with Athena - Amazon Simple Storage Service
Register S3 table bucket catalogs and query Tables from Athena - Amazon Athena
S3 Tables - Unable to query using Athena | AWS re:Post