Complex queries with drilldown

#1

Hello

I am looking into the Drill Down and Drill Through functions in metabase. However, I only seem to be able to make Drill Down and Drill Through if I make simple queries through the custom builder. If I ought to make a query through the native builder I don’t seem to be able to make Drill Down and Drill Through. Is that true or am I missing something?

#2

Hi @keanottesen
Yes, because Metabase (0.32.8) doesn’t understand a Native Query, it would be very difficult to make drill-through.
But you could create database views instead, which would show as a database table in Metabase with drill-through actions available.

#3

But what if I want to create rather more complex questions in which i have mulitple joins and where clauses?

#4

I’m using multiple fact and dim tables in my dwh and in my query

#5

Without knowing which database you’re using, you should be able to do everything with a database View.
The entire Custom Builder is getting a big overhaul in version 0.33, allowing much more complex queries, which should limit the need of Native Query in many cases.

1 Like