Connect a fully managed service for querying S3 data to Metabase for analytics
Get started with MetabaseBuilt and managed by Metabase, available in all editions
Unlimited technical help available on paid plans
Metabase lets your whole team visualize and explore your data in Athena with or without SQL. Run native queries and analyze structured and unstructured data in your data lake via Athena.
Get a BI tool with friendly UX that lets everyone make sense of your data in Athena.
Keep everyone in their own lane.
With as much interactivity and room to pull threads (or as little) as you want.
Metabase runs queries directly in Athena, so your reports are always up-to-date.
Using Metabase with Athena opens up even more options for your data stack. You can also connect to DocumentDB, Kafka, Teradata Vantage, OpenSearch, SAP Hana, and Azure Cosmos DB.
Athena pairs with a number of BI tools - including Amazon’s own Quicksight. While this gives you a good way to keep everything in the Amazon ecosystem, Metabase is the most effective way to let everyone in the team start working with data. Because of sophisticated but easy-to-use data tools like the query builder, which lets people ask questions without SQL, Metabase has a low learning curve. Simple drill-through, zoom-in, and breakout functionality lets people learn more from data with just a few clicks.
You can set up and connect Metabase to Athena in about 5 minutes and begin querying immediately, with drill-through functionality automatically generated and ready for people to start uncovering insights. Metabase is also open source and affordable, with plans and pricing that scales with you.
You can connect to Athena when you’re setting up a new Metabase instance, or add a database connection any time in your admin settings:
To add a database connection, click on the gear icon in the top right, and navigate to Admin settings > Databases > Add a database.
For the full details on connecting Metabase to Athena, check out our documentation.
Athena permissions can't be impersonated in Metabase for now. (This is currently possible for PostgreSQL, Redshift, Snowflake, and ClickHouse databases).
With granular row-level permissions and user group mapping, you can effectively set up permissions to match those applied in Athena.
Metabase fits with Athena as a querying and visualization layer on top of your data. With Metabase you can query data in Athena - with or without SQL - to create a broad range of data visualizations and types and tell a story with interactive dashboards. Viewers can filter and drill-through to get what’s most relevant, and dig deeper on what’s important to them. Visualizations and dashboards can even be shared or embedded in your app.
Athena helps you analyze unstructured, semi-structured, and structured data stored in Amazon S3 - but you’ll likely need pretty advanced data and technical skills to be able to do it.
Metabase makes it possible for everyone in the team to run their own reports, without data skills or relying on someone else to write SQL for them. People used to working in Excel can leverage skills usually reserved for spreadsheets to get the answers they need from data in Athena.
Metabase lets you bring together charts, visualizations, and questions into interactive dashboards that can be shared with your team and customers.
The automatically generated drill-through menu lets people click on charts to zero in on a particular category or parameter for further analysis; view individual records, or zoom in on a targeted date range. You can also add filters to let people slice the data on what’s most important to them, and add custom-click behaviors to guide data discovery (e.g. send people to a related dashboard).
