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.


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