Connecting to Data Warehouse Sync using DBeaver

Follow
Available for Roles Super Admin
Permissions • Manage Data Warehouse Sync integration
Packages Advanced Analytics add-on

In order to connect to your reporting data, you will need to connect to AWS Athena. This can be achieved in one of several ways:

  1. Using your business intelligence tool. Your BI tool should have supporting documentation on how to connect.
  2. Using an Amazon-provided driver like Open Database Connectivity (ODBC) or Java Database Connectivity (JDBC).
  3. Using a third-party tool, such as DBeaver.

This guide walks through how to connect to AWS Athena on a Mac using DBeaver. If you are interested in learning more, check out our Data Warehouse Sync help article.

Connecting to Athena using DBeaver

  • Download, install, and open the most recent version of DBeaver here: https://dbeaver.io/
  • Click New Database Connection and select 'Athena' from the available options, click Next

Database selection windows

  • Add the following details:
    • Region: This is the AWS region that you are connecting to. Currently, the only available region for DWS is "us-west-2". Refer to the connection sheet you were provided to determine your region.
    • S3 Location: Copy and paste the following location exactly. 
      jdbc:awsathena://AwsRegion=us-west-2;
    • AWS Access Key: Use the AWS Access Key provided to you in your connection sheet.
    • AWS Secret Key: Use the AWS Secret Key provided to you in your connection sheet.

Detail input modal

  • Select Edit Driver Settings and update the library (if necessary) by selecting the library and clicking Download/Update

Edit Driver Athena window with arrow pointing to Download/Update button

  • Select Connection Properties; right click in the field under 'Connection Properties'; add the following properties and values - your workgroup can be found on the provided connection sheet:
Property Value
UseResultsetStreaming 0
Workgroup [enter your workgroup]

 

Edit Driver Athena window with user properties listed

  • Click OK and Finish to test the connection. If the connection fails, save the error message and send it to Lever Support for further diagnosis. 
Was this article helpful?
0 out of 0 found this helpful