API for listing all the External Connections in a project for BigQueryI’m

[Arunprabu]

Hi All,

The RestAPI avaialable for listing external connections for BigQuery.

https://cloud.google.com/bigquery/docs/reference/bigqueryconnection/rest/v1/projects.locations.conne...

Location is a mandatory field in the request, is there any api available to list connections for BigQuery from all locations, if not we need to trigger many APIs(for each location separatly).

Can someone help out here

thanks

[marckevin · Accepted solution]

Hi @Arunprabu,

Welcome to Google Cloud Community!

Yes, you're correct, you need to specify a location to list connections for BigQuery, as stated here projects/{projectId}/locations/{locationId}, this means you cannot list connections across all locations simultaneously. Currently, there is no API that lists all BigQuery connections across all locations/regions directly. Though you need to trigger many APIs for each location, you can try to automate the call.

Was this helpful? If so, please accept this answer as “Solution”. If you need additional assistance, reply here within 2 business days and I’ll be happy to help.

[Arunprabu]

Thanks