search

kovihq / sqltools-athena-driver

AWS Athena Driver for VSCode Plugin SQLTools
MIT License
5 stars 11 forks source link

readme

SQLTools driver for AWS Athena

Description

A Visual Studio Code extension which extends the SQLTools extension, with a driver to work with AWS Athena. It supports tables and views, as well as running queries.

Configuration

When creating a new connection with AWS Athena, you'll be prompted to fill some authentication info.

Connection setup print

Access Key Id & Secret Access Key

You can create an authentication using AWS IAM. Be sure that the IAM user has the right privileges to query AWS Athena.

Workgroup

It's the workgroup which will run the queries. Refer to athena workgroup documentation. Usually the primary workgroup is the one to go.

AWS Region

The AWS Region code where your queries should be run. Refer to the AWS Region Code Table.

S3 Output Location

The query result bucket location in Amazon S3. Required only if output location is not specified in the workgroup.

Usage

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.

Support

Please open issues on github.