SQL Query to Dashboard or Look from Metadata Tables

I am collecting all the sql queries fired through a dashboard or look. I have access to looker backend metadata table, but could not join the tables (sql_query, query,  dashboard...etc..,) to extract all dashboard_ids, look_ids and SQL queries fired. I tried joining based on slug, hash, query_id, sql_query_id but nothing worked. Can someone please help with the joining conditions to get the required details?

0 0 193
0 REPLIES 0