After reading around, google documentation, some stackoverflow posts and other forums, I am still not sure if I understand what are the quotas and limitations for the Data Connector > Connect to BigQuery feature on google spreadsheets (see image below).
Is it fair to say that this feature is an API v4 feature? If yes, limits documentation for API v4 are here
This version of the Google Sheets API has a limit of 500 requests per 100 seconds per project, and 100 requests per 100 seconds per user. Limits for reads and writes are tracked separately. There is no daily usage limit.
Does it mean that there is not limit in terms of amount of connections?
Practical (extreme) example: it would be technically possible to have 1,000 different spreadsheets with a BQ data connector for the same user at the same time?
Thanks