-
Print
-
DarkLight
-
PDF
Overview
In this article we will discuss how to connect an Amazon Athena database to Preset. So let's get started!
Allowlist Preset IPs
Preset Cloud currently runs on three regions with the IPs listed below, and those need to be allowlisted so Preset can access your data.
Before starting, please take a moment to allowlist the IPs below based on the region that you're deployed in.
us-west-2 | us-east-1 | eu-north-1 | ap-northeast-1 |
---|---|---|---|
35.161.45.11 | 44.193.153.196 | 13.48.95.3 | 35.74.159.67 |
54.244.23.85 | 52.70.123.52 | 13.51.212.165 | 35.75.171.157 |
52.32.136.34 | 54.83.88.93 | 16.170.49.24 | 52.193.196.211 |
Connect Database to Preset
Let's start by selecting + Database — have a look at Connecting your Data if you need help wth this step.
...then, in the Connect a database window, select the Amazon Athena card.
Define Display Name and URI
In the Display Name field, enter a database nickname for display in the Preset environment.
In the SQLAlchemy URI field, enter the unique URI based on the following syntax, being careful to enter the relevant token, host, and database name details.
awsathena+rest://<aws_access_key_id>:<aws_secret_access_key>@athena.<region name>.amazonaws.com/<database name>?s3_staging_dir=s3://<s3 bucket>/&work_group=<work group>
The screen should similar to the following:
Make the Connection
Next, navigate back to the Basic tab and then select Test Connection.
A notification message will appear indicating success or failure. If the test worked, then go ahead and select Connect to finalize the database connection.
Great work!