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

wildcard tablename not recognized #324

Closed iam-meghana closed 2 years ago

iam-meghana commented 3 years ago

Question

I have a table that is sharded by datestamp (eg: tablename20201012, tablename20201013, etc) when it is queried as

SELECT count(claim_id) FROM "project-id.dataset.tablename*" WHERE _TABLE_SUFFIX BETWEEN '20210326' AND '20210330'

I get an error saying invalid table . Am I messing up the syntax or doing something wrong here?

Specifications

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.