Run a Google BigQuery query
by @pixiebrix
Run a Google BigQuery query and return the results
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. | |||
Related tags
@pixiebrix/google/bigquery-query
Version
1.7.16
Created
Aug. 17, 2021
Updated
May 25, 2022