I am running into some quota limitations when doing a high number of read requests in parallel:
google.api_core.exceptions.ResourceExhausted: 429 Quota exceeded for quota metric 'Administrative requests' and limit 'Administrative requests per minute' of service 'spanner.googleapis.com' for consumer 'project_number:xxxx'.
The request is quite similar to a simple SELECT * FROM table1 as t1 JOIN table2 as t2 ON t1.id = t2.id.
The error says Administrative requests per minute which seems weird to me since it has nothing to do with an admin action right?
Is it something related to python-spanner-sqlalchemy?
From https://cloud.google.com/spanner/quotas#administrative_limits, it seems like the limit can't be modified.
This issue is quite limiting for us at the moment to scale our workload with Spanner.