NewAI Insights — your data, analyzed on a schedule→

Visualize Your Amazon Athena Data in Looker Studio — Instantly

Connect Athena to Looker Studio in minutes. No ETL. No setup nightmares. Just your dashboards, powered by raw query results.

Get started free →
app.owox.com / data-marts / athena-looker-studio
Athena to Looker Studio Connector
Trusted, proven, recognized

The analytics system teams actually use

170K+
Users trust OWOX[1]
Analysts, marketers, and data teams across 20+ industries
4.9★
Rating on G2[2]
“A trusted data analytics partner” — verified review
365K+
Data marts delivered
Created and served by OWOX to business users
92K+
npm installs[3]
Self-hosted OWOX Community Edition on GitHub
[1] Google Workspace Marketplace[2] G2.com reviews[3] OWOX GitHub
Skip the Middleman. Go Straight From Athena to Insights.

Skip the Middleman. Go Straight From Athena to Insights.

Why waste time copying data when you can plug directly into your Athena warehouse and start analyzing in Looker Studio?

Step 1: Gather Your AWS Credentials

To authenticate securely, generate the keys from your AWS IAM dashboard. You'll need:

  • AWS Access Key ID: Your AWS access key
  • AWS Secret Access Key: Your AWS secret key
  • AWS Region: The AWS region where your Athena is located
  • Database Name: The name of your Athena database
AWS IAM Credentials
View Guide →
Step 1: Gather Your AWS Credentials
Step 2: Grant the Right Permissions

Step 2: Grant the Right Permissions

Attach AmazonAthenaFullAccess and AmazonS3FullAccess to your IAM user to ensure smooth data access and query storage.

See Permissions Setup →
Request a demo

Step 3: Set Up Your Output S3 Bucket

Create a result bucket in the same region as Athena. It’s where your query results will be temporarily stored.

Create a Bucket →
Step 3: Set Up Your Output S3 Bucket
Step 4: Build & Run Your Query

Step 4: Build & Run Your Query

Write your SQL query using Athena syntax. Test it in the Athena Console, then plug it into Looker Studio.

Start now
Request a demo

Step 5: Build Your Perfect Looker Studio Dashboard

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.

Build Looker Studio dashboard
Step 5: Build Your Perfect Looker Studio Dashboard

Start Building Dashboards from Athena Data

No ETL, no 3rd-party storage, no nonsense. Just your data — visualized your way. Absolutely Free Forever.

Visualize your data now
Request a demo
What users are saying

Not testimonials. Comment threads.

From people who actually use the product. Each quote is attached to a specific claim.

A1
· re: warehouse integration
KP
Katya P.
BI Manager

Finally, a tool that doesn't ask business users to learn a new dashboarding UI. Our marketing team already knows Sheets. OWOX just delivers the right data.

C3
· re: governance
MR
Marco R.
Head of Data

Joinable data marts concept was the thing that sold us. We can now use the semantic layer without building one.

E7
· re: open source
JC
James C.
Data Analyst

Self-hosted the OSS version on Digital Ocean. Zero vendor lock-in. Contributed a Shopify connector back in week two.

From the blog

Learn how teams ship analytics faster

Deep dives on data marts, governance, and modern reporting workflows.

See all articles →
Self-service analytics doesn't exist. Here's the architecture that works.
AI

Self-service analytics doesn't exist. Here's the architecture that works.

June 3, 2026
→
How to Connect LinkedIn Ads to Databricks
Databricks

How to Connect LinkedIn Ads to Databricks

June 3, 2026
→
The AI reporting analytics team that replaces your backlog, not your people
Data Analytics

The AI reporting analytics team that replaces your backlog, not your people

June 3, 2026
→
How to Connect Facebook Ads Data to Google Sheets (Free, Automated, No Code)
Data Integration

How to Connect Facebook Ads Data to Google Sheets (Free, Automated, No Code)

May 27, 2026
→