Amazon Athena DB

Owned by Juliane Wetzel
Last updated: Aug 17, 2020

INFO

Amazon Athena DB is a query service in that companies are able to run SQL queries against their data as though it resides in a local data center.

Prerequisites

Preparing Amazon Athena DB

INFO

Set up your Amazon S3 instance accordingly.

Uploading the Database Driver

INFO

Set up the database driver in the 'Admin' tab.

Configuring Amazon Athena as a Connection

To configure Amazon Athena DB as a connector:

  1. Click the "+" button and select "Connection" or right-click in the File Browser and select "Create New" → "Connection". The "New Connection" tab appears in the menu bar.
     or 
  2. Select "Athena" from the drop-down and confirm with "Next". The type is displayed in the drop-down.
     
  3. Enter the connection string from the database driver. 
     
  4. Choose "Provide credentials", enter the username and password from the connection string and confirm with "Next". The 'Save Connection' tab opens.
     
  5. If needed, enter a description and confirm with "Next". The 'Save Connection' dialog opens.
     
  6. Select the folder to save the connection, enter a name in "Save as" and confirm with "Save". The connection is saved. Configuring the Athena DB connection is finished. 

Importing Data with an Amazon Athena Connector 

INFO

Find how to import via Amazon Athena here.