Database driver Amazon Athena

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.

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, Kubernetes, AWS SSM and SSL connections, can be found in various referenced articles. For a comprehensive understanding, please refer to these articles:

• SSH Configuration

• Proxy Configuration

• SSL Configuration

• Kubernetes Configuration

• AWS SSM

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

DBeaver provides additional features compatible with Athena, but not exclusive to it:

Category	Feature
Data Transfer	Data Export
Schema Management	Schema Compare