List of questions by source table

Hello,

I was wondering if it’s possible to search questions according to the source table used. For example, I have several questions (that are visualized as graphs) that use the same saved question (native query). Is it possible to search through the UI or API to find a list of these questions that all use the same saved question?

Thanks,
Kris

Hi @krisr
You would have to look in the table report_card.dataset_query in the application database.
There you’ll see something like {"query":{"source-table":"card__13",... which means the question you’re looking at was based on question ID 13.
https://github.com/metabase/metabase/issues/7569 - upvote by clicking :+1: on the first post

1 Like