Error Message: "Access Denied: Dataset {projectid}:{dataset}: Permission bigquery.tables.create denied on dataset {projectid}:{dataset} (or it may not exist)."
Action:
When trying to fetch data from Google Big Query view using Query Resource in Rest Source.
Error Message:
''Access Denied: Dataset {projectid}:{dataset}: Permission bigquery.tables.create denied on dataset {projectid}:{dataset} (or it may not exist)."
Solution:
To avoid error message verify if the user has tables.create permission. This is necessary to extract the view columns metadata as the fields metadata is dynamically constructed based on the query specified in Rest Source. In order for Rest Source to be able to construct the fields metadata, it has to materialize by creating a view for that query If you cannot provide the necessary permission, the workaround would be to manually define the view fields in the Advance edit mode of the REST Source component.
Book a Presales Call
Related Articles
Error Message: "Access Denied: Dataset {projectid}:{dataset}: Permission bigquery.tables.create denied on dataset {projectid}:{dataset} (or it may not exist)."
Action: When trying to fetch data from Google Big Query view using Query Resource in Rest Source. Error Message: ''Access Denied: Dataset {projectid}:{dataset}: Permission bigquery.tables.create denied on dataset {projectid}:{dataset} (or it may not ...Error Message: "Access Denied: Dataset {projectid}:{dataset}: Permission bigquery.tables.create denied on dataset {projectid}:{dataset} (or it may not exist)."
Action: When trying to fetch data from Google Big Query view using Query Resource in Rest Source. Error Message: ''Access Denied: Dataset {projectid}:{dataset}: Permission bigquery.tables.create denied on dataset {projectid}:{dataset} (or it may not ...Error Message: "Access Denied: Dataset {projectid}:{dataset}: Permission bigquery.tables.create denied on dataset {projectid}:{dataset} (or it may not exist)."
Action: When trying to fetch data from Google Big Query view using Query Resource in Rest Source. Error Message: ''Access Denied: Dataset {projectid}:{dataset}: Permission bigquery.tables.create denied on dataset {projectid}:{dataset} (or it may not ...Error Message: "Access Denied: Dataset {projectid}:{dataset}: Permission bigquery.tables.create denied on dataset {projectid}:{dataset} (or it may not exist)."
Action: When trying to fetch data from Google Big Query view using Query Resource in Rest Source. Error Message: ''Access Denied: Dataset {projectid}:{dataset}: Permission bigquery.tables.create denied on dataset {projectid}:{dataset} (or it may not ...Error Message: 'Cannot find the requested object' when using Service Account Authentication in Google BigQuery Connection.
Action: When using Service Account authentication in Google BigQuery connection Manager the following error is received. Error Message: Validating connectivity via endpoint '' failed. Details: Cannot find the requested object. (CozyRoc.SSISPlus.2019) ...