--- title: "Amazon Athena to Data Studio Connector — Free | OWOX" canonical: "https://www.owox.com/athena-to-looker-studio-connector" updated: "2026-10-19" --- # Amazon Athena to Data Studio Connector — Free [NewAI Insights — your data, analyzed on a schedule→](/features/ai-insights) # Visualize Your Amazon Athena Data in Data Studio — Instantly Connect Athena to Data Studio in minutes. No ETL. No setup nightmares. Just your [dashboards](/product/dashboards), powered by raw query results. [Get started free →](https://owox.com/app-signup) [app.owox.com / data-marts / athena-looker-studio ![Athena to Data Studio Connector](https://cdn.owox.com/www/webflow/6835e24ccc63d00bd605ff2e_1208d8a9530c9ad9c6fe1043df7c115d_Athena-Looker-Studio.png/public)](https://owox.com/app-signup) Trusted, proven, recognized ## The analytics system teams actually use ![](https://cdn.owox.com/www/webflow/69f49f6a07f21da769983cff_588eda484d88cbf96188e98dea8196fa_svgviewer-output-1-1.svg/public) 170K+ Users trust OWOX[\[1\]](https://workspace.google.com/marketplace/app/owox_bigquery_data_marts/263000453832?utm_source=owox.com&utm_medium=website&utm_campaign=sign-up) Analysts, marketers, and data teams across 20+ industries ![](https://cdn.owox.com/www/webflow/69f49fdb1489539e77bde8d0_Star.svg/public) 4.9★ Rating on G2[\[2\]](https://www.g2.com/products/owox/reviews) “A trusted data analytics partner” — verified review ![](https://cdn.owox.com/www/webflow/69f49fdb64e29d045400b773_Database.svg/public) 370K+ Data marts delivered Created and served by OWOX to business users ![](https://cdn.owox.com/www/webflow/69f49fdb6c940f623710428e_Package.svg/public) 132K+ npm installs[\[3\]](https://github.com/OWOX/owox-data-marts) Self-managed OWOX Edition from GitHub [\[1\] Google Workspace Marketplace](https://workspace.google.com/marketplace/app/owox_bigquery_data_marts/263000453832?utm_source=owox.com&utm_medium=website&utm_campaign=sign-up) [\[2\] G2.com reviews](https://www.g2.com/products/owox/reviews) [\[3\] OWOX GitHub](https://github.com/OWOX/owox-data-marts) ## 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 [![AWS IAM Credentials](https://cdn.owox.com/www/webflow/6835e54b810c2574b96fb32a_Untitled-design-2.png/public)](https://support.owox.com/hc/en-us/articles/36775452606868-How-to-Set-Up-the-Amazon-Athena-Data-Connector-for-Looker-Studio-Dashboards) [View Guide →](https://support.owox.com/hc/en-us/articles/36775452606868-How-to-Set-Up-the-Amazon-Athena-Data-Connector-for-Looker-Studio-Dashboards) [![Step 1: Gather Your AWS Credentials](https://cdn.owox.com/www/webflow/6835e54b810c2574b96fb32a_Untitled-design-2.png/public)](https://support.owox.com/hc/en-us/articles/36775452606868-How-to-Set-Up-the-Amazon-Athena-Data-Connector-for-Looker-Studio-Dashboards) ![Step 2: Grant the Right Permissions](https://cdn.owox.com/www/webflow/6835daa0dd3d59bf27e06e53_1.png/public) ## Step 2: Grant the right permissions Attach **`AmazonAthenaFullAccess`** and **`AmazonS3FullAccess`** to your IAM user to ensure smooth data access and query storage. ![A screenshot showing IAM permissions for Athena access.](https://cdn.owox.com/www/webflow/6835daa0dd3d59bf27e06e53_1.png/public) [See Permissions Setup → Request a demo](https://support.owox.com/hc/en-us/articles/36775452606868-How-to-Set-Up-the-Amazon-Athena-Data-Connector-for-Looker-Studio-Dashboards) ## 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. [![A screenshot of the S3 bucket setup for Athena output.](https://cdn.owox.com/www/webflow/6835daa0886682c193bf5f91_2.png/public)](https://support.owox.com/hc/en-us/articles/36775452606868-How-to-Set-Up-the-Amazon-Athena-Data-Connector-for-Looker-Studio-Dashboards) [Create a Bucket →](https://support.owox.com/hc/en-us/articles/36775452606868-How-to-Set-Up-the-Amazon-Athena-Data-Connector-for-Looker-Studio-Dashboards) [![Step 3: Set Up Your Output S3 Bucket](https://cdn.owox.com/www/webflow/6835daa0886682c193bf5f91_2.png/public)](https://support.owox.com/hc/en-us/articles/36775452606868-How-to-Set-Up-the-Amazon-Athena-Data-Connector-for-Looker-Studio-Dashboards) ![Step 4: Build & Run Your Query](https://cdn.owox.com/www/webflow/6818dcf62b552c151c936163_Group-23137383.png/public) ## 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. ![A screenshot of an Athena SQL query in the console.](https://cdn.owox.com/www/webflow/6818dcf62b552c151c936163_Group-23137383.png/public) [Start now Request a demo](https://support.owox.com/hc/en-us/articles/36775452606868-How-to-Set-Up-the-Amazon-Athena-Data-Connector-for-Looker-Studio-Dashboards) ## 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. [![A diagram showing Athena, data processing and Data Studio.](https://cdn.owox.com/www/webflow/6796f3ba9a0faebde6a14c0e_Products---MA---4.-Hassle-free-data-analysis.svg/public)](https://support.owox.com/hc/en-us/articles/36775452606868-How-to-Set-Up-the-Amazon-Athena-Data-Connector-for-Looker-Studio-Dashboards) [Build Data Studio dashboard](https://support.owox.com/hc/en-us/articles/36775452606868-How-to-Set-Up-the-Amazon-Athena-Data-Connector-for-Looker-Studio-Dashboards) [![Step 5: Build Your Perfect Data Studio Dashboard](https://cdn.owox.com/www/webflow/6796f3ba9a0faebde6a14c0e_Products---MA---4.-Hassle-free-data-analysis.svg/public)](https://support.owox.com/hc/en-us/articles/36775452606868-How-to-Set-Up-the-Amazon-Athena-Data-Connector-for-Looker-Studio-Dashboards) 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](https://cdn.owox.com/www/webflow/6a7b298b2ca5055443187566_nodari-headshot.png/public) 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](https://cdn.owox.com/www/webflow/6a7b298b2b9daab0ade631d7_mark-headshot.png/public) **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](https://cdn.owox.com/www/webflow/6a7b298b2ca5055443187566_nodari-headshot.png/public) 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 →](/blog/articles) [![Data mart vs dashboard vs chatbots: which analytics architecture actually wins?](https://cdn.owox.com/www/webflow/6a84a25ad8c8f478846656b4_Data-mart-vs-dashboard-vs-chatbots-which-analytics-architecture-actually-wins.png/public) Analytics Tools Data mart vs dashboard vs chatbots: which analytics architecture actually wins?](/blog/articles/data-mart-vs-dashboard-analytics-architecture) [![Vibe analytics is a hallucination machine](https://cdn.owox.com/www/webflow/6a7f307c51f1077b6a54be8b_Vibe-analytics-is-a-hallucination-machine.png/public) AI Vibe analytics is a hallucination machine](/blog/articles/vibe-analytics-hallucination) [![Your data is hostage to someone else’s API – the case for warehouse-first analytics](https://cdn.owox.com/www/webflow/6a7f2384b865a4eb78a281f2_Your-data-is-hostage-to-someone-else-s-API.png/public) Data Integration Your data is hostage to someone else’s API – the case for warehouse-first analytics](/blog/articles/warehouse-first-analytics-vendor-lock-in) [![Forex & CFD broker data model: a free client-acquisition template](https://cdn.owox.com/www/webflow/6a7f2164730ca89a4d58da98_Forex-CFD-broker-data-model-1.png/public) Data Modeling Forex & CFD broker data model: a free client-acquisition template](/blog/articles/forex-broker-data-model) ## Book a call You are booked. The invitation is on its way to , with the calendar invite and the meeting link. [Reschedule](#) [Cancel](#) ## Schedule a meeting You are booked. The invitation is on its way to , with the calendar invite and the meeting link. [Reschedule](#) [Cancel](#) ## Links Pages this page links to, on this site and on docs.owox.com. Where the page has a Markdown twin, its address follows the link. - [NewAI Insights — your data, analyzed on a schedule→](https://www.owox.com/features/ai-insights) — /features/ai-insights.md - [dashboards](https://www.owox.com/product/dashboards) — /product/dashboards.md - [Get started free →](https://owox.com/app-signup) - [See all articles →](https://www.owox.com/blog/articles) — /blog/articles.md - [Analytics Tools Data mart vs dashboard vs chatbots: which analytics architecture actually wins?](https://www.owox.com/blog/articles/data-mart-vs-dashboard-analytics-architecture) — /blog/articles/data-mart-vs-dashboard-analytics-architecture.md - [AI Vibe analytics is a hallucination machine](https://www.owox.com/blog/articles/vibe-analytics-hallucination) — /blog/articles/vibe-analytics-hallucination.md - [Data Integration Your data is hostage to someone else’s API – the case for warehouse-first analytics](https://www.owox.com/blog/articles/warehouse-first-analytics-vendor-lock-in) — /blog/articles/warehouse-first-analytics-vendor-lock-in.md - [Data Modeling Forex & CFD broker data model: a free client-acquisition template](https://www.owox.com/blog/articles/forex-broker-data-model) — /blog/articles/forex-broker-data-model.md