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