Catalog, document, and query live data from Athena by configuring a virtual connection.
When connecting your data systems to data.world, often your system or firewall may have a network policy that only allows access from specific IP addresses--your allowlist. In those cases, you must add data.world to your network policy IP allowlist.
Allow the following IP addresses:
Go to the Athena integration page and click Enable integration to set up a connection.
Before configuring a virtual connection to Athena you need to have set up an IAM role in the AWS console. You can find instructions for creating that role in the article Create a dedicated Internet Asset Management role on AWS for data.world.
In order to create a virtual connection to Athena you will use the following parameters:
AWS Region: This should be the AWS region where the Athena and AWS Glue instance reside. (e.g., us-east-1)
S3 Output Bucket Location: The Amazon S3 bucket where query results should be stored. The location should start with s3://. For example, to store results in a folder named "test-folder-1" inside an S3 bucket named "query-results-bucket", you would set the location to s3://query-results-bucket/test-folder-1.
AWS ARN: A dedicated Identity Access Management (IAM) role created specifically for data.world.
AWS external id: provided in the "Add a new Athena connection" dialog.
Choose a Display name for your connection. This is the name everyone in your organization will see for the connection. Then enter your user credential information into the dialog screen:
Click Test Athena configuration to make sure it works, and then save it by selecting Configure.
After your connection is configured you can use it anytime you select Add data:
Choose the connection you want to use from My data sources:
Go to the integration page (easily found under My integrations on our Integrations page) and select Manage:
From here you can edit your current connection or add a new one:
You will need your original credentials (password or key file) to make changes to an existing connection.
Database connectors - A full list of our connection integrations