Q: Pandas DataFrame to BigQuery date format Issue I am trying to write a Pandas DataFrame to BigQuery on Cloud Functions using bq.load_table_from_dataframe. One of the columns, df['date'], is formatted as datetime64[ns] . The table schema for date is DATETIME. When I tried to run the script it gives an error
pyarrow.lib.ArrowNotImplementedError: Unsupported cast from double to timestamp using function cast_timestamp

I tried changing the BigQuery schema to DATE instead but it raises this error
pyarrow.lib.ArrowNotImplementedError: Unsupported cast from double to date32 using function cast_date32

Is there a way to still write the DataFrame to BigQuery while still maintaining the DATE or DATETIME schema?
