Skip to main content
The Assert Table orchestration component empowers users to confirm that a target table has been created with the correct metadata. This component asserts a row count using various methods such as “Equal to”, “Greater than”, “Less than”, and “Range”; these comparator options allow users to set the upper and lower values of row counts.

Properties

string
required
A human-readable name for the 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.
drop-down
required
Select the table to assert.
boolean
required
This property asserts that the table exists within the database. Set to “Yes” or “No”.
column editor
Enter the following details for each table column.
  • Column Name: The name of the new column.
  • Data Type: Select one of:
    • Varchar: This type is suitable for numbers and letters. A varchar or Variable Character Field is a set of character data of indeterminate length.
    • Number: This type is suitable for numeric types, with or without decimals.
    • Float: This type of values are approximate numeric values with fractional components.
    • Boolean: This type is suitable for data that is either “true” or “false”.
    • Date: This type is suitable for dates without times.
    • Time: This type is suitable for time, independent of a specific date and timezone.
    • Timestamp: This type is a timestamp left unformatted (exists as Unix/Epoch Time).
    • Variant: Variant is a tagged universal type that can hold up to 16 MB of any data type supported by Snowflake.
  • Size: For Text types, this is the maximum length. This is a limit on the number of bytes, not characters. For Numeric types, this is the total number of digits allowed, whether before or after the decimal point.
  • Precision: The precision of the data in the column. Will be 0 (zero) for non-applicable types.
You can specify table metadata using text mode.This property is only available when Exists is set to “Yes”.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 how row count values are compared. Possible comparison operators include:
  • Equal To: The value in the Input Column must be equal to that specified in the Value Column. This is the default comparison operator.
  • Greater Than or Equal To: The value in the Input Column must be greater than or equal to the value in the Value Column.
  • Less Than or Equal To: The value in the Input Column must be less than or equal to the value in the Value Column.
  • Range: This allows users to specify the range for the value of the row counts.
Not all data sources support all comparison operators; thus, it is likely that only a subset of the above comparison operators will be available to choose from.This property is only available when Exists is set to “Yes”.
integer
Set the lower value. This property is only applicable when Row count comparison type is set to “Range”.
integer
Set the upper value. This property is only applicable when Row count comparison type is set to “Range”.
integer
Specify the number of rows.This property is only available when Exists is set to “Yes”.