Kickstart your data journey with Looker SQL Runner! 🚀✨

Getting Started with Looker SQL Runner

To get started with Looker SQL Runner, you will need to have a Looker account and a connection to your Looker data. Once you have these, you can follow these steps to install and start using Looker SQL Runner:

1. Enter a SQL query in the text box below the Query bar.

2. Optionally, select a table name or field from the field list to include it in your query at the cursor location.

3. Select Run to run the query against your database.

4. 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.

Adding a SQL Runner query to a LookML project

Follow these steps to use the Add to Project option:

1. Use SQL Runner to create a SQL query that you want to use for a derived table.

2. Click Add to Project from the gear menu in the upper right.

3. Select the project you want to add this derived table to.

4. Enter a view name for the derived table.

5. Click Add to add the query as a derived table in your project. Looker will switch to Development Mode if not already in it, create a new view file with the LookML from the SQL Runner query, and then open the IDE file browser to the new view file.

6. Move the file to suit your project’s file organization.

7. Validate the LookML and deploy your changes to production.

Create a derived table from a SQL Runner query

1. Use SQL Runner to create a SQL query that you want to use for a derived table.

2. Click the gear menu and select Get Derived Table LookML.

3. From the Get Derived Table LookML pop-up, click the add it to your project link.
   Note: It’s easier to use the add it to your project link, but you also have the option to copy the LookML, manually create a view file in your project, and paste the LookML to your new view file.

4. Use the drop-down Project list to choose the project you would like to add the derived table to.

5. Enter a name for the new view in the View Name field. See the Managing LookML files and folders page for file naming conventions.

6. Click the Add button. Looker will switch to Development Mode if not already in it, create a new view file with the LookML from the SQL Runner query, and then open the IDE file browser to the new view file.

7. Move the file to suit your project’s file organization.

8. Validate the LookML and deploy your changes to production.

Debugging using SQL Runner

SQL Runner highlights the location of errors in the SQL command and includes the position of the error in the error message.

Please refer to below resources for more details:

• Using SQL Runner to create queries and Explores

• SQL Runner basics

• Using SQL Runner to create derived tables

• Managing database functions with SQL Runner