Skip to content

Assert Table

The Assert Table 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

Name = string

A human-readable name for the component.


Database = drop-down

The Snowflake database. The special value, [Environment Default], will use the database defined in the environment. Read Databases, Tables and Views - Overview to learn more.


Schema = drop-down

The Snowflake schema. The special value, [Environment Default], will use the schema defined in the environment. Read Database, Schema, and Share DDL to learn more.


Table Name = drop-down

Select the table to assert.


Exists = drop-down

This property asserts that the table exists within the database.


Table Metadata = 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. More....
  • Number: This type is suitable for numeric types, with or without decimals. More....
  • Float: This type of values are approximate numeric values with fractional components. More....
  • Boolean: This type is suitable for data that is either "true" or "false". More....
  • Date: This type is suitable for dates without times. More....
  • Time: This type is suitable for time, independent of a specific date and timezone. More....
  • Timestamp: This type is a timestamp left unformatted (exists as Unix/Epoch Time). More....
  • Variant: Variant is a tagged universal type that can hold up to 16 MB of any data type supported by Snowflake. More....

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.


Row Count Comparison Type = drop-down

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.


Lower Value = integer

Set the lower value. This property is only applicable when Row Count Comparison Type is set to "Range".


Upper Value = integer

Set the upper value. This property is only applicable when Row Count Comparison Type is set to "Range".


Row Count Value = integer

Specify the number of rows.


Snowflake Databricks Amazon Redshift (preview)