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.
OWOX is always there to help
Our agency is very glad to work with OWOX for numerous reasons: service/support: OWOX is always...
Trainings with OWOX
We asked their help to get more information about Google Analytics and Tag Manager....
Amazing product and team
We are using OWOX BI BigQuery Report for Google Spreadsheet and love it! It’s powerful as it give...
Absolutely Fantastic!
We tried achieving similar results using other tools but always hit a roadblock. OWOX BI SQL Copilot made it incredibly easy and effective — thank you!
How to Split Cells in Google Sheets
What is a Query?
Data Collection: Stage #2 of the Data Analysis Process
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
How to Calculate LTV with CRM and ERP
How Does ERP Analytics Transform Business? 5 Key Ways