Unleashing the full power of data insights using Hyperquery

First published on January 31, 2023


8 minute read

Thomas Chung



We setup Hyperquery at Mage to organize and streamline our growth data for better insights. In this blog, we go over our experience of quickly adopting the tool and easily sharing our analysis with our peers.


  • The problem

  • Insert Hyperquery

  • Setup & integration

  • Our experience

    • What stood out

    • Improvements

  • Conclusion

The problem

With the accelerated growth of Mage in the past year, we were in a predicament where we had a lot of user data piling up from a bunch of different sources. A great problem to have, I know, but we would find ourselves spending hours each week manually pulling data and trying to keep it all organized to stay on top of our growth efforts.

Source: Giphy

Because we were pulling data from a variety of sources, we found a huge number of tabular inconsistencies and duplicate information. Each platform has its own unique limitations and customization that made creating consistency a challenge. We needed a better way to organize and seamlessly present our growth analyses in order to:

  1. Ensure data consistency.

  2. Provide an easy and flexible way to integrate and pull multiple data sources into a single place.

  3. Be able to easily collaborate, share, and communicate our insights with our internal shareholders.

Insert Hyperquery


is a highly collaborative analytics notebook built to increase internal engagement and visibility, providing a simple yet intuitive UX/UI similar to


. They can integrate with numbers of different data sources and have industry-leading data security and compliance (


). There are several tiers for


, but you can get started with their Studio option for free which includes 3 creators, unlimited collaborators + viewers, 5 pages, shared python resources, default compute: XS, and 1 warehouse connection.

Setup & integration

Getting started with Hyperquery was easy. We signed up using the quick SSO option and were ready to create our first integration in seconds.

We were able to integrate our data sources simply by going to the “Warehouses section” on the bottom left of the left sidebar and following the “+ Add warehouse” prompt.

We used Postgres to connect to a few of our data sources:

  • Google Analytics

  • Amplitude

  • Google Sheets

Note: this was just the initial reports we pulled in for a basic workspace. You can see the full list of supported databases



After connecting, you can view your DW sources by expanding the right sidebar in the “Warehouses” page.

We used Mage’s

data integration

capabilities to regularly sync

Google Sheets


Google Analytics


Google Search Console

, and


to our analytics database in



The tables created in our analytics database is then connected to Hyperquery for easy and fast hyperquerying.

Our experience

The following are features we discovered and fell in love with:

  • Apart from integrations (for non-technical folks like me), it was easy to onboard and begin using the tool with fairly little instructions (though they do provide


    and docs).

  • The ability to connect, build, and communicate all on one centralized interface.

  • The 






    and basic formatting with markdown.

  • Work your data magic by seamlessly adding SQL block right directly into the workspace.

  • Create powerful visualizations to tell your data story and query by selecting specific chart options.

  • Very similar to notion UI/UX.

  • Easy to organize and nest notebook hierarchically - like notion (drag and drop function on left sidebar).

  • Helps organize.

  • Easy for archiving and saving work.

  • Audience (or collaborator) views, execution, and reactions (emojis).

    • With features like

      page comments,

      text comments

      , and

      mentions with @

      , Hyperquery makes it easy to communicate and collaborate with your teammates.

  • How easy it is to share your work and analysis to your colleagues in your organization. Simply hit the ‘Invite members’ button on the bottom left side panel and send an email with a selected profile option. At the very least, they will be able to see the workspace or set them up to start contributing directly to analysis!

  • Toggle query blocks to show or hide for final report/presentation. Not everyone in your organization may be technical, so the ability to hide SQL blocks to avoid confusion and distraction is definitely a nice touch!

  • Share settings to edit, view, or app mode.

    • Team access

    • Copy link

    • Copy embed link

  • Note: I have not tried Jinja (optional) for the more advanced users for dynamic functions, so I can’t really speak into that but here is

    the docs

    page explaining more about it.

There were only a few things we noticed that we hope to see improved in future updates:

  • An easier way to move and reorder blocks within a page (drag and drop)

  • Currently no feature to undo saved actions and changes within a chart

  • Certain chart options and features aren’t so obvious to apply but was able to figure from their

    Visualizations docs page



Hyperquery is a powerful interactive tool that allows you to stray away from your conventional dashboards and have the flexibility to integrate, build, and customize your reports for easier feedback loop amongst your stakeholders in your organization. We were able to sign-up, setup, and start creating our workspace all within a single business day span. We have already seen a difference Obviously our goals and needs may differ from others, but we just wanted to share a painless and magical way of telling the story of your data.

Source: Giphy

Ready to try it for yourself? Here’s a


to get started.