BigQuery cant import the data from DataPrep

1
votes

I have the table created in BigQuery with partitioned by date and it has the Date type. DataPrep also has the same column with same data type. When i try to load the data from dataprep to bigquery table i am getting the error like "The column datatypes in the dataset must match the destination column datatypes". Screenshot also been attached, please go through it and give me a solution.enter image description here

2
google-bigquerygoogle-cloud-dataprep
I'm having the same problem, but I don't see the "Show columns that don't match" link appearing for me, I just get the error message. Does anyone know why this is? – jlewkovich

2 Answers

0
votes

As the screenshot says, one is a TIME, DATETIME, or TIMESTAMP
the other is STRING as noted by the icons in front of your columns.

You need to make sure at dataset that you've chosen the right data type. Dataprep may infer wrong automatically sometimes your data type.

0
votes

In this this thread it is mentioned that you need to convert both types to TIMESTAMP in order to make this work. In my case this did the trick, but it is kind of cumbersome. Hopefully they will support this for simple DATE columns soon.