Configuration file format for synqcli, the Coalesce Quality observability-as-code tool for defining data quality monitors and tests.
"v1beta1"
An amount of time.
Must match regular expression:^([0-9]+([.][0-9]+)?h)?([0-9]+([.][0-9]+)?m)?([0-9]+([.][0-9]+)?s)?([0-9]+([.][0-9]+)?ms)?([0-9]+([.][0-9]+)?us|µs)?([0-9]+([.][0-9]+)?ns)?$
"2h"
"30m"
"600s"
"2h30m"
"v1beta2"
Path of the table or view the monitors and tests below are anchored to, either a simple name or a full path. It is part of every check's address here, and a monitor cannot be moved to another asset: editing it replaces every check under this entity.
The test's address within its entity and namespace. A UUID is adopted as-is; any other string is a slug the id is derived from, so the columns, the SQL and the evaluators can be edited without replacing the test. Renaming the id, moving the test to another entity or changing its type replaces it, and the check entity, its issues and its error runs are discarded. Without an id the test is identified by its content, and editing a column or the SQL replaces it.
"accepted_values"
All items must be unique
No Additional ItemsThe test's address within its entity and namespace. A UUID is adopted as-is; any other string is a slug the id is derived from, so the columns, the SQL and the evaluators can be edited without replacing the test. Renaming the id, moving the test to another entity or changing its type replaces it, and the check entity, its issues and its error runs are discarded. Without an id the test is identified by its content, and editing a column or the SQL replaces it.
"business_query"
Must contain a minimum of 1 items
^[A-Za-z0-9_-]+$
The test's address within its entity and namespace. A UUID is adopted as-is; any other string is a slug the id is derived from, so the columns, the SQL and the evaluators can be edited without replacing the test. Renaming the id, moving the test to another entity or changing its type replaces it, and the check entity, its issues and its error runs are discarded. Without an id the test is identified by its content, and editing a column or the SQL replaces it.
"business_rule"
All items must be unique
No Additional ItemsThe test's address within its entity and namespace. A UUID is adopted as-is; any other string is a slug the id is derived from, so the columns, the SQL and the evaluators can be edited without replacing the test. Renaming the id, moving the test to another entity or changing its type replaces it, and the check entity, its issues and its error runs are discarded. Without an id the test is identified by its content, and editing a column or the SQL replaces it.
"empty"
Must be at least 1 characters long
All items must be unique
No Additional ItemsThe test's address within its entity and namespace. A UUID is adopted as-is; any other string is a slug the id is derived from, so the columns, the SQL and the evaluators can be edited without replacing the test. Renaming the id, moving the test to another entity or changing its type replaces it, and the check entity, its issues and its error runs are discarded. Without an id the test is identified by its content, and editing a column or the SQL replaces it.
"freshness"
All items must be unique
No Additional ItemsThe test's address within its entity and namespace. A UUID is adopted as-is; any other string is a slug the id is derived from, so the columns, the SQL and the evaluators can be edited without replacing the test. Renaming the id, moving the test to another entity or changing its type replaces it, and the check entity, its issues and its error runs are discarded. Without an id the test is identified by its content, and editing a column or the SQL replaces it.
"max_value"
All items must be unique
No Additional ItemsThe test's address within its entity and namespace. A UUID is adopted as-is; any other string is a slug the id is derived from, so the columns, the SQL and the evaluators can be edited without replacing the test. Renaming the id, moving the test to another entity or changing its type replaces it, and the check entity, its issues and its error runs are discarded. Without an id the test is identified by its content, and editing a column or the SQL replaces it.
"min_max"
All items must be unique
No Additional ItemsThe test's address within its entity and namespace. A UUID is adopted as-is; any other string is a slug the id is derived from, so the columns, the SQL and the evaluators can be edited without replacing the test. Renaming the id, moving the test to another entity or changing its type replaces it, and the check entity, its issues and its error runs are discarded. Without an id the test is identified by its content, and editing a column or the SQL replaces it.
"min_value"
All items must be unique
No Additional ItemsThe test's address within its entity and namespace. A UUID is adopted as-is; any other string is a slug the id is derived from, so the columns, the SQL and the evaluators can be edited without replacing the test. Renaming the id, moving the test to another entity or changing its type replaces it, and the check entity, its issues and its error runs are discarded. Without an id the test is identified by its content, and editing a column or the SQL replaces it.
"not_null"
Must be at least 1 characters long
All items must be unique
No Additional ItemsThe test's address within its entity and namespace. A UUID is adopted as-is; any other string is a slug the id is derived from, so the columns, the SQL and the evaluators can be edited without replacing the test. Renaming the id, moving the test to another entity or changing its type replaces it, and the check entity, its issues and its error runs are discarded. Without an id the test is identified by its content, and editing a column or the SQL replaces it.
"rejected_values"
All items must be unique
No Additional ItemsThe test's address within its entity and namespace. A UUID is adopted as-is; any other string is a slug the id is derived from, so the columns, the SQL and the evaluators can be edited without replacing the test. Renaming the id, moving the test to another entity or changing its type replaces it, and the check entity, its issues and its error runs are discarded. Without an id the test is identified by its content, and editing a column or the SQL replaces it.
"relationships"
All items must be unique
No Additional ItemsThe test's address within its entity and namespace. A UUID is adopted as-is; any other string is a slug the id is derived from, so the columns, the SQL and the evaluators can be edited without replacing the test. Renaming the id, moving the test to another entity or changing its type replaces it, and the check entity, its issues and its error runs are discarded. Without an id the test is identified by its content, and editing a column or the SQL replaces it.
"relative_time"
All items must be unique
No Additional ItemsThe test's address within its entity and namespace. A UUID is adopted as-is; any other string is a slug the id is derived from, so the columns, the SQL and the evaluators can be edited without replacing the test. Renaming the id, moving the test to another entity or changing its type replaces it, and the check entity, its issues and its error runs are discarded. Without an id the test is identified by its content, and editing a column or the SQL replaces it.
"unique"
Must be at least 1 characters long
The monitor's address within its entity and namespace. A UUID is adopted as-is; any other string is a slug the id is derived from, so every other field can be edited without replacing the monitor. Renaming the id, moving the monitor to another entity or changing its type replaces it, discarding the learned baseline, the check entity and its issue history. Without an id the monitor is identified by its content, and editing a field of that content replaces it.
"category_distribution"
Value must be greater or equal to 0
The monitor's address within its entity and namespace. A UUID is adopted as-is; any other string is a slug the id is derived from, so every other field can be edited without replacing the monitor. Renaming the id, moving the monitor to another entity or changing its type replaces it, discarding the learned baseline, the check entity and its issue history. Without an id the monitor is identified by its content, and editing a field of that content replaces it.
"custom_numeric"
Set when metric_aggregation can never return a negative value, such as a count, a sum of non-negative amounts or a duration. The anomaly engine then never forecasts below 0 and scores each value against that floored forecast, so a zero is not measured against an impossible negative baseline. Leave it unset when the value can legitimately go below 0.
The monitor's address within its entity and namespace. A UUID is adopted as-is; any other string is a slug the id is derived from, so every other field can be edited without replacing the monitor. Renaming the id, moving the monitor to another entity or changing its type replaces it, discarding the learned baseline, the check entity and its issue history. Without an id the monitor is identified by its content, and editing a field of that content replaces it.
"custom_table_stats"
The monitor's address within its entity and namespace. A UUID is adopted as-is; any other string is a slug the id is derived from, so every other field can be edited without replacing the monitor. Renaming the id, moving the monitor to another entity or changing its type replaces it, discarding the learned baseline, the check entity and its issue history. Without an id the monitor is identified by its content, and editing a field of that content replaces it.
"field_stats"
Must contain a minimum of 1 items
Must contain a minimum of 1 items
The monitor's address within its entity and namespace. A UUID is adopted as-is; any other string is a slug the id is derived from, so every other field can be edited without replacing the monitor. Renaming the id, moving the monitor to another entity or changing its type replaces it, discarding the learned baseline, the check entity and its issue history. Without an id the monitor is identified by its content, and editing a field of that content replaces it.
"freshness"
UUID of an existing table stats rule on this asset, adopted as-is. Written by export; a redeploy then updates that rule instead of creating a second one. A non-UUID is rejected — a static rule is addressed by its asset path, so there is nothing for a slug to name.
"table_stats"
Must contain a minimum of 1 items
The monitor's address within its entity and namespace. A UUID is adopted as-is; any other string is a slug the id is derived from, so every other field can be edited without replacing the monitor. Renaming the id, moving the monitor to another entity or changing its type replaces it, discarding the learned baseline, the check entity and its issue history. Without an id the monitor is identified by its content, and editing a field of that content replaces it.
"volume"
The rule's address. A UUID is adopted as-is; any other string is a slug the id is derived from. With an id, renaming the rule or editing its query updates it, and the tests it deployed keep their history; renaming the id replaces the rule, which deletes those tests. Without an id the name is the address, so a rename does the same.
"sql_tests"
Must contain a minimum of 1 items
The rule's address. A UUID is adopted as-is; any other string is a slug the id is derived from. With an id, renaming the rule or editing its query updates it; renaming the id replaces it. Without one the name is the address, so a rename replaces the rule.
"table_stats"
Must contain a minimum of 1 items
The exclusion's address. A UUID is adopted as-is; any other string is a slug the id is derived from. With an id, renaming the exclusion or editing its query updates it; renaming the id replaces it. Without one the name is the address, so a rename replaces the exclusion.