Frends.GoogleBigQuery.ExecuteQuery / 2.0.0
Summary
Runs SQL against BigQuery and returns the rows, with parameters passed separately from the statement rather than concatenated into it.
Typical use — reading warehouse data into a Process; parameterising rather than building SQL strings is also what keeps injection out of the query
Input parameters.
| Name | Type | Default | Example | Description |
|---|---|---|---|---|
| Query | String |
– | SELECT * FROM table |
Query. |
| BigQueryParameter | BigQueryParameters[] |
– | parametername |
Parameters. |