Query Result To Grid

Query Result To Grid

This component allows users to query a table for data that is then loaded into a grid variable for use elsewhere. The component features both basic and advanced modes that allow users to set up a simple query via the component interface or to write their own SQL queries.

Properties

Property Setting Description
Name Text The descriptive name for the component.
Basic/Advanced Mode Choice Basic - This mode will build a Query for you using settings from the component's properties.
Advanced - This mode will require you to write an SQL-like query which is translated into one or more API calls.
SQL Query Text This is an SQL-like query, written according to the Profile definition. (Property only available in 'Advanced' Mode)
Schema Select Select the table schema. The special value, [Environment Default] will use the schema defined in the environment. For more information on using multiple schemas, see this article.
Project Text The target BigQuery project to load data from.
Dataset Text The target BigQuery dataset to load data from.
Database Select Choose a database in which to find the table to be queried.
Table Name Text The name of the table to be queried.
Table Columns Multiple Select Select which columns to take from the table as part of the query.
Order By Select Choose columns by which rows are to be sorted. If multiple columns are selected, rows are sorted by the first-listed column first, then by the next listed and so on.
Sort Select Choose whether rows are sorted in ascending or descending order.
Limit Number Limits the number of returned rows. Fetching a large number of results may use multiple API calls. These calls can be rate-limited by the provider, so fetching a very large number may result in errors.
Grid Variable Select Choose the grid variable to be loaded with data resulting from the query.
Grid Variable Mapping Select Map columns from the queried table to the columns of the grid variable.