Integrate apigee private cloud with BigQuery

[alvaroramirezlo]

Is it possible to do the integration between apiggee cloud private and BigQuery without using the ExtensionCallaout policy, but they tell us that it is not possible, is there any way to achieve it?

[#2]

if can try with java callout else you can try as rest endpoint if bigquery exposes through rest api call.

[dchiesa1]

Yes, it is quite possible.

You do not need a Java callout or any custom code (I think) to make this happen.

BigQuery exposes a REST API over HTTP.

That means APigee can invoke it as a regular target.

The trick is to get Apigee to use the proper authentication. Probably you will want to use a Service Account. You can embed service account credentials in the Apigee proxy, have Apigee get the right token, and then use THAT token with the BQ REST endpoint.

I have an example that connects to GCP Logging via the REST API. It uses the pattern I just described. All you would need to do is modify the request payload and endpoint, so that Apigee points to BQ instead of to GCP Logging. The interesting bits in this example are the way to manage credentials and get the right token for the BQ backend.

Good luck.