Athena

Amazon Athena is a user-friendly query service that provides the convenience of using regular SQL to examine data stored in Amazon S3. By directing Athena towards your data in Amazon S3, you have the ability to run spontaneous inquiries and retrieve outcomes within seconds. Additionally, Athena operates in a serverless manner, eliminating the need to establish or oversee any infrastructure. The automatic scaling feature of Athena allows for queries to be executed simultaneously, ensuring quick results even when dealing with extensive datasets and intricate queries.

Prerequisites

• Get Athena API connection parameters from the datasource owner.

Connect to Athena API

Create a new data source in two ways. Note that this permission is restricted to workspace admins and developers.

Select APIs > Athena as the data source type.

Set the details with the connection parameter fetched from the datasource owner.

(Optional) Click Test connection to check whether the API is successfully connected.

Click Save, and it will be saved to your data source library.