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)."

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.


    • Related Articles

    • 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 ...

    • 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 ...

    • 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 ...

    • Error Message: Required. Specify client identifier

      Action: I have an SSIS package with a valid and tested rest connection and a REST source that uses the REST connection that can successfully preview the data being selected.  However, when I attempt to run the package, the REST source fails ...