Example: Using Workgroups

A workgroup is an Athena feature that enables you to control the data access and costs associated with running queries. For more information, see "Using Workgroups to Control Query Access and Costs" in the Amazon Athena User Guide: https://docs.aws.amazon.com/athena/latest/ug/manage-queries-control-costs-with-workgroups.html.

To use a workgroup when connecting to Athena through the Simba Amazon Athena JDBC Connector, write a connection URL that sets the Workgroup property to the name of your workgroup. For example, to use a workgroup named SimbaAdmins:

jdbc:awsathena://AwsRegion=us-west-1;User=FJ4EK9SEO2KFk;Password=P9PcyQ7prK2LwUMZMpFQ4R+5VE;S3OutputLocation=s3://working/dir;Workgroup=SimbaAdmins;

Specifying a workgroup does not change the way that you run SQL statements or make JDBC API calls. The connector passes the workgroup name to Athena, and all workgroup handling takes place in the Athena service instead of in the connector.