DataStudio : BigQuery & Standard SQL

问题:

How to use standard SQL queries on Google Data Studio using a BigQuery Data Source ? Thanks

回答1:

Unfortunately DataStudio only currently supports legacy SQL. The DataStudio team are working on BigQuery Standard SQL support

To query using legacy sql in DataStudio

• Create a new report in DataStudio
• Select BigQuery connector (you will need to authorise access)
• Select Custom Query, which will give you the option of entering Legacy SQL directly

回答2:

Google Data Studio supports #standardSQL now!

Just check the appropriate box when inserting your query.