SQL Runner Query result visualization as a dashboard?

Looker Q&A Looker
1

Can’t I display the SQL Runner Query result visualization as a dashboard?

2

No, you can’t, everything that’s displayed to the end user has to go through LookML modelling layer. SQL Runner bypasses it just for quick checks

3

SQL Runner doesn’t give you a direct way, but there is a long way to do it.

3 steps essentially:

  1. Use SQL Runner to create a derived table: link here (“Add to Project” is the fastest way!)
  2. Now that you have a LookML view file, create an explore from it
  3. Use this explore to create looks!