Version: 3.0.0

Singular SQL Test

A singular test implemented in SQL that runs as a standalone component.

SingularTestSql

info

SingularTestSql is defined beneath the following ancestor nodes in the YAML structure:

Below are the properties for the SingularTestSql. Each property links to the specific details section further down in this page.

Property	Default	Type	Required	Description
severity	error	string ("error", "warn")	No	The severity level for issues raised by the test. Default is 'error'. Use 'error' for critical issues that should interrupt flow processing. Use 'warn' for warnings/minor issues that should not interrupt flow processing.
inputs		array[InputComponent]	No	List of input names to use in the test.
sql		string	No	SQL query that tests data for conditions.

A component is a fundamental building block of a data flow. Types of components that are supported include: read, transform, task, test, and more.

Property	Default	Type	Required	Description
component		One of: ReadComponent TransformComponent TaskComponent SingularTestComponent CustomPythonReadComponent WriteComponent CompoundComponent AliasedTableComponent ExternalTableComponent	Yes	Configuration options for the component.

A singular test (Python or SQL) that runs as a standalone component.

Property	Type	Required	Description
name	string	No	The name of the model
description	string	No	A brief description of what the model does.
metadata	ResourceMetadata	No	Meta information of a resource. In most cases it doesn't affect the system behavior but may be helpful to analyze project resources.
flow_name	string	No	The name of the flow that the component belongs to.
skip	boolean	No	A boolean flag indicating whether to skip processing for the component or not.
data_maintenance	DataMaintenance	No	The data maintenance configuration options for the component.
singular_test	One of: SingularTestSql SingularTestPython	Yes	Singular test to run.