Loading

Google BigQuery Connector | How to Retrieve Query Results From Google BigQuery

게시 일자: Mar 2, 2024
솔루션

QUESTION

How to retrieve query results from Google BigQuery using the Google BigQuery Connector for Mule 4?

ANSWER

Depending on whether you want to run the query synchronously or asynchronously, you might want to use either option 1 or option 2 below:

1. The Query operation (Runs a BigQuery SQL query synchronously and returns query results if the query completes within a specified timeout)

https://docs.mulesoft.com/google-bigquery-connector/1.1/google-bigquery-connector-examples#query

The corresponding Google BigQuery API is:
https://cloud.google.com/bigquery/docs/reference/rest/v2/jobs/query#QueryRequest

2. The Insert Job operation (Starts a new asynchronous job) and the Get Query Results operation (Gets the results of a query job)

https://docs.mulesoft.com/google-bigquery-connector/1.1/google-bigquery-connector-examples#insert-job

https://docs.mulesoft.com/google-bigquery-connector/1.1/google-bigquery-connector-examples#get-query-result


The corresponding Google BigQuery APIs are:
https://cloud.google.com/bigquery/docs/reference/rest/v2/jobs/insert
https://cloud.google.com/bigquery/docs/reference/rest/v2/jobs/getQueryResults

The following article explains how to configure the Insert Job operation:
Google BigQuery Connector | How to configure Insert job operation

Disclaimer:
This solution provides a suggestion that should be considered in conjunction with your specific use case and requirements and does not represent a complete solution for all circumstances.
This article involves products and technologies which do not form part of the MuleSoft product set. Technical assistance for such products is limited to this article.
Knowledge 기사 번호

001123639

 
로드 중
Salesforce Help | Article