Cannot specify Athena workgroup when using sqlalchemy

[milescrawford]

When using the library directly, you can provide a work_group argument to the call to connect.

However, I do not see any way to specify which work group is to be used when using pyathena with sqlalchemy - there doesn't appear to be a way to include a workgroup in the connection string.

Is there a way to work around this, or should some explicit means of setting workgroup for sqlalchemy be added?

Thank you!

[laughingman7743]

In SQLAlchemy, you should be able to specify the workgroup name as a parameter in the connection string as follows.

awsathena+rest://athena.region_name.amazonaws.com:443/schema_name?s3_staging_dir=s3_staging_dir&work_group=work_group_name

[milescrawford]

Oh of course. Sorry, I somehow saw the list of dialect options below and thought that was the available set for the connection string. But of course all the parameters to the connect method are supported. Thank you!