Assert External Table
The Assert 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
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 |
|---|---|---|
| ✅ | ❌ | ❌ |