Question

How to use existing SQL code and make the result accessible by using explore

  • 17 May 2016
  • 1 reply
  • 1618 views

Hi, I find that I can get the existing SQL running in the SQL runner,



but I can’t add it to the explore, It shows error like


ERROR: column sql_runner_query.service does not exist Position: 1278



I also find that I can add it to the view, it will shows as a derived table. My question is how can I or other people access this table in the Explore or use it to create a dashboard.



Thank you!




1 reply

Userlevel 3
Badge

Hi Luke!



Could you elaborate on what you mean by ‘adding it to the explore’?



When running a query in SQL Runner, you can use the “Add to Project” button to generate a derived table. You can create an explore for this derived table just like you would for any other view- by using the -explore: parameter. Our derived table documentation is very helpful as well.



Let me know if this helps!

Reply