Skip to main content
The Query Result To Grid orchestration component allows you to query a table and return rows of data that are loaded into a predefined grid variable for use elsewhere in the pipeline. The component features both basic and advanced modes, which allow you to set up a simple query via the component interface or to write your own SQL query.
This component has an upper limit of 5000 records. However, the returned payload size also has an upper limit of approximately 1 MB. If the payload exceeds this limit, the component will return an error.
This component is the grid equivalent of the Query Result To Scalar component.

Properties

string
required
A human-readable name for the component.
drop-down
required
  • Basic: This mode will build a query for you using the settings you configure in the Database, Schema, Table, Table columns, Order by, Sort, Limit, Filter conditions, and Combine conditions properties. In most cases, this mode will be sufficient.
  • Advanced: This mode will require you to write an SQL-like query in the Query property, to call data from Snowflake. The available fields and their descriptions are documented in the data model.
code editor
required
Input an SQL-like query, written according to the profile definition.This property is only available when Mode is set to Advanced.
Do not end SQL statements with a semicolon in this component.
drop-down
required
The Snowflake database. The special value [Environment Default] uses the database defined in the environment. Read Databases, Tables and Views - Overview to learn more.
drop-down
required
The Snowflake schema. The special value [Environment Default] uses the schema defined in the environment. Read Database, Schema, and Share DDL to learn more.
string
required
The name of the table to be queried.
object selector
required
Select columns to return from the table.
object selector
Select columns to sort rows by. When sorting rows by multiple columns, sorting is applied in the order you select the columns. The sort order is shown in this property when you finish selecting columns.
An update to Snowflake has resulted in a change in the behavior of this parameter. The LIMIT 5000 clause (which the Advanced Mode parameter automatically wraps the query in) no longer guarantees that the order specified by the ORDER BY in the sub-query is preserved.
drop-down
required
Select whether rows are sorted in Ascending or Descending order.
integer
required
Set the limit of returned rows.
drop-down
required
Choose the grid variable to be loaded with data resulting from the query.
column editor
required
Map columns from the queried table to the columns of the grid variable.Toggle Text mode on at the bottom of the dialog to open a multi-line editor that lets you add items in a single block. For more information, read Text mode.To use grid variables, toggle Use Grid Variable on. For more information, read Grid variables.
column editor
  • Input column: Select an input column. The available input columns vary depending upon the data source.
  • Qualifier:
    • Is: Compares the column to the value using the comparator.
    • Not: Reverses the effect of the comparison, so “Equals” becomes “Not equals”, “Less than” becomes “Greater than or equal to”, etc.
  • Comparator: Choose a method of comparing the column to the value. Possible comparators include: “Equal to”, “Greater than”, “Less than”, “Greater than or equal to”, “Less than or equal to”, “Like”, “Null”. “Equal to” can match exact strings and numeric values, while other comparators, such as “Greater than” and “Less than”, will work only with numerics. The “Like” operator allows the wildcard character [%] to be used at the start and end of a string value to match a column. The Null operator matches only null values, ignoring whatever the value is set to. Not all data sources support all comparators, meaning that it is likely that only a subset of the above comparators will be available to choose from.
  • Value: The value to be compared.
Toggle Text mode on at the bottom of the dialog to open a multi-line editor that lets you add items in a single block. For more information, read Text mode.To use grid variables, toggle Use Grid Variable on. For more information, read Grid variables.
drop-down
required
Select whether to use the defined filters in combination with one another according to either And or Or.