Frends.GoogleBigQuery.Insert / 2.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
Input parameters.
| Name | Type | Default | Example | Description |
|---|---|---|---|---|
| SourceFormat | SourceFormats |
CSV |
SourceFormats.CSV |
Source format. Possible values:
|
| Csv | String |
– |
Col1;Col2;Col3
Foo Csv;1;Fooland
Bar Csv;2;Barland
|
CSV. |
| Delimiter | String |
– | ; |
CSV delimiter. |
| SkipTopRows | Int32 |
0 |
0 |
Number of top rows to skip. |
| RowData | RowData[] |
– | [ [{ Column1, Value1 }, { Column2, Value1 }], [{ Column1, Value2 }, { Column2, Value2 }] ] |
Row data. |
| Json | String |
– | [ {"Name": "Foo", "Age": 1, "Country": "Fooland"}, {"Name": "Bar", "Age": 2, "Country": "Barland"} ]" |
JSON. |