AWS Athena
Source + Destination — Vendo connects to AWS Athena to query your S3-backed data lake directly. Serverless, pay-per-query, and no infrastructure to manage. No VPC or IP whitelisting needed.
Key Benefits
- Zero-Copy Access — Query your data lake tables directly. Data never leaves S3.
- No Infrastructure — Athena is serverless. No clusters to manage or scale.
- No IP Whitelisting — Athena is accessed via the AWS API, not a network endpoint.
- Pay Per Query — No idle compute costs. You pay only for data scanned.
How It Works
Vendo connects via the AWS Athena API. Queries are submitted asynchronously — Athena executes them against your S3 data and writes results to a designated S3 output location. Vendo retrieves the results and processes them in memory.
No data is stored by Vendo. Query results in the S3 output bucket are managed by your AWS account.
Authentication
| Method | Description |
|---|---|
| IAM Credentials | AWS access key ID + secret access key with Athena and S3 permissions |
What You Need
- An AWS account with Athena enabled
- An S3 bucket for query results (Athena requires an output location)
- A Glue Data Catalog database with tables defined
- AWS IAM credentials with Athena and S3 permissions
Platform Details
| Setting | Value |
|---|---|
| Connection Method | AWS Athena API |
| Query Execution | Async (start + poll + get results) |
| Authentication | AWS IAM credentials |
| Data Storage | None — zero-copy (results in your S3 bucket) |
| SQL Dialect | Presto/Trino |
| VPC/Firewall | Not required |
What to Expect After Setup
- Connection Verified — Vendo tests connectivity by running a simple query
- Schema Browser — Browse databases and tables from your Glue Data Catalog
- Query Ready — Run SQL queries, build models, and create audiences
- No Sync Needed — Queries execute directly against your data lake
Related Guides
Last updated on