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

Extract DATE from TIMESTAMP field #333

Closed pdewas closed 2 years ago

pdewas commented 3 years ago

Bug Report

EXTRACT(DATE ...) doesn't work and work in BigQuery. https://cloud.google.com/bigquery/docs/reference/standard-sql/timestamp_functions#extract

Expected Behavior

Convert to DATE (YYYY-MM-DD)

Actual Behavior

Error : "Invalid date"

Steps to Reproduce the Problem

SELECT
  EXTRACT(DAY FROM creation_time AT TIME ZONE "UTC") AS the_day_utc,
  EXTRACT(DATE FROM creation_time AT TIME ZONE "UTC") AS the_day_utc2,
  creation_time
FROM
  `region-EU`.INFORMATION_SCHEMA.JOBS_BY_FOLDER

Specifications

ofir5300 commented 2 years ago

Please update to v2.0.3 (Available on Grafana cloud) and let me know if it persist

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.