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
Are you new to COZYROC and evaluating our solutions?
Book a Presales Call with us now and get 5% off SSIS+.
Book a Presales Call with us now and get 5% off SSIS+.
Related Articles
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) ...Error Message: The process cannot access the file because it is being used by another process
Action: While attempting to generate the token, the following error message is encountered. Error Message: The process cannot access the file because it is being used by another process Solutions: You have to determine which application is keeping ...Error message: Resource not specified
Action: When using the REST Source component with the REST connection configured for ServiceNow, I get the following error: Error Message: Resource not specified Solution: You don't have permission to access the ServiceNow resources. Ask your ...How to manually generate a Google Services Token?
A token-based authentication system allows users to enter their username and password in order to obtain a token, which allows them to fetch a specific resource, without using their username and password. Once their token has been obtained, the user ...Where can I find the documentation for the Google BigQuery Connection?
You can find documentation related to all the COZYROC SSIS+ Component Suite components from the main products page. Specific documentation for the Google BigQuery Connection can be found at the following link. For many of the components you can ...