Amazon Athena to Data Studio Connector — Free

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

370K+

Data marts delivered

Created and served by OWOX to business users

132K+

npm installs[3]

Self-managed OWOX Edition from GitHub

[1] Google Workspace Marketplace[2] G2.com reviews[3] OWOX GitHub

Step 1: Gather Your AWS Credentials

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

• A****WS 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

View Guide →

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 4: Build & Run Your Query

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

Start now Request a demo

Step 5: Build Your Perfect Data 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 Data Studio.

Build Data Studio dashboard

What users are saying

Not testimonials. Comment threads.

From the founder and CMO who actually run on it. Each quote is a real thing they said – attached to a specific claim.

C3

re: trusting AI

Nodari Rizun

Founder & CEO, Pürblack®

“AI by its nature will hallucinate. You need guardrails so you can trust your data.”

A1

re: one source of truth

Mark Simmons

CMO, Pürblack®

“We had six or seven different channels and no single source of truth. It was almost impossible”

E7

re: getting time back

Nodari Rizun

Founder & CEO, Pürblack®

“We regained time. And time is the one resource that never comes back.”

From the blog

Learn how teams ship analytics faster

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

See all articles →

Analytics Tools Data mart vs dashboard vs chatbots: which analytics architecture actually wins?

AI Vibe analytics is a hallucination machine

Data Integration Your data is hostage to someone else’s API – the case for warehouse-first analytics

Data Modeling Forex & CFD broker data model: a free client-acquisition template