Performing a query in Google BigQuery

This scenario uses two components to perform the SELECT query in BigQuery and present the result in the Studio.

For more technologies supported by Talend, see Talend components.

The following figure shows the schema of the table, UScustomer, we use as example to perform the SELECT query in.

We will select the State records and count the occurrence of each State among those records.