Frends.GoogleBigQuery.ExecuteQuery / 1.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
Connection parameters.
| Name | Type | Default | Example | Description |
|---|---|---|---|---|
| ProjectId | String |
– | global-env-397309 |
Project ID. |
| DatasetId | String |
– | baseball |
Dataset ID. |
| TableId | String |
– | games_post_wide |
Table ID. |
| ReadJsonMethod | ReadJsonMethods |
File |
ReadJsonMethods.File |
Method to read Service account JSON. Possible values:
|
| SecretJsonSecret | String |
– |
{
"type": "service_account",
"project_id": "your-project-id",
...
}
|
Service account key file. |
| CredentialsFilePath | String |
– | C:\temp\jsonfile.json |
Filepath to service account key file. |