how can I grant the correct permission so that I can run queries with Python sdk on BigQuery?
googleapiclient.errors.HttpError: <HttpError 403 when requesting https://www.googleapis.com/bigquery/v2/projects/MY_PROJ/queries?alt=json returned "Access Denied: Project db-cm-dev: The user joyce-something1@MY_PROJ.iam.gserviceaccount.com does not have bigquery.jobs.create permission in project MY_PROJ.
On the IAM page of your project, by granting the service account mentioned in the error message the role of bigquery.jobUser or higher, you will be able to create jobs.