Team Edition Documentation

DOWNLOAD pdf

Database driver Amazon Athena

Table of contents

Overview

This documentation outlines the process of configuring and using AWS Athena with Team Edition.

To manage databases using AWS Athena in Team Edition, establishing a connection is essential. This is done by selecting the Athena option in the database connection settings of Team Edition. For those new to this process, our Creating a Connection article provides detailed guidance.

Tip: Team Edition can connect to the AWS Athena databases using the Cloud Explorer.

Athena specialty

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 Team Edition, AWS Athena is read-only.

For a detailed overview of the supported features and capabilities of AWS Athena within Team Edition, please see the section on Powering Athena with Team Edition.

Setting up

This section provides an overview of Team Edition's settings for establishing a direct connection and the configuration of secure connections using SSH, Proxies, and Kubernetes.

Athena connection settings

In this subsection, we will outline the settings for establishing a direct connection to a Athena database using Team Edition. Correctly configuring your connection ensures seamless interaction between Team Edition 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 Team Edition's interface.
Show catalogs Check this option if you want to view the data catalog in the Team Edition 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
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.

Connection details

The Connection Details section in Team Edition 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:

Secure connection configurations

Team Edition 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:

Powering Athena with DBeaver

Team Edition 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.

Athena database objects

Team Edition lets you view a range of Athena database objects, such as:

  • Schemas

    • Tables
      • Columns
    • Views
      • Columns
    • Procedures

Athena additional features in Team Edition

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

Category Feature
Data Transfer Data Export
Schema Management Schema Compare