I am trying to use a big query source from a different project and schema and want to target to a different project schema.
I am getting Access denied error. Please advise on what could be wrong. I am authenticated with gcloud cli.
I am trying to use a big query source from a different project and schema and want to target to a different project schema.
I am getting Access denied error. Please advise on what could be wrong. I am authenticated with gcloud cli.
Hi @RajV
Do your service/personal account have required permissions in both projects?
You need Data Editor permission to create tables in the GCP BIgQuery project.