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.