So I have a few BigQuery tables that I want to make accessible to query through python for a fairly large amount of users (I'd say around the ball park of 500 to be safe). I know the typical method to make them accessible through a service account and then pass a JSON key to those people. But I'd like to avoid that since the limit for service accounts through Google is 100. I would like to be able to identify users activity in terms of BigQuery usage, so hence I have the issue.
Is there another way to handle this?
I've been exploring making my own API and then making that endpoint accessible through generated API keys. I've also been looking into the IAM policy but unsure if I should be tuning that.