Google BigQuery - Select rows action (batch)

The Select rows batch action retrieves rows from a Google BigQuery table using WHERE predicates. This action filters rows that meet the specified criteria. If the query takes longer than 60 seconds and Wait for query to complete? is set to No, the action returns only the job ID. Use the Get batch of rows by Job ID action to retrieve results later.

Input

Input field	Description
Project	Select the project to bill for the query.
Dataset	Select the dataset that contains the target table.
Table	Select the table to query from the dataset.
Location	Choose the region to run the query.
Output columns	Select the columns to return. Limiting output fields can improve performance.
WHERE Predicates	Define filter conditions to retrieve matching rows. All predicates are joined with AND. For complex filtering, use custom SQL.
Order by	Specify the column(s) and sort direction. For example: priority asc, created_date desc.
Limit	Set the maximum number of rows to return. The default and maximum is 50000. Leave blank to return the full result set.
Offset	Skip a number of rows in the result. For example, input 100 to skip the first 100 rows. The default is 0.
Wait for query to complete?	Set to Yes to wait for the query to finish. If set to No, the action returns after 60 seconds with only the job ID. Use the Get batch of rows by Job ID action to retrieve results.
Table Fields	Required if the Table field uses a datapill. Specify the table schema. It must match across all possible values of the datapill.

Output

Output field	Description
Output contains rows?	Indicates whether the result includes row data.
Rows	An array of row objects. Each datapill represents a column value.
Kind	The type of job executed. This should be queryResponse.
Job reference	Includes the project ID, job ID, and query location. You can use the Get batch of rows by Job ID action to retrieve additional rows.
Total rows	Total number of rows returned by the query.
Page token	Token to retrieve the next page of results.
Schema	The schema of the query result.
Etag	A hash representing the result schema.
Total bytes processed	The number of bytes the query processed. This contributes to your BigQuery billing.
Job complete	Status of the query job. Returns Done if the job completed successfully.
Cache hit	Returns true if the result came from the query cache. Returns false otherwise.