Amazon Athena with DBine
How to connect DBine to Amazon Athena and what you can do once it's connected. This page is written from what the Amazon Athena driver says about itself, so it matches the version of DBine you download.
Connect
- In DBine, open New connection.
- Pick Amazon Athena in the list of engines.
- Fill in the fields below, press Test connection and then Save.
General
| Field | Description |
|---|---|
| Region | If left empty, the one from the profile or AWS_REGION is used. Example: us-east-1 |
| Authentication | The default chain uses environment variables, ~/.aws, SSO or the instance role. Options: AWS default chain, ~/.aws profile, Access keys Default: AWS default chain |
| Profile | Example: defaultOnly with Authentication: ~/.aws profile. |
| Access key ID | Only with Authentication: Access keys. |
| Secret access key | Kept in the system keychain, never in DBine's files. Only with Authentication: Access keys. |
| Session token | Temporary credentials only. Kept in the system keychain, never in DBine's files. Only with Authentication: Access keys. |
| Workgroup | Default: primary |
| Data catalog | Default: AwsDataCatalog |
| Database | Example: default |
| Read-only | On or off. |
Advanced
| Field | Description |
|---|---|
| Results location | Required if the workgroup doesn't define one. Example: s3://my-bucket/athena-results/ |
What the explorer shows
Under the connection: Databases. Inside each one:
- Tables
- Views
Query editor
The editor uses SQL, with completion for the connection's objects. Statements and commands run against the database selected in the tab.
Ready-made templates for new objects:
- New view
Tools for Amazon Athena
Available
- Graphical execution plans
- Live query profiler
- Server monitor
- Sessions and running queries
- Cancel another session's query from the sessions list
- Create databases
- Drop databases
- Database properties
- Visual designer for new objects
- Rename objects
- Compare and sync schemas
- Native bulk load when migrating data
Not available for Amazon Athena
- End a session
- Locks: who blocks whom
- Manual transactions (commit and rollback)
- Index usage
- Relations in the ER diagram
- Clone tables
- Users and permissions
- Backups
Why a tool doesn't apply to an engine, and the details of each one, are in the engine support reference.
Generated from the Amazon Athena driver 0.1.11, which DBine downloads the first time you connect to Amazon Athena.