Reputation: 1095
I am getting a constant error while executing a Dataflow job:
BigQuery import job "dataflow_job_838656419" failed., : BigQuery creation of import job for table "TestTable" in dataset "TestDataSet" in project "TestProject" failed., : BigQuery execution failed., : HTTP transport error: Message: Invalid value for: String is not a valid value HTTP Code: 400
It does not give any specific reason for the google Dataflow job failing continuously. How do I know what is the error I am committing while executing the google Dataflow job?
Upvotes: 1
Views: 1203
Reputation: 3214
The issue is the incorrect use of the BigQuery API, which is case-sensitive with respect to field type. Please specify "STRING" as the field type in the schema that you're providing.
Please see https://cloud.google.com/bigquery/docs/reference/rest/v2/tables for more details.
Upvotes: 4