I faced a similar issue earlier. With the recent release, BigQuery DATETIME support has improved in the newer versions of the BigQuery Connector. Upgrading to BigQuery Connector 0.34.0 resolved the issue for me.

For more details, you can refer to the Dataproc release documentation here: https://cloud.google.com/dataproc/docs/concepts/versioning/dataproc-release-2.2