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

[Peggy_Beard]

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

This content is subject to limited support.                

[scott_digiambat]

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