I’ve looked in vain for an answer to my issue. I have a db web app that runs fine locally and I have deployed for users to access. It has predefined SQL queries that can be executed with results from BigQuery. It uses pandas_gbq library to process the queries. I have the secrets file saved accordingly and the contents in my app’s secret section. I get the following error message when I try and execute a query:
pandas_gbq.exceptions.GenericGBQException: Reason: 401 POST https://bigquery.googleapis.com/bigquery/v2/projects/s4a-prod/jobs?prettyPrint=false: Request had invalid authentication credentials. Expected OAuth 2 access token, login cookie or other valid authentication credential. See Integrating Google Sign-In into your web app | Google Sign-In for Websites | Google Developers.
I don’t know what I am missing. Any help would be appreciated!