Your organization needs to allow a production job to have access to a BigQuery dataset.

When an identity calls a Google Cloud API, BigQuery requires that the identity has the appropriate permissions to use the resource. You can grant permissions by granting roles to a user, a group, or a service account.

Reference link- https://cloud.google.com/bigquery/docs/access-control