Issues when I wnat to fetch data

[dylangargo]

Hi everyone,

I have a problem when I want to extract all the information from some BigQuery tables. These tables have 11 million records, when I extract the information, I get the following error:

ERROR [HY000] [Qlik][BigQuery] (131) Unable to authenticate with Google BigQuery Storage API. Check your account permissions

However, if I limit the information to 20k records, the information can be extracted without problems.
What I can do?

[Chanty4u · Accepted solution]

May be following reasons 

Check the API settings: Verify that the API settings for the BigQuery Storage API are configured correctly. This may include enabling the API, setting up billing information, and configuring API access.

Increase your quota: If you are hitting your API request quota, you may need to request an increase in your quota limit. This can be done through the Google Cloud Console.

Optimize your query: If you are running a complex query, consider optimizing it to reduce the amount of data being processed. This can help to reduce the load on the BigQuery Storage API and improve

[dylangargo]

Thank you, I have already solved my problem. I needed a new role in the service account. 

[sreemand · Accepted solution]

Hi Dylangargo,

Please let me know which role you have added the service account to resolve the issue.

Is it for project level permission or Dataset level permission.

Kindly advise us on the earliest.

Thanks

Srikanth.