A Visual Studio Code extension which extends the SQLTools extension, with a driver to work with AWS Athena Engine v2. It supports tables and views, as well as running queries.
This is heavily based off of SQLTools Athena Driver, but has been extended to support AWS Profiles, intellisense schema completions and Athena Engine V2.
When creating a new connection with AWS Athena, you'll be prompted to fill some authentication info.
You can create an authentication using AWS IAM or by using a named profile. Be sure that the IAM user/profile has the right privileges to query AWS Athena.
It's the workgroup which will run the queries. Refer to athena workgroup documentation.
Usually the primary workgroup is the one to go.
The AWS Region code where your queries should be run. Refer to the AWS Region Code Table.
After installing the SQLTools driver for AWS Athena, you will be able to create connections to AWS Athena, explore tables and views, and run queries. For more information on how to use SQLTools please refer to SQLTools extension.
Please open issues on github.