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

  • 17 May 2016
  • 1 reply

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

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!