I just started my journey with Canvas and I am confused. If I put together a SQL query in the developer tools section and everything appears to work correctly; then I attempt to use that same query in canvas I get nothing. When I say nothing I mean no error, no output, just nothing. I started by attempting a drop down box so I built a query that returns a list of applications. Again the SQL works in DEV tools, gets nothing in Canvas. I am willing to admit fault here but some guidance would be useful. My query is as follows:
"query": "SELECT kubernetes.labels.app FROM "k8s-prod-myapp-*" GROUP BY kubernetes.labels.app"