Database driver Amazon Athena
Note: This driver is available in Lite, Enterprise, Ultimate and Team editions only.
- Overview
- Setting up
- Athena connection settings
- Secure connection configurations
- Powering Athena with DBeaver
This documentation outlines the process of configuring and using AWS Athena with DBeaver.
To manage databases using AWS Athena in DBeaver, establishing a connection is essential. This is done by selecting
the Athena
option in the database connection settings of DBeaver. For those new to this process,
our Creating a Connection article provides detailed guidance.
Tip: Users with Ultimate and Team editions of DBeaver can connect to their AWS Athena databases using the Cloud Explorer.
AWS Athena, as an analytical database service, has limitations compared to traditional relational databases. It does
not support real-time data changes, such as adding or updating data. Also, Athena cannot modify data using DELETE
or UPDATE
commands. It lacks constraint enforcement like primary keys and foreign keys. For more detailed information,
refer to the AWS Athena database documentation.
Important: In DBeaver, AWS Athena is read-only.
For a detailed overview of the supported features and capabilities of AWS Athena within DBeaver, please see the section on Powering Athena with DBeaver.
This section provides an overview of DBeaver's settings for establishing a direct connection and the configuration of secure connections using SSH, Proxies, and Kubernetes.
In this subsection, we will outline the settings for establishing a direct connection to a Athena database using DBeaver. Correctly configuring your connection ensures seamless interaction between DBeaver and your Athena database.
The page of the connection settings requires you to fill in specific fields to establish the initial connection.
Field | Description |
---|---|
Region | Specify the AWS region where your Athena database is located, such as us-west-1 . This should match the region of the S3 bucket used for storing query results. |
S3 location | Enter the output location for query results in the format s3://aws-athena-query-results-[your-account-id]-[region]/ . Replace [your-account-id] with your actual AWS account ID and [region] with the region code, for example, s3://aws-athena-query-results-80980980-us-east-1/ . Ensure you have the necessary permissions set for this S3 location. |
Browse | Click to open a dialog that allows you to navigate and select an S3 bucket through DBeaver's interface. |
Show catalogs | Check this option if you want to view the data catalog in the DBeaver connection. This will show the databases and tables defined in Athena's data catalog. |
Authentication | Choose the type of authentication you want to use for the connection. For detailed guides on authentication types, please refer to the following articles: - Database native - AWS IAM - DBeaver Profile You can also read about security in DBeaver PRO. |
Connection Details | Provide additional connection details if necessary. |
Driver Name | This field will be auto-filled based on your selected driver type. |
Driver Settings | If there are any specific driver settings, configure them here. For detailed guide on driver properties please refer to the official AWS Athena documentation. |
The Connection Details section in DBeaver allows for further customization of your Athena connection. This includes options for adjusting the Navigator View, setting up Security measures, applying Filters, configuring Connection Initialization settings, and setting up Shell Commands. Each of these settings can significantly impact your database operations and workflow. For detailed guides on these settings, please refer to the following articles:
- Connection Details Configuration
- Database Navigator
- Security Settings Guide
- Filters Settings Guide
- Connection Initialization Settings Guide
- Shell Commands Guide
DBeaver supports secure connections to your Athena database. Guidance on configuring such connections, specifically SSH, Proxy, and Kubernetes connections, can be found in various referenced articles. For a comprehensive understanding, please refer to these articles:
DBeaver provides a host of features designed for Athena databases. This includes the ability to view schemas, along with numerous unique capabilities aimed at optimizing database operations.
DBeaver lets you view a range of Athena database objects, such as:
- Schemas
- Tables
- Columns
- Views
- Columns
- Procedures
- Tables
DBeaver provides additional features compatible with Athena, but not exclusive to it:
Category | Feature |
---|---|
Data Transfer | Data Export |
Schema Management | Schema Compare |
- Installation
- Application Window Overview
- Views
- Database Object Editor
- SQL Editor
- Search
- Schema compare
- Using Liquibase in DBeaver
- Data compare
- MockData generation
- Spelling
- Dashboards, DB monitoring
- Projects
- Managing Master password
- Security in PRO products
- Certificate Management
- Bookmarks
- Shortcuts
- Accessibility
- Sample Database
-
Database Connections
- Edit Connection
- Invalidate/Reconnect to Database
- Disconnect from Database
- Change current user password
- Advanced settings
- Cloud configuration settings
- Local Client Configuration
- Connection Types
- Configure Connection Initialization Settings
- Tableau integration
- Transactions
- Drivers
- Tasks
- Cloud Explorer
- Cloud Storage
- Classic
- Cloud
- Changing interface language
- DBeaver extensions - Office, Debugger, SVG
- Installing extensions - Themes, version control, etc
- User Interface Themes
- Command Line
- Reset UI settings
- Reset workspace
- Troubleshooting system issues
- Posting issues
- Log files
- JDBC trace
- Thread dump
- Managing connections
- Managing variables
- Managing drivers
- Managing preferences
- Managing restrictions
- Windows Silent Install
- Snap installation