AWS Athena integration
AWS Athena data, in your warehouse.
A built-in ingestr connector: add credentials, pick tables, schedule it.
name: raw.table
type: ingestr
parameters:
source_connection: amazon_athena
source_table: '<table>'
destination: snowflake
incremental_strategy: merge$ bruin run assets/raw/aws_athena.asset.yml
- extract · AWS Athena dataincremental
- load · snowflake raw.datamerged
- checks · not_null, unique
Loaded and checked. Downstream models can run.
How it connects
Connected in three steps.
Interactive query service that allows users to analyze data directly in Amazon S3 using standard SQL, storing data as Parquet files with AWS Glue Catalog integration.
- 01
Add a Amazon Athena connection with its credentials.
- 02
Pick the tables to load and how: replace, append or merge.
- 03
Bruin runs it on your schedule and checks every load.
Connection parameters
- bucket
- S3 bucket name for storing Parquet files
- access_key_id
- AWS access key ID for authentication
- secret_access_key
- AWS secret access key for authentication
- region_name
- AWS region for Athena service and S3 buckets
- workgroup
- Athena workgroup name
- profile
- AWS profile name to use
The platform
Part of the Bruin platform.
Data in, ready for everything downstream: the models, the checks, the lineage and the AI layer.
Sources
DatabasesWarehousesApps & APIsFiles & storageStreams & webhooksWeb scrapingMove
Data IngestionFrequently asked
Questions about AWS Athena.
Does Bruin have a built-in AWS Athena integration?
Yes. Built-in ingestr source. Built-in ingestr destination. Runs SQL and Python assets.
Where can AWS Athena data go?
Snowflake, BigQuery, Databricks, Redshift, ClickHouse, Postgres, DuckDB, MotherDuck, Microsoft Fabric and more, plus files on S3 and GCS.
How fresh is the data?
As fresh as your schedule. Incremental loads append, merge or replace a time window, every few minutes if you like.
Do we need Bruin Cloud?
No. The Bruin CLI and ingestr run locally, in CI or in your own orchestrator. Bruin Cloud adds scheduling, lineage, alerts and the AI data analyst on top.
Ready to connect AWS Athena?
$100 in credits and 50 AI tasks. No credit card.
A demo walks through your own data.