Adding Metabase to Metabase to query Metabase in Metabase

2020-09-04

There are a lot of obscure, one-off queries I've saved in Metabase to answer different questions about our business. For example, I pretty regularly need to do some percentile-based rankings to estimate the impact of a product feature, and for the life of me can never remember how to construct a percentile query—but I can remember some keywords from past queries.

It turns out you can add the Metabase database to your Metabase settings. Just put in the host and credentials to your database, call it Metabase, and save. Then you can write a query like this (this uses SQL parameters so you can just plug in a new keyword each time):

Which will allow you to query all your saved Metabase questions by keyword:

2020 09 04 til metabase1

Hat tip to bkrausz for the idea.

← all posts

michael schade

I built out engineering and operations teams at Stripe as employee #20 from 2012 to 2019; now I'm working on something new. I like helping people, photography, reading, gym, traveling, and learning new things. Say hi! 🏳️‍🌈