Messages and limitations of the Google BigQuery connector
Message code list of BIGQUERY category
The following message codes correspond to errors that occur in Google BigQuery Connector.
This message code is output when an undefined error occurs.
|
Cause |
Solution |
|---|---|
|
An undefined error occurred. |
Check the error message or the help of the operation in which the error has occurred. |
Corresponding error
-
None
This message code is output when a service account authentication key is incorrect.
|
Cause |
Solution |
|---|---|
|
Service account authentication key of the connection resource is incorrect. |
Check the connection resource settings. |
Corresponding error
-
InvalidCredentialException
This message code is output when the operation for Google BigQuery has failed.
|
Cause |
Solution |
|---|---|
|
Failed to execute the job. |
Identify the cause of the error by referring to the error logs, and resolve the problem. |
|
Failed in the operation for Google BigQuery. |
Identify the cause of the error from the status code and error code by referring to the error message list page of Google BigQuery (https://cloud.google.com/bigquery/docs/error-messages) and resolve the problem. |
Corresponding error
-
BigQueryServiceException
This message code is output when the operation for Google Cloud Storage has failed.
|
Cause |
Solution |
|---|---|
|
Failed in the operation for Google Cloud Storage. |
Identify the cause of the error from the status code and error code by referring to the error message list page of Google Cloud Storage (https://cloud.google.com/storage/docs/json_api/v1/status-codes) and resolve the problem. |
Corresponding error
-
CloudStorageServiceException
This message code is output when the operation for Google Resource Manager has failed.
|
Cause |
Solution |
|---|---|
|
Failed in the operation for Google Resource Manager. |
Identify the cause of the error from the status code and error code by referring to the error message list page of Google Resource Manager (https://cloud.google.com/resource-manager/docs/core_errors) and resolve the problem. |
Corresponding error
-
ResourceManagerServiceException
This message code is output when the file already exists.
|
Cause |
Solution |
|---|---|
|
The file already exists. |
Modify the setting value for the operation or check the status of Google Cloud Storage. |
Corresponding error
-
FileAlreadyExistsException
This message code is output when the Execute Select SQL operation has timed out.
|
Cause |
Solution |
|---|---|
|
The job timed out because 3,600 seconds have elapsed. |
Modify your SQL statement. |
Corresponding error
-
JobTimeoutException
Exception messages of BIGQUERY category
|
Exception name |
Cause |
Solution |
|---|---|---|
|
BigQueryServiceException Failed in the operation for Google BigQuery. |
Failed in the operation for Google BigQuery. |
Identify the cause of the error from the status code and error code by referring to the error message list page of Google BigQuery (https://cloud.google.com/bigquery/docs/error-messages) and resolve the problem. |
|
BigQueryServiceException Failed to execute the job. |
Failed to execute the job. |
Identify the cause of the error by referring to the error logs, and resolve the problem. |
|
CloudStorageServiceException |
Failed in the operation for Google Cloud Storage. |
Identify the cause of the error from the status code and error code by referring to the status code and error code list page of Google Cloud Storage (https://cloud.google.com/storage/docs/json_api/v1/status-codes) and resolve the problem. |
|
FileAlreadyExistsException |
The file already exists. |
Modify the setting value for the operation or check the status of Google Cloud Storage. |
|
InvalidCredentialException A service account authentication key is incorrect. |
<Service account authentication key> of <Destination> is incorrect. |
Check <Service account authentication key> of <Destination>. |
|
InvalidCredentialException A service account authentication key is incorrect. |
Service account authentication key is incorrect. |
Check Service account authentication key. |
|
InvalidPropertyConfigurationException <Property name> is not specified. |
<Property name> isn't specified. |
Specify <property name>. |
|
ResourceManagerServiceException |
Failed in the operation for Google Resource Manager. |
Identify the cause of the error from the status code and error code by referring to the error message list page of Google Resource Manager (https://cloud.google.com/resource-manager/docs/core_errors) and resolve the problem. |
|
ResourceNotFoundException Resource definition could not be found. Name: [] |
Destination isn't specified. |
Specify Destination. |
|
ResourceNotFoundException Resource definition could not be found. Name: [<connection resource name>] |
The resource definition selected in Destination isn't found. |
Check the connection resource specified in Destination. |
Limitations of BIGQUERY category
This connector supports the following types.
|
Type name |
Support |
Support when Output query results to data flow is enabled |
Remarks |
|---|---|---|---|
|
STRING |
Yes |
Yes |
|
|
BYTES |
Yes |
Yes |
Output in the Base64 string. |
|
INTEGER |
Yes |
Yes |
|
|
FLOAT |
Yes |
Yes |
|
|
NUMERIC |
Yes |
Yes |
|
|
BIGNUMERIC |
Yes |
Yes |
|
|
BOOLEAN |
Yes |
Yes |
|
|
TIMESTAMP |
Yes |
Yes |
Output in the UNIX timestamp format. The format shows the number of seconds instead of the date and time (YYYY/MM/DD). |
|
DATE |
Yes |
Yes |
|
|
TIME |
Yes |
Yes |
|
|
DATETIME |
Yes |
Yes |
|
|
RECORD |
Yes |
No |
|
|
GEOGRAPHY |
Yes |
No |
|
|
JSON |
Yes |
No |
|
|
RANGE |
Yes |
No |
|
-
Yes: Supported.
-
No: Not supported.
-
If you use deprecated characters in a bucket name, folder path, or file/folder name on Google Cloud Storage, the operation isn't guaranteed.
- "Google Cloud Storage: Bucket naming guidelines" - (https://cloud.google.com/storage/docs/naming-buckets)
- "Google Cloud Storage: Object naming guidelines" - (https://cloud.google.com/storage/docs/naming-objects)
-
You can't specify a comma (,) in a folder path or file name.
-
When you attempt to stop a script running in Designer, it may not be possible to stop the running script.
-
When you attempt to stop a script process forcibly from Task Manager, it may not be possible to interrupt the running process on Google BigQuery.
Table limitations on loading/extracting table data
-
A table that includes a RECORD type field can't be specified.
-
A table that includes a REPEATED mode field can't be specified.