i want to query external tables via bigquery, but I am getting 403 denied on python.
google.api_core.exceptions.Forbidden: 403 Access Denied: Table xx.ResultView: User does not have permission to query table xx-prod:xx.ResultView, or perhaps it does not exist in location EU.
python:
import os, django
from pathlib import Path
BASE_DIR = Path(__file__).resolve(strict=True).parent.parent
os.environ.setdefault('DJANGO_SETTINGS_MODULE', 'mysite.settings')
os.environ.setdefault('GOOGLE_APPLICATION_CREDENTIALS', 'static/prod-337f4bbda.json')
django.setup()
from google.cloud import bigquery
client = bigquery.Client()
sql_query = """
XXXX
"""
query_job = client.query(sql_query)
results = query_job.result()
print(query_job.result())
for row in query_job.result():
print(row)
User permissions;
