The error messages will be sent back in a JSON file, and will have the following format:
{
"kind": string,
"insertErrors": [
{
"index": integer,
"errors": [
{
object (ErrorProto)
}
]
}
]
}
The following table describes the possible error messages that you may encounter while using the google_bigquery() destination.
| Error | Description |
|---|---|
{"reason":"invalid","location":"non_existent_field","message":"no such field: <field-name>."}
|
This error indicates that a field does not exist but data was given to it. The field's name in question will be placed where the <field-name> is located in the example. This error can only happen when ignore_unknown_values(False) is set. |
{"message":"Not found: Project <project-name>","domain":"global","reason":"notFound"}
|
This error indicates that the given project <project-name> inside the project() parameter does not exist on Google Cloud. |
{"reason":"invalid","message":"Missing required field: Msg_0_CLOUD_QUERY_TABLE.<field-name>."}
|
This error indicates that a value was either not specified for the <field-name> inside the fields() parameter, or that syslog-ng does not have any values for it. This only happens for fields where the field's mode is 'REQUIRED' inside the schema. |
{"message":"Not found: Dataset <project-name>:<dataset-name>","domain":"global","reason":"notFound"}
|
This error indicates that the <project-name> project exists, but the dataset-name dataset given inside the dataset() parameter does not exist in BigQuery. |
{"message":"Not found: Table <project-name>:<dataset-name>.<table-name>","domain": "global","reason": "notFound"}
|
This error indicates that the <project-name> project and the <dataset-name> dataset exist, but the <table-name> table given inside the table() parameter does not exist inside the <project-name>:<dataset-name> dataset BigQuery. |
{"reason":"invalid","location":"<field-name>","message":"Invalid <type> string <given-value>"}
|
This error indicates that the value of <field-name> inside the fields() parameter is not valid for BigQuery's <type> field type. The error also contains the exact value for the <given-value>. |