Skip to main content

Example: Using Workgroups

A workgroup is an Database 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 Database through the Product, write a connection URL that sets the Workgroup property to the name of your workgroup. For example, to use a workgroup named SimbaAdmins:

jdbc:awsdatabase://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 Database, and all workgroup handling takes place in the Database service instead of in the connector.

Was this article helpful?

We're sorry to hear that.