I am trying to upload a Dataframe to a BigQuery Table using client.load_table_from_dataframe. And I am also supplying a schema using the
job_config = bigquery.LoadJobConfig(
schema=[xxxxxx,xxxxxx,xxxxxx])
All of this have worked untill I had to move the code to a new Virtual Machine and install all the packages again. I have been googeling this a bit and it seems like more people have had problems with Parquet and BQ where they have solved it by installing packages again. This does not seem to work for me.
And I also dont understand why the error says that the Date is a INT64. In pandas it is a Datetime[n64] type. And in the BQ table and schema it is a DATE type. Is there anyone who have had similar problems with this?