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
1
votes
2 Answers
0
votes
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.