Overview
Amazon Athena is an interactive query service that lets you analyze data directly in Amazon S3 using standard SQL. In Zenskar, you can use Athena as a data source to query, process, and sync usage or event data stored in your Amazon S3 buckets. The Athena connector enables Zenskar to fetch metering data efficiently, making it available for billing, reporting, and analytics within the Zenskar platform. The Amazon Athena data-source connector allows you to:- Connect securely to your Athena environment through AWS credentials.
- Query and import data directly from Amazon S3 using predefined databases and tables.
- Automate periodic data syncs for accurate and up-to-date billing computations.
- Maintain full control over data visibility and access through AWS IAM and Lake Formation permissions.
Prerequisites
To use this connector, you will need the following:- An AWS account
- An S3 bucket where the data will be written
- An Amazon Lake Formation database where tables will be created (one per stream)
- AWS credentials: Access Key Id and Secret Access Key
Set up an Amazon Athena data-source connector via Zenskar dashboard
- Log into your Zenskar dashboard.
- In the left side bar, click Usage > Data Sources.
- In the top-right corner, click + ADD DATA SOURCE.
- On the Add New Data Source page, configure the ClickHouse connector.
- Click on the SAVE SOURCE button.
Connector configuration
General configuration
Connector configuration
Addendum
Permissions
The IAM user or role must have access to the following AWS services:- Amazon Lake Formation
- Amazon Glue
- Amazon S3