Skip to main content
The Assert External Table component empowers users to confirm that an external 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
required
A human-readable name for the component.
​
Database
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.
​
Schema
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.
​
Table Name
drop-down
required
Select the table to assert.
​
Exists
drop-down
required
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
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.
​
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.