Insert
Insert to BigQuery table.
Task version: 1.0.0
Required Frends version: 5.5+
Required .NET version: 6.0
Compatible Agents: Crossplatform
Task Parameters
BaseUri : String
Service base URI.
If empty, the default base URI for the service is used.
Default: -
Example: https://bigquery.googleapis.com
ProjectId : String
Project ID.
Default: -
Example: global-env-397309
DatasetId : String
Dataset ID.
Default: -
Example: bigquery-public-data.baseball
TableId : String
Table ID.
Default: -
Example: bigquery-public-data.baseball.games_post_wide
ReadJsonMethod : ReadJsonMethods
Method to read Service account JSON.
Possible values:
JSON: Method to read Service account JSON.File: Method to read Service account JSON.
Default: 1
Example: ReadJsonMethods.File
🗝SecretJson : String
Service account key file.
Default: -
Example: { "type": "service_account", "project_id": "global-env-397309", ... }
CredentialsFilePath : String
Filepath to service account key file.
Default: -
Example: C:\temp\jsonfile.json
SourceFormat : SourceFormats
Source format.
Possible values:
CSV: Source format.JSON: Source format.RowData: Source format.
Default: 0
Example: SourceFormats.CSV
Csv : String
CSV.
Default: -
Example: Col1;Col2;Col3 Foo Csv;1;Fooland Bar Csv;2;Barland
Delimiter : String
CSV delimiter.
Default: -
Example: ;
SkipTopRows : Int32
Number of top rows to skip.
Default: 0
Example: 0
RowData : RowData[]
Row data.
Default: -
Example: [ [{ Column1, Value1 }, { Column2, Value1 }], [{ Column1, Value2 }, { Column2, Value2 }] ]
Json : String
JSON.
Default: -
Example: [ {"Name": "Foo", "Age": 1, "Country": "Fooland"}, {"Name": "Bar", "Age": 2, "Country": "Barland"} ]"
ThrowOnError : Boolean
Throw an error on exception.
If set to false, exception message can be found in Result.ErrorMessage.
Default: True
Example: true
Task Result
Success : Boolean
Operation complete without errors.
Example: true
ErrorMessage : String
Error message.
Example: Error occured...
Task Changelog
Changelog for Task Frends.GoogleBigQuery.Insert.
[1.0.0] - 2023-09-08
Added
Initial implementation
Last updated
Was this helpful?