Slack Export - #mpdm-dsurwill--ahsan--jturner-1

Public Channels

Private Channels

Direct Messages

Group Direct Messages

Dustin Surwill (dsurwill@shield-legal.com)

2024-11-04 13:37:58

Here is a utils file i made for another project that will convert xml to dict and back

utils.py

Ahsan (ahsan@shield-legal.com)

2025-04-01 18:57:16

image.png

Ahsan (ahsan@shield-legal.com)

2025-04-01 18:57:26

Hey we might need access to the underlining sheet @James Turner

James Turner (jturner@shield-legal.com)

2025-04-01 19:12:03

What account is pulling the query? I believe you both have access to the actual Excel sheet

Dustin Surwill (dsurwill@shield-legal.com)

2025-04-02 10:42:35

Should be his account. We are trying to query the BQ table that is in the top right of the image

James Turner (jturner@shield-legal.com)

2025-04-02 11:19:04

Go ahead and try it now

James Turner (jturner@shield-legal.com)

2025-04-02 11:19:10

Let me know if anything changes

Ahsan (ahsan@shield-legal.com)

2025-04-02 15:29:41

@James Turner tried running it again. Still didnt work, Got another 403 error. Get this specific error

"google.api_core.exceptions.Forbidden: 403 POST https://bigquery.googleapis.com/bigquery/v2/projects/tort-intake-professionals/queries?prettyPrint=false: Access Denied: BigQuery BigQuery: Permission denied while getting Drive credentials."

Googlefu says I might need dataflow .admin & .worker permissions here

googlecloudcommunity.com

Re: Access Denied: BigQuery BigQuery: Permission denied while getting Drive credentials.

Hello Aris, Still getting the same error 'Access Denied: BigQuery BigQuery: Permission denied while getting Drive credentials.' The problem is here that the bigquery table is linked to the google sheet. So getting access denied for this only even though the service account has the view access to th...