Any way to list all models/views that reference a connection? We have many projects and manually opening/searching each one would be a drag.
Already have an account? Login
Login to the community
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
I think there are a couple of ways you can do this.
Admin users have access to i__looker which can be used query data on your instance. Replacing your instance URL in this link will show a count of queries run on each model, pivoted by connection. Adding a filter on the connection field would allow you to search for a particular connection.
The caveat here is that the History explore in i__looker shows query data that is limited to either 90 days back, or 100,000 rows, whichever is first so if users haven’t been querying a model, it will not return in these results.
Other than that, since the ‘Find and Replace’ option within Looker searches one project at a time, the solution would be to search the git repository for occurrences of
Thanks, the i__looker query was perfect!