Connect Athena to Looker Studio in minutes. No ETL. No setup nightmares. Just your dashboards, powered by raw query results.
To authenticate securely, generate the keys from your AWS IAM dashboard. You'll need:
Attach AmazonAthenaFullAccess and AmazonS3FullAccess to your IAM user to ensure smooth data access and query storage.
AmazonAthenaFullAccess
AmazonS3FullAccess
Create a result bucket in the same region as Athena. It’s where your query results will be temporarily stored.
Write your SQL query using Athena syntax. Test it in the Athena Console, then plug it into Looker Studio.
Use the data mart you've created based on the data from Athena to get the perfect marketing, sales, product or any other dashboard in Looker Studio.
No ETL, no 3rd-party storage, no nonsense. Just your data — visualized your way. Absolutely Free Forever.
Great job, OWOX team!
We’ve been working with OWOX on ROPO analysis for the past 6 months. By reconciling data...
A leap forward to better analytics
OWOX BI helped us take ANSWEAR’s analytics strategy up a level. By collecting data...
Productivity Booster
OWOX BI SQL Copilot has revolutionized our data analysis workflow. Generating SQL queries...
Automated Reporting, Unmatched Precision
I can finally automate reporting across my business with the precision and flexibility that I could previously only get from a team of 20 people
What is Data Analytics?
What is a Query?
8 Reasons to Export GA4 Data to BigQuery
Understanding the PERCENTRANK Function in Google Sheets: Rank Data by Percentile
OWOX Data Marts in 2025: What We Built and What’s Coming Next
Mastering the RANK Function in Google Sheets: Rank Values Like a Pro
Free Google Ads to BigQuery Connector by OWOX: Take Control of Your Ad Data at Scale