Performing a query in Google BigQuery

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

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.