search

microbiomedata / sheets_and_friends

Enhance a LinkML model with imported and optionally modified slots
0 stars 0 forks source link

increase Google Sheets API reads per minute per user quota etc #87

Closed turbomam closed 1 year ago

turbomam commented 2 years ago

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

turbomam commented 2 years ago

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

turbomam commented 2 years ago

see #61

turbomam commented 2 years ago

@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 commented 2 years ago

@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 commented 1 year ago

@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 commented 1 year ago

@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 commented 1 year ago

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 https://github.com/microbiomedata/sheets_and_friends/issues/87#issuecomment-1199798264, or unsubscribe https://github.com/notifications/unsubscribe-auth/AGAEX6OLP4Q3TRGMPVRTFLLVWQKK3ANCNFSM5ROVA75Q . You are receiving this because you were mentioned.Message ID: @.***>

ssarrafan commented 1 year ago

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

turbomam commented 1 year ago

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 https://github.com/microbiomedata/sheets_and_friends/issues/87#issuecomment-1199798264, or unsubscribe https://github.com/notifications/unsubscribe-auth/AGAEX6OLP4Q3TRGMPVRTFLLVWQKK3ANCNFSM5ROVA75Q . You are receiving this because you were mentioned.Message ID: @.***>