Drill in Metabase

Get Help
1

Good morning everyone,

I would like to know if it is possible to implement drill-through in Metabase based on SQL queries. My idea is to create a table displaying production orders, and when clicking on an order, the associated products should appear.

Is this possible in Metabase?

Thank you!

1 Like
2

Yes. Use dashboard actions.

3

Could you please give me an example?

I'm not able to execute it in my query, I'll be sending an example image, would it be possible to do this?

I recently left Power BI, sorry for any errors.

Thank you!

Exemplo Query
Exemplo Query1596×251 49.1 KB

4

I managed to do it through the actions menu, I failed with the query written directly in SQL, I don't know if it's possible, but I got what I wanted by formulating the question.

5

Dear Alex,

Yes, this is possible in Metabase, but it needs a bit of manual setup but I have highlted a few ways below that could be useful for you.

I believe Number 2 will be the most effective but review the options and parameters on your side first.

Here are some ways you can do it:

1.	Using Custom Destination Links

You can add custom links in your table that direct to another Metabase question. In your SQL query, you can generate a link that, when clicked, opens a question showing the associated products for the selected order.

2.	Using Query Parameters in SQL

In a native SQL query, you can use Metabase variables like {{order_id}} to filter results dynamically. Then, you can create a custom column with a link that passes the order_id as a parameter to another Metabase question.

3.	Metabase’s Built-in Drill-Through (Only for GUI Queries)

If you were using the Metabase query builder instead of raw SQL, there is a built-in drill-through function. But since you are using SQL, you need to set it up manually with links or filters.

Thanks,
Josh

6

Hi "Josh" (or Hemant), first of all, it would be really nice if you wouldn't use 2 different names (IndyBond and JoshCallenway) to answer over the same question in the forum, since that would lead me to imply that you're trying to generate engagement over specific topics or threads and I will have to flag every single comment of yours as spam.

Also, please answer these questions with a direct proposal to users if you're willing to help. A good response would be:

  1. please give us the version that you're running
  2. the logs when you click on the filters
  3. the api response of the browser when you click on these filters
  4. a clear reproduction of the same issue using the sample dataset

thank you