Skip to main content
All CollectionsSystem Setup Guides
AWS Athena Connection Setup
AWS Athena Connection Setup
Updated over a week ago

Connectivity

Savant accesses your Athena from two IP addresses:

  • 35.188.163.165

  • 34.122.126.216

If your network is configured to only allow access from certain IPs, include these in your whitelist.

AWS Setup

To start, you will need to create a user to connect Savant to Athena:

  1. In AWS, open the IAM Management console

  2. In the left menu, click Users

  3. Click the Add Users button in the top left corner

  4. Give your new user a name and select the Access key option

    1. Save the new user name - we will use this to configure the Savant connection

  5. Choose Attach existing policies directly under Set permissions

  6. Attach the AmazonAthenaFullAccess and AmazonS3FullAccess policies and click Next

  7. Finishing creating your user by clicking Next: Tags, Next: Review and Create user

  8. Click Show under Secret access key and save the Access key ID and Secret access key

    1. We will use these keys to configure the Savant connection

    2. Consider the Download .csv option so you don’t lose your secret key – you can’t get this back

Next, we need to get some information from your Athena:

  1. Navigate to your Athena

  2. Make sure you are in the correct Region (in the top right) and save it

    1. This will be the region we set in Savant

  3. Save the database name you want to access with Savant

    1. This will be the database name we set in Savant

  4. Click Settings in the top bar

  5. Save the path under Query results location

    1. This will be the S3 Staging Directory we set in Savant

Getting Started in Savant

Once you’ve completed the steps above, follow these steps in Savant:

  1. Go to the Systems page and click Add System

  2. Select the Athena connector and click Next

  3. Enter your system information and credentials (from the steps above)

    1. You do not need to enter a Role ARN

  4. Click Authenticate and then Confirm

You can now create Athena datasets in Savant!

Did this answer your question?