cocoa-xu commented on PR #1722: URL: https://github.com/apache/arrow-adbc/pull/1722#issuecomment-2077957564
> is this really the only way we can do this? we can't just make a sql query or otherwise get this information from bigquery, we have to iterate and perform the pattern matching ourselves? **tl;dr**: yes. According to the replies in [googleapis/google-cloud-go#10044](https://github.com/googleapis/google-cloud-go/issues/10044#issuecomment-2077637285) and docs for BigQuery, the answer is yes, we have to enumerate projects and datasets (and as said in the reply, to enumerate projects we have to use ResourceManager, as current implementation of bigquery is not designed or possible to achieve this); or we're effectively limited in a single region (it's impossible to query all datasets that stored in multiple regions using a single query). Otherwise we would have to wait for Google to implement this feature, using a single SQL query to get all datasets in a project regardless of their location. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
