Assert View Component

Assert View Component



Assert View

The Assert View component lets users verify that certain conditions are true of a view, or otherwise stop the query.

Whenever a view is accessible on a Transformation Job, users can attach an Assert View component and assert against the metadata, values, and row count using comparators such as Equal to, Less than or equal to, Greater than or equal to, and Range.



Redshift Properties

Property Setting Description
Name String Input the descriptive name for the component.
Metadata Name The column name.
Type Select the data type.
Text: this type can hold any kind of data, subject to a maximum size. More...
Integer: this type is suitable for whole-number types (no decimals). More...
Numeric: this type is suitable for numeric types, with or without decimals. More...
Real: this type is suitable for data of a single precision floating-point number. More...
Double Precision: this type is suitable for data of a double precision floating-point number. 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...
DateTime: this type is suitable for dates, times, or timestamps (both date and time). More...
Size For Text types, this is the maximum length. This is a limit on the number of bytes, not characters. With Redshift, since all data is stored using UTF-8, any non-ASCII character will count as 2 or more bytes.
For Numeric types, this is the total number of digits allowed, whether before or after the decimal point.
Scale Relevant only for numeric data, it is the maximum number of digits that may appear to the right of the decimal point.
Values String Input the values for each column. Separate values in the same column with a comma.
Ignore Metadata Order Boolean When set to "True", Matillion ETL will ignore the metadata order. Default is "False".
Row Count Comparison Type Select This property determines the possible comparison for the Row Count Values.
Possible comparators include: "Equal to", "Greater than or equal to", "Less than or equal to", "Range".
Equal To: Value in the Input Column must be equal to that specified in the Value Column. It is the default condition type.
Greater than or equal to: Value in the Input Column must be greater than or equal to that specified in the Value Column.
Less than or equal to: Value in the Input Column must be less than or equal to that specified in the Value Column.
Range: This allows users to specify the range for the value of the row counts.
Selecting "Range" makes the Upper Value and Lower Value properties available.
Note: Not all data sources support all comparators; thus, it is likely that only a subset of the above comparators will be available to choose from.
Row Count Value Integer Specify the number of rows.

Snowflake Properties

Property Setting Description
Name String Input the descriptive name for the component.
Values String Input the values for each column. Separate values in the same column with a comma.
Metadata Name The name of each column.
Type Select a date type.
VARCHAR: this type can hold any kind of data, subject to a maximum size. More...
NUMBER: this type is suitable for whole-number types (no decimals). More...
Note: You can enter AUTOINCREMENT or IDENTITY as the default value for any numeric-type column and the column will automatically give an incremented value on each new row starting from 1. This feature is useful when creating a unique key on the table.
FLOAT: this type is suitable for numeric types, with or without decimals. 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...
TIMESTAMP: this type is suitable for timestamps. More...
TIME: this type is suitable for times only. More...
VARIANT: a flexible type that can be used for any purpose. 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.
Scale Relevant only for numeric data, it is the maximum number of digits that may appear to the right of the decimal point.
Ignore Metadata Order Boolean When set to "True", Matillion ETL will ignore the metadata order. Default is "False".
Row Count Comparison Type Select This property determines the possible comparison for the Row Count Values.
Possible comparators include: "Equal to", "Greater than or equal to", "Less than or equal to", "Range".
Equal To: Value in the Input Column must be equal to that specified in the Value Column. It is the default condition type.
Greater than or equal to: Value in the Input Column must be greater than or equal to that specified in the Value Column.
Less than or equal to: Value in the Input Column must be less than or equal to that specified in the Value Column.
Range: This allows users to specify the range for the value of the row counts.
Selecting "Range" makes the Upper Value and Lower Value properties available.
Note: Not all data sources support all comparators; thus, it is likely that only a subset of the above comparators will be available to choose from.
Row Count Value Integer Specify the number of rows.

BigQuery Properties

Property Setting Description
Name String Input the descriptive name for the component.
Values String Input the values for each column. Separate values in the same column with a comma.
Metadata Name The name of each column.
Data Type String: This type can hold any kind of data, subject to a maximum size.
Integer: This type is suitable for whole-number types (no decimals). More...
Float: This type of values are approximate numeric values with fractional components. More...
Numeric: This type is suitable for numeric types, without or with decimals. 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 timezoneMore...
DateTime: This type is suitable for dates, times, or timestamps (both date and time). More...
Timestamp: This type is a timestamp left unformatted (exists as Unix/Epoch Time). More...
Mode Nullable: Indicates that NULL values are permissible.
Required: Field does not accept null values.
Repeated: Field can accept multiple values.
Ignore Metadata Order Boolean When set to "True", Matillion ETL will ignore the metadata order. Default is "False".
Row Count Comparison Type Select This property determines the possible comparison for the Row Count Values.
Possible comparators include: "Equal to", "Greater than or equal to", "Less than or equal to", "Range".
Equal To: Value in the Input Column must be equal to that specified in the Value Column. It is the default condition type.
Greater than or equal to: Value in the Input Column must be greater than or equal to that specified in the Value Column.
Less than or equal to: Value in the Input Column must be less than or equal to that specified in the Value Column.
Range: This allows users to specify the range for the value of the row counts.
Selecting "Range" makes the Upper Value and Lower Value properties available.
Note: Not all data sources support all comparators; thus, it is likely that only a subset of the above comparators will be available to choose from.
Row Count Value Integer Specify the number of rows.

Synapse Properties

Property Setting Description
Name String Input the descriptive name for the component.
Values String Input the values for each column. Separate values in the same column with a comma.
Metadata Column Name Input the name of the column.
Data Type Select the data type. The available data types are: DATE: this data type is suitable for dates without times. More...
DATETIME: this data type is suitable for timestamps. More...
TIME: this data type is suitable for times only. More...
INTEGER: this data type is suitable for whole number types (no decimals). More...
NUMERIC: this data type is suitable for numeric types, with or without decimals. More...
TEXT: this data type is suitable for text types. More...
FLOAT: this data type is suitable for approximate number data types for use with floating point numeric data. More...
BOOLEAN: this data type is suitable for data whether values are either "true" or "false". More...
Size Define the size. For T-SQL, this is denoted as Precision. More...
Precision Define the precision. For T-SQL, this is denoted as Scale. More...
Ignore Metadata Order Boolean When set to "True", Matillion ETL will ignore the metadata order. Default is "False".
Row Count Comparison Type Select This property determines the possible comparison for the Row Count Values.
Possible comparators include: "Equal to", "Greater than or equal to", "Less than or equal to", "Range".
Equal To: Value in the Input Column must be equal to that specified in the Value Column. It is the default condition type.
Greater than or equal to: Value in the Input Column must be greater than or equal to that specified in the Value Column.
Less than or equal to: Value in the Input Column must be less than or equal to that specified in the Value Column.
Range: This allows users to specify the range for the value of the row counts.
Selecting "Range" makes the Upper Value and Lower Value properties available.
Note: Not all data sources support all comparators; thus, it is likely that only a subset of the above comparators will be available to choose from.
Row Count Value Integer Specify the number of rows.