A human-readable name for the component.
- Basic: This mode will build a query for you using settings from the Data Source, Data Selection, and Data Source Filter parameters. In most cases, this mode will be sufficient.
- Advanced: This mode will require you to write an SQL-like query to call data from Snowflake. The available fields and their descriptions are documented in the data model.
The Snowflake schema. The special value [Environment Default] uses the schema defined in the environment. Read Database, Schema, and Share DDL to learn more. The name of the table to be queried.
Select which columns to take from the table as part of the query.
Choose the columns by which to sort rows. If multiple columns are selected, rows are sorted by the first-listed column first, then by the next listed column, and so on.
Select whether rows are sorted in Ascending or Descending order.
Set the limit of returned rows.
- Input Column Name: 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.
To use grid variables, select the Use Grid Variable checkbox at the bottom of the Filter Conditions dialog.Select whether to use the defined filters in combination with one another according to either And or Or.
This property opens an editor. On the left, users can explore tables and their metadata from environments. Both project and pipeline variables are also listed in the bottom-left.SQL queries can be written in the main panel and tested using the Sample button, which will display results below.This property is only available when Mode is set to Advanced.Do not end SQL statements with a semicolon in this component.
Scalar results from the SQL query can be mapped to project and pipeline variables.Use the Input Column Name drop-down to select a scalar returned by the query. Use the Scalar Variable Name drop-down to select a variable to map the scalar to. Click + to add more mappings.Variables used in the mapping must be created before this component runs. Read variables for details of how to create variables. A human-readable name for the component.
- Basic: This mode will build a query for you using settings from the Data Source, Data Selection, and Data Source Filter parameters. In most cases, this mode will be sufficient.
- Advanced: This mode will require you to write an SQL-like query to call data from Databricks. The available fields and their descriptions are documented in the data model.
Select a Databricks Unity Catalog. The special value [Environment Default] uses the catalog defined in the environment. Selecting a catalog will determine which databases are available in the next parameter. The Databricks schema. The special value [Environment Default] uses the schema defined in the environment. Read Create and manage schemas to learn more. The name of the table to be queried.
Select which columns to take from the table as part of the query.
Choose the columns by which to sort rows. If multiple columns are selected, rows are sorted by the first-listed column first, then by the next listed column, and so on.
Select whether rows are sorted in Ascending or Descending order.
Set the limit of returned rows.
- Input Column Name: 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.
To use grid variables, select the Use Grid Variable checkbox at the bottom of the Filter Conditions dialog.Select whether to use the defined filters in combination with one another according to either And or Or.
This property opens an editor. On the left, users can explore tables and their metadata from environments. Both project and pipeline variables are also listed in the bottom-left.SQL queries can be written in the main panel and tested using the Sample button, which will display results below.This property is only available when Mode is set to Advanced.Do not end SQL statements with a semicolon in this component.
Scalar results from the SQL query can be mapped to project and pipeline variables.Use the Input Column Name drop-down to select a scalar returned by the query. Use the Scalar Variable Name drop-down to select a variable to map the scalar to. Click + to add more mappings.Variables used in the mapping must be created before this component runs. Read variables for details of how to create variables. A human-readable name for the component.
- Basic: This mode will build a query for you using settings from the Data Source, Data Selection, and Data Source Filter parameters. In most cases, this mode will be sufficient.
- Advanced: This mode will require you to write an SQL-like query to call data from Redshift. The available fields and their descriptions are documented in the data model.
Select the table schema. The special value [Environment Default] uses the schema defined in the environment. For more information on using multiple schemas, read Schemas. The name of the table to be queried.
Select which columns to take from the table as part of the query.
Choose the columns by which to sort rows. If multiple columns are selected, rows are sorted by the first-listed column first, then by the next listed column, and so on.
Select whether rows are sorted in Ascending or Descending order.
Set the limit of returned rows.
- Input Column Name: 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.
To use grid variables, select the Use Grid Variable checkbox at the bottom of the Filter Conditions dialog.Select whether to use the defined filters in combination with one another according to either And or Or.
This property opens an editor. On the left, users can explore tables and their metadata from environments. Both project and pipeline variables are also listed in the bottom-left.SQL queries can be written in the main panel and tested using the Sample button, which will display results below.This property is only available when Mode is set to Advanced.Do not end SQL statements with a semicolon in this component.
Scalar results from the SQL query can be mapped to project and pipeline variables.Use the Input Column Name drop-down to select a scalar returned by the query. Use the Scalar Variable Name drop-down to select a variable to map the scalar to. Click + to add more mappings.Variables used in the mapping must be created before this component runs. Read variables for details of how to create variables. 
