Access Denied error within load csv from Google Bucket to BigQuery

by

I have credentials in json format that allow connect me from Jupyter Notebook to Google Cloud Platform.
I want load data from bucket to big query, but job return error:
{‘reason’: ‘accessDenied’,
‘message’: ‘Access Denied:
File gs://test_bucket_maps/Subscription.txt: Access Denied’}

My configuration for job:

job_config = bigquery.LoadJobConfig()
job_config.autodetect = True
job_config.source_format = bigquery.SourceFormat.CSV
job_config.null_marker="NULL"
job_config.field_delimiter="\t"
job_config.skip_leading_rows = 1
job_config.create_disposition = 'CREATE_IF_NEEDED'

I check that my bucket in non public and i give my credentials role such as “Storage Legacy Object Owner”, but it isn’t working.
Have you advices/tips for my problem??

  • Could you provide more details about your Jupyter Notebook environment (vertex AI workbench, local machine, etc) and the permission you have already granted?

    – 

Leave a Comment