Troubleshooting SQL through SQL Runner
SQL Runner is a way to debug your SQL-based Looker issues that cannot be verified by LookML and the Content Validator.
SQL Runner in Looker grants direct access to your database or data warehouse connected to Looker, enabling a range of data exploration and management capabilities. With SQL Runner, you can browse schema tables, construct Explores from SQL queries, execute predefined descriptive queries, access SQL Runner history, download query results, share queries, incorporate them into LookML projects as derived tables, and perform various other useful tasks.
Getting ready
In this section, we will mostly use LookML, Explore, and SQL Runner interfaces. You can open Users Explore in one tab and have the LookML project open in another browser tab.
How to do it...
As a debugging tool, SQL Runner can be accessed in two ways and usually for two principal reasons:
- In Explore, if you obtain a result that does not seem correct...
