Search all Scenarios, Apps & Modules for Text

:bullseye: What is your goal?

Search all Scenarios/Apps whose configurations contain a text value

:thinking: What is the problem & what have you tried?

Trying to perform some cleanup in my DB (Bigquery) and I need to identify any scenario that references a specific view or table that I wish to retire. I would like to make sure the view/table is not being referenced or used prior to deleting it.

Anyone know of an easier way to accomplish this other than manually searching one scenario at a time? I have a good number of scenarios (~70).

2 Likes

There’s no built-in global search for scenario configs unfortunately.
What I’ve done before is export the scenarios as blueprints (JSON) and just search the text locally, way faster than opening them one by one.
Otherwise it’s manual, Make doesn’t expose config search in the UI yet.

3 Likes

Thanks, Charles. JSON export is a perfect solution. Cheers!

2 Likes

Hello,

If you are using the BigQuery app for your operations, you can also go to your connections:

And get a list of all scenarios using this particular app.

With this approach, filtering using JSONs will be much simpler as you will be limited only to scenarios using this connection.

1 Like