Looker SQL Runner: A Tool for Simplifying Data Queries
Looker SQL Runner is a tool that makes it easy to run SQL queries on Looker. With Looker SQL Runner, you can write and run SQL queries in a familiar interface, and you can see the results of your queries in Looker.
Looker SQL Runner is a great tool for anyone who wants to get more out of their Looker data. With Looker SQL Runner, you can:
Run complex SQL queries on Looker data
See the results of your queries in Looker
Share your visualizations with teams
When you write a query in Looker SQL Runner, you can use the Looker data model to help you. The Looker data model shows you all of the tables and columns in your Looker data, and it also shows you the relationships between the tables.
Once you have written a query, you can run it by clicking the Run button. Looker SQL Runner will then run your query and show you the results in Looker.
Writing a SQL query from scratch
Enter a SQL query in the text box below the Query bar.
Optionally, select a table name or field from the field list to include it in your query at the cursor location.
Select Run to run the query against your database.
View the results in the Results area. SQL Runner will load up to 5,000 rows of the query’s result set. For SQL dialects that support streaming, you can download the results to see the entire result set.
Using an Explore to create a SQL query
From an Explore, select the SQL tab from the Data bar.
The SQL query will appear under the Data bar.
Select Open in SQL Runner or Explain in SQL Runner to open the query in SQL Runner.
Creating visualizations with SQL Runner
After a SQL query is created and run, you can open the Visualization tab to view the visualization and choose a visualization type, just as you would do on the Explore page.
You can edit the visualization using the Settings menu.
You can share visualizations created with SQL Runner by sharing the URL. Any customizations that you make using the visualization’s Settings menu will be saved and the link will not change.
Here are some more details about Looker SQL Runner:
