first question is
in the query builder is it possible to select a sql view just as as you would with a sql table?
we are trying this because, we are having some issues with Grafana saying “db has no time column: no time column found”
it does have a std sql timestamp column so we are unsure as to why we get this error?
hence the idea was to create a sql view with unixtime equivalent - which we cant see in query builder,
I can write the sql code that returns the data with unixtime in table mode - but still this errors with no time column