QUERY_BIGQUERY

Use SQL to query your BigQuery tables.

icon of BigQueryBigQuery
Not a big fan of functions?
Use the Actions Wizard to configure any action in Rows without functions.

Parameter List

Syntax
QUERY_BIGQUERY(projectquery)
project

The name of the BigQuery project. For example: "acme-prod".

query

The SQL query to apply. For example: "select * from analytics.monthly-sales".

Examples

QUERY_BIGQUERY("acme-prod", "SELECT name, email, phone FROM `analytics.users`") returns a list with name, email, and phone from the table users in the dataset analytics