Question

API: "Create Query" vs "Create SQL Runner Query"

  • 20 February 2021
  • 1 reply
  • 168 views

In the API, what is the difference between “Create Query” and “Create SQL Runner Query”?

 

I’m guessing that “Create Query” creates a persistent query that can be used in the future whereas “Create SQL Runner Query” is just a one-time query. Is that corrrect?


This topic has been closed for comments

1 reply

Userlevel 3

Hi Jeremey,

 

I think both types of queries can be used multiple times.

 

The difference between them is that one would be querying as if you were doing it from an explore (i.e. create_query), so you can take advantage of dimensions and measures and other logic added to your LookML;

 

Whereas the other one would be as if you used the SQL runner (i.e. create_sql_runner_query).

 

Hope this helps!

 

Best,