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