Run a Google BigQuery query

Run a Google BigQuery query and return the results

Demos & Screenshots

No screenshots provided yet. Have some video demos or screenshots of this brick in the wild?
Send them over to [email protected]!

How to Use

No instructions provided yet. Have questions?
Ask the PixieBrix Community!

Inputs

Name Required Type Description
multi boolean If set, return an array of results
query string Required. A query string, following the BigQuery query syntax, of the query to execute.
location string The geographic location where the job should run. See details at https://cloud.google.com/bigquery/docs/locations#specifying_your_location.
projectId string Required. Project ID of the project billed for the query
useLegacySql boolean Specifies whether to use BigQuery's legacy SQL dialect for this query. The default value is true. If set to false, the query will use BigQuery's standard SQL
parameterMode string
useQueryCache boolean Optional. Whether to look for the result in the query cache. The query cache is a best-effort cache that will be flushed whenever tables in the query are modified. The default value is true.
defaultDataset object
queryParameters array

Outputs

Name Required Type Description
No outputs for this brick defined.

Details

ID @pixiebrix/google/bigquery-query
Author @pixiebrix
Version 1.4.2
Created Aug. 17, 2021
Updated Sept. 23, 2021

Related Bricks

  • No related bricks