Data Studio
3.2K members online now
3.2K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

support of BigQuery's Standard SQL ?

[ Edited ]
Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I got this error when I connect a bigquery data source that is a view written in standard SQL.

 

There`s a query error.

Cannot reference a SQL view in a Legacy SQL query.

Error ID: 587f8a32

It seems that the connector only support BQ's Legacy SQL style ??

Can there any solution or configuration for it?

I tried a custom legacy query on standard SQL view and failed.

 

1 Expert replyverified_user

support of BigQuery's Standard SQL ?

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

It would be really great to have Standart SQL in DataStudio because it's Standrart.

support of BigQuery's Standard SQL ?

Google Employee
# 3
Google Employee

Hi,

 

For BigQuery, we don't yet support standard SQL. We only support legacy SQL.

support of BigQuery's Standard SQL ?

Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭

Might standard SQL be supported in DataStudio in the future?

support of BigQuery's Standard SQL ?

Visitor ✭ ✭ ✭
# 5
Visitor ✭ ✭ ✭

It would be really helpful to support Standard SQL! I'm missing this feature.

support of BigQuery's Standard SQL ?

Visitor ✭ ✭ ✭
# 6
Visitor ✭ ✭ ✭

We are working on this and are hoping to make this available in the future.

support of BigQuery's Standard SQL ?

Visitor ✭ ✭ ✭
# 7
Visitor ✭ ✭ ✭

Would you be able to give an approximate target date for this feature? I am happy to work with an alpha version

support of BigQuery's Standard SQL ?

Visitor ✭ ✭ ✭
# 8
Visitor ✭ ✭ ✭

I am facing same issue. It would be very nice if standard SQL could be supported soon since it have some good aggregation functions.