Hi all,
I am working with Grafana v7.5. I have a MySQL Datasource and I want Grafana to only request the data that are in a certain time window which is selected by the Time Filter available on every Dashboard.
This means when I want to look at the last 6 months, the query should request exactly the last 6 months of the from the MySQL Data Source.
I am using the BigQuery Plugin which is connected to the Google Cloud. My data are analytics events generated by firebase.
I tried to use the internal Grafana Variables like this in the where clause which lead to the errors below :
$__timeFilter(event_timestamp) [1]
[1]: No matching signature for Operator BETWEEN for argument types INT64, TIMESTAMP, TIMESTAMP. Supported Signature: (ANY) BETWEEN (ANY) AND (ANY)
event_timestamp > $__timeFrom() AND event_timestamp < $__timeTo() [2] i
[2]: Invalid Query: Syntax Error: Illegal inout character “$”
Especially the Error in [2] is really confusing to me because it is not appearing for the approach [1].
Could you please share your thoughts on that issue if you have any?
Really looking forward to your help, thanks in advance 