I encountered the same issue working on a Google Cloud Function to read from a BigQuery table.
I found this from google.cloud import bigquery ModuleNotFoundError: No module named ‘db_dtypes’ and they referenced using google-cloud-bigquery[all] instead of google-cloud-bigquery. I updated my requirements.txt file to use google-cloud-bigquery[all], and the error disappeared.