increase Google Sheets API reads per minute per user quota etc

[turbomam]

May need to do this through LBL, or tie existing project to LBL first

[turbomam]

@turbomam will push code to include a sleep step between cogs operations

[turbomam]

see #61

[turbomam]

@ssarrafan this is frustrating, but shouldn't be a priority in terms of theJune 2022 DOE funding renewal.

Please move to the July sprint.

If you have contacts at Google, I can describe this more technically.

[ssarrafan]

@turbomam I checked with Ed who works for JGI and used to work at Google but he is not familiar with the API. Sorry! I will move this to July.

[turbomam]

@ssarrafan @sujaypatil96 @mcovalt this hasn't been a problem for me recently. I was thinking about decreasing or eliminating the sleep step

@sujaypatil96 were you granted an increase to this quota? Did you apply it? How could one of see that to better understand what you did?

[sujaypatil96]

@turbomam so we requested for an increase of the requests per min per user quota from the same Google account that was used to create the client secret JSON file. If we look through the inbox for that account, we should see an email response from Google Cloud support regarding our request.

[turbomam]

Sure Mark, I'll look into this issue. Will ping you if I have any questions about the account.

…

On Fri, Jul 29, 2022 at 10:52 AM Mark Miller ***@***.***> wrote: I think that was a service account, so I don't know how to check the email. Can you look into that please @sujay Patil ***@***.***> ? On Fri, Jul 29, 2022, 1:47 PM Sujay Patil ***@***.***> wrote: > @turbomam <https://github.com/turbomam> so we requested for an increase > of the requests per min per user quota from the same Google account that > was used to create the client secret JSON file. If we look through the > inbox for that account, we should see an email response from Google Cloud > support regarding our request. > > — > Reply to this email directly, view it on GitHub > <#87 (comment)>, > or unsubscribe > <https://github.com/notifications/unsubscribe-auth/AGAEX6OLP4Q3TRGMPVRTFLLVWQKK3ANCNFSM5ROVA75Q> > . > You are receiving this because you were mentioned.Message ID: > ***@***.***> >

[ssarrafan]

Based on Sujay's note I will close this issue but let me know if it should be re-opened.

[turbomam]

I think that was a service account, so I don't know how to check the email. Can you look into that please @sujay Patil ***@***.***> ?

…

On Fri, Jul 29, 2022, 1:47 PM Sujay Patil ***@***.***> wrote: @turbomam <https://github.com/turbomam> so we requested for an increase of the requests per min per user quota from the same Google account that was used to create the client secret JSON file. If we look through the inbox for that account, we should see an email response from Google Cloud support regarding our request. — Reply to this email directly, view it on GitHub <#87 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AGAEX6OLP4Q3TRGMPVRTFLLVWQKK3ANCNFSM5ROVA75Q> . You are receiving this because you were mentioned.Message ID: ***@***.***>