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. |