ExecuteQuery
Frends Task to execute Google BigQuery query.
Last updated
Was this helpful?
Frends Task to execute Google BigQuery query.
Task version: 1.0.0
Required Frends version: 5.5+
Required .NET version: 6.0
Compatible Agents: Crossplatform
ProjectId : String
Project ID.
Default: -
Example: global-env-397309
DatasetId : String
Dataset ID.
Default: -
Example: baseball
TableId : String
Table ID.
Default: -
Example: 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": "your-project-id", ... }
CredentialsFilePath : String
Filepath to service account key file.
Default: -
Example: C:\temp\jsonfile.json
Query : String
Query.
Default: -
Example: SELECT * FROM table
BigQueryParameter : BigQueryParameters[]
Parameters.
Default: -
Example: parametername
ThrowOnError : Boolean
Throw an error on exception.
If set to false, exception message can be found in Result.ErrorMessage.
Default: True
Example: true
MaxRetryAttempts : Int32
Maximum number of retry attempts before throwing an exception or ending this Task.
Default: -
Example: 1
Delay : Int32
Delay in seconds between retry attempts.
Default: -
Example: 5
Success : Boolean
Operation complete without errors.
Example: true
Data : Object
Result as JToken.
Example: { "integer_field": 1, "string_field": "Sample String", "date_field": "2023-09-20T00:00:00", "float_field": 3.14, "boolean_field": true, "timestamp_field": "2023-09-20T12:34:56Z", "time_field": "12:34:56.7890000", "datetime_field": "2023-09-20T12:34:56.789", "record_field": { "nested_string": "Nested String" }, "array_field": [ "Item 1", "Item 2" ], "name": "John Smith", "age": 30 }
ErrorMessage : String
Error message.
Example: Error occured...
Changelog for Task Frends.GoogleBigQuery.ExecuteQuery.
Initial implementation
Last updated
Was this helpful?
Was this helpful?