Amazon Athena
Amazon Athena connection helps you connect to an Amazon Athena database and run queries directly from Infoveave.
Adding an Amazon Athena Connection
To create a new Amazon Athena connection:
- Go to the Database section.
- Select Amazon Athena from the available connectors.
- Fill in the required connection details in the New Amazon Athena Connection form.
Connection Parameters
When setting up an Amazon Athena connection, you need to provide the following details:
| Field | Description |
|---|---|
| Name | A unique name to identify your connection. |
| Port | Port number for Athena (default value is set automatically). |
| Server | The Amazon Athena server endpoint. |
| Username | Your Amazon Athena username. |
| Password | The corresponding password for the username. |
| Database | The Amazon Athena database you want to connect to. |
| Schema | The schema inside the database to be used (optional). |
Steps to Validate and Save
- After filling in the details, click Validate to verify the connection.
- If validation succeeds, click Save to store the connection.
- You can now use Amazon Athena as a datasource in your Infoveave workspace.
Example Use Case
With an Amazon Athena connection configured, you can:
- Query large datasets stored in Amazon S3.
- Use Athena SQL to analyze structured and unstructured data.
- Connect Athena data to Infoveave Infoboards for dashboards, visualizations, and reports.