Search all SQL queries

Hello, looking for a way to search the text of all SQL queries across collections.

In the app DB, the report_card table contains the question definitions. The dataset_query column contains the SQL query in a JSON object under native → query. That should be enough to write a query to search.

You can add the app DB to Metabase so you can explore Metabase’s app state with Metabase. :slight_smile: Be careful with exposing the app db though, it shows everything including user data, so restrict access to people you trust.