Find for each explore the tables it use

Looker Q&A Looker
1

I’m looking for a place where I can find for each explore or dashboard what views and DB tables (BigQuery in my case) it uses.

I don’t want to do it manually.

Thanks

2

Hey - would parsing SQL text from Looker System Activity work for you?

3

Yes I think it can be a good solution.

Can you explain please where I can take it from?

4

@meitargold it depends how far you want to automate it.

There are solutions in my mind from easiest to the most complicated:

  1. look on Admin - Queries page when explore/dashboard queries are executed and catch view from SQL tab manually
  2. use System Activity SQL TEXT explore (https://instance_name/explore/system__activity/sql_text) → SQL TEXT field and parse it using Looker table calculations (catch view name after keyword “FROM” and/or joined views from appropriate keywords depends on type of joins)
  3. store Looker System Activity data(query IDs and SQL texts) into separate database and parse it using SQL.

Hope it would help