I am scheduling a DataPrep job for aggregation purposes. The job just consolidates the raw data from Bigquery and put it back into another bigquery table. There is a timestamp column (which is used as the partitioning key for table partitioning) in the recipe, but the following error comes while trying to run the job.
Note that columns that aren't Integer, Float, or Boolean will get converted to String.
I cannot update the datatype in bigquery because this column is used as the partitioning key(which should be either in date/timestamp format). How could I fix this issue?