Source from one database, target to different database

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.