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:
In AWS, open the IAM Management console
In the left menu, click Users
Click the Add Users button in the top left corner
Give your new user a name and select the Access key option
Save the new user name - we will use this to configure the Savant connection
Choose Attach existing policies directly under Set permissions
Attach the AmazonAthenaFullAccess and AmazonS3FullAccess policies and click Next
Finishing creating your user by clicking Next: Tags, Next: Review and Create user
Click Show under Secret access key and save the Access key ID and Secret access key
We will use these keys to configure the Savant connection
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:
Navigate to your Athena
Make sure you are in the correct Region (in the top right) and save it
This will be the region we set in Savant
Save the database name you want to access with Savant
This will be the database name we set in Savant
Click Settings in the top bar
Save the path under Query results location
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:
Go to the Systems page and click Add System
Select the Athena connector and click Next
Enter your system information and credentials (from the steps above)
You do not need to enter a Role ARN
Click Authenticate and then Confirm
You can now create Athena datasets in Savant!