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

[jeremey_donovan]

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?

[Maddie]

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,