search

doitintl / bigquery-grafana

Google BigQuery Datasource Plugin for Grafana. (NO LONGER MAINTAINED)
https://www.doit-intl.com/labs/
MIT License
242 stars 76 forks source link

add support for firebase events exported to bigquery #360

Closed carocad closed 2 years ago

carocad commented 3 years ago

Feature Request

Is your feature request related to a problem? Please describe. We have a firebase project with BigQuery integration where events from a mobile app are sent to big query. The exported tables are named as events_YYYYMMDD (see example queries). So far none of the time macros create an sql query appropriate for big query format.

Describe the solution you'd like A time macro (or flag on one of the existent one) to create the event suffix as 

$__timeFilter(_TABLE_SUFFIX, 'firebase')
# that should generate something like
# _TABLE_SUFFIX BETWEEN '20210713' AND '20210720'

Describe alternatives you've considered An alternative is to expose the time range from Grafana as a variable (like $__timeRangeStart and $__timeRangeEnd). This way I could use sql functions to format those as strings without using a time macro.

ofir5300 commented 2 years ago

We are retiring the DoiT International BigQuery DataSource plugin for Grafana. We recommend that you migrate to the official Google BigQuery data source maintained by Grafana. In August 2022, we will cease all development and archive the GitHub project.

We are sorry for any inconvenience.