Is it possible to use the API to get the sql query for a look or explore

Looker Tips & Resources Technical Tips & Tricks
1

Knowledge Drop

Last tested: May 21, 2019

Yes! You can get the query ID and then use run_query with result_format=sql https://docs.looker.com/reference/api-and-integration/api-reference/v3.1/query#run_query

2

@Peggy_Beard , how do we get the query_id of an explore or a quick start?