Frends.GoogleBigQuery.Insert / 1.0.0
Summary
Loads rows into a table from JSON or CSV held in the Process, rather than from a file already in cloud storage.
Typical use — landing a modest batch a Process just assembled, without staging it in a bucket first
Connection parameters.
| Name | Type | Default | Example | Description |
|---|---|---|---|---|
| BaseUri | String |
– | https://bigquery.googleapis.com |
Service base URI. If empty, the default base URI for the service is used. |
| ProjectId | String |
– | global-env-397309 |
Project ID. |
| DatasetId | String |
– | bigquery-public-data.baseball |
Dataset ID. |
| TableId | String |
– | bigquery-public-data.baseball.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": "global-env-397309",
...
}
|
Service account key file. |
| CredentialsFilePath | String |
– | C:\temp\jsonfile.json |
Filepath to service account key file. |