Coalesce Quality: Observability as Code


Configuration file format for synqcli, the Coalesce Quality observability-as-code tool for defining data quality monitors and tests.

Type: object
No Additional Properties

Type: const
Specific value: "v1beta1"

Type: string

Type: object
No Additional Properties

Type: string

Type: object
No Additional Properties

Duration

Type: string

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)?$
Examples:

"2h"
"30m"
"600s"
"2h30m"

Type: integer

Type: object
No Additional Properties

Type: object
No Additional Properties

Type: object
No Additional Properties

Type: string

Type: array
No Additional Items

Each item of this array must be:

Type: object
No Additional Properties

Type: array of string
No Additional Items

Each item of this array must be:

Type: array of string
No Additional Items

Each item of this array must be:

Type: object
No Additional Properties

Type: array of string
No Additional Items

Each item of this array must be:

Type: array of string
No Additional Items

Each item of this array must be:

Type: object
No Additional Properties

Type: const
Specific value: "v1beta2"

Type: string

Type: object
No Additional Properties

Type: enum (of string)

Must be one of:

  • "INFO"
  • "WARNING"
  • "ERROR"

Type: object

Type: enum (of string)

Must be one of:

  • "daily"
  • "hourly"
  • "ondemand"
Type: object
No Additional Properties

Type: enum (of string)

Must be one of:

  • "daily"
  • "hourly"

Type: object
No Additional Properties

Type: enum (of string)

Must be one of:

  • "ondemand"

Type: enum (of string)

Must be one of:

  • "1h"
  • "24h"

Type: object
No Additional Properties

Type: object
No Additional Properties

Type: enum (of string)

Must be one of:

  • "PRECISE"
  • "BALANCED"
  • "RELAXED"

Type: object
No Additional Properties

Type: string

Type: boolean

Type: array
No Additional Items

Each item of this array must be:

Type: object
No Additional Properties

Type: string

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.

Type: array
No Additional Items

Each item of this array must be:

Type: object

Type: object
No Additional Properties

Type: string

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.

Type: const
Specific value: "accepted_values"

Type: object

Type: enum (of string)

Must be one of:

  • "daily"
  • "hourly"
  • "ondemand"
Type: object
No Additional Properties

Type: enum (of string)

Must be one of:

  • "daily"
  • "hourly"

Type: enum (of string)

Must be one of:

  • "INFO"
  • "WARNING"
  • "ERROR"

Type: array of string

All items must be unique

No Additional Items

Each item of this array must be:

Type: object
No Additional Properties

Type: string

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.

Type: const
Specific value: "business_query"

Type: enum (of string)

Must be one of:

  • "INFO"
  • "WARNING"
  • "ERROR"

Type: array

Must contain a minimum of 1 items

No Additional Items

Each item of this array must be:

Type: object
No Additional Properties

Type: string
Must match regular expression: ^[A-Za-z0-9_-]+$

Type: enum (of string)

Must be one of:

  • "INFO"
  • "WARNING"
  • "ERROR"
Type: object
No Additional Properties

Type: string

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.

Type: const
Specific value: "business_rule"

Type: enum (of string)

Must be one of:

  • "INFO"
  • "WARNING"
  • "ERROR"

Type: array of string

All items must be unique

No Additional Items

Each item of this array must be:

Type: object
No Additional Properties

Type: string

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.

Type: const
Specific value: "empty"

Type: enum (of string)

Must be one of:

  • "INFO"
  • "WARNING"
  • "ERROR"

Type: array of string
No Additional Items

Each item of this array must be:

Type: string

Must be at least 1 characters long

Type: array of string

All items must be unique

No Additional Items

Each item of this array must be:

Type: object
No Additional Properties

Type: string

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.

Type: const
Specific value: "freshness"

Type: enum (of string)

Must be one of:

  • "INFO"
  • "WARNING"
  • "ERROR"

Type: array of string

All items must be unique

No Additional Items

Each item of this array must be:

Type: object
No Additional Properties

Type: string

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.

Type: const
Specific value: "max_value"

Type: enum (of string)

Must be one of:

  • "INFO"
  • "WARNING"
  • "ERROR"

Type: array of string

All items must be unique

No Additional Items

Each item of this array must be:

Type: object
No Additional Properties

Type: string

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.

Type: const
Specific value: "min_max"

Type: enum (of string)

Must be one of:

  • "INFO"
  • "WARNING"
  • "ERROR"

Type: array of string

All items must be unique

No Additional Items

Each item of this array must be:

Type: object
No Additional Properties

Type: string

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.

Type: const
Specific value: "min_value"

Type: enum (of string)

Must be one of:

  • "INFO"
  • "WARNING"
  • "ERROR"

Type: array of string

All items must be unique

No Additional Items

Each item of this array must be:

Type: object
No Additional Properties

Type: string

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.

Type: const
Specific value: "not_null"

Type: enum (of string)

Must be one of:

  • "INFO"
  • "WARNING"
  • "ERROR"

Type: array of string
No Additional Items

Each item of this array must be:

Type: string

Must be at least 1 characters long

Type: array of string

All items must be unique

No Additional Items

Each item of this array must be:

Type: object
No Additional Properties

Type: string

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.

Type: const
Specific value: "rejected_values"

Type: enum (of string)

Must be one of:

  • "INFO"
  • "WARNING"
  • "ERROR"

Type: array of string

All items must be unique

No Additional Items

Each item of this array must be:

Type: object
No Additional Properties

Type: string

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.

Type: const
Specific value: "relationships"

Type: enum (of string)

Must be one of:

  • "INFO"
  • "WARNING"
  • "ERROR"

Type: array of string

All items must be unique

No Additional Items

Each item of this array must be:

Type: object
No Additional Properties

Type: string

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.

Type: const
Specific value: "relative_time"

Type: enum (of string)

Must be one of:

  • "INFO"
  • "WARNING"
  • "ERROR"

Type: array of string

All items must be unique

No Additional Items

Each item of this array must be:

Type: object
No Additional Properties

Type: string

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.

Type: const
Specific value: "unique"

Type: enum (of string)

Must be one of:

  • "INFO"
  • "WARNING"
  • "ERROR"

Type: array of string
No Additional Items

Each item of this array must be:

Type: string

Must be at least 1 characters long

The following properties are required:

  • type

Type: array
No Additional Items

Each item of this array must be:

Type: object

Type: object
No Additional Properties

Type: string

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.

Type: const
Specific value: "category_distribution"

Type: enum (of string)

Must be one of:

  • "INFO"
  • "WARNING"
  • "ERROR"

Type: integer

Value must be greater or equal to 0

Type: object
No Additional Properties

Type: string

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.

Type: const
Specific value: "custom_numeric"

Type: enum (of string)

Must be one of:

  • "INFO"
  • "WARNING"
  • "ERROR"

Type: boolean

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.

Type: object
No Additional Properties

Type: string

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.

Type: const
Specific value: "custom_table_stats"

Type: enum (of string)

Must be one of:

  • "INFO"
  • "WARNING"
  • "ERROR"

Type: array
No Additional Items

Each item of this array must be:

Type: object

Type: enum (of string)

Must be one of:

  • "ROW_COUNT"
  • "DELAY"
  • "VOLUME_CHANGE_DELAY"
Type: object
No Additional Properties

Type: enum (of string)

Must be one of:

  • "ROW_COUNT"
  • "DELAY"
  • "VOLUME_CHANGE_DELAY"

Type: enum (of string)

Must be one of:

  • "PRECISE"
  • "BALANCED"
  • "RELAXED"

Type: enum (of string)

Must be one of:

  • "PRECISE"
  • "BALANCED"
  • "RELAXED"

Type: enum (of string)

Must be one of:

  • "STANDARD"
  • "WEEKLY_PATTERN"
Type: object
No Additional Properties

Type: string

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.

Type: const
Specific value: "field_stats"

Type: enum (of string)

Must be one of:

  • "INFO"
  • "WARNING"
  • "ERROR"

Type: array

Must contain a minimum of 1 items

No Additional Items

Each item of this array must be:

Type: object

Type: object
No Additional Properties

Type: array

Must contain a minimum of 1 items

No Additional Items

Each item of this array must be:


Type: enum (of string)

Must be one of:

  • "NUM_ROWS"
  • "NUM_NULL"
  • "PCT_NULL"
  • "NUM_UNIQUE"
  • "PCT_UNIQUE"
  • "NUM_EMPTY"
  • "PCT_EMPTY"
  • "MEAN"
  • "MIN"
  • "MAX"
  • "MEDIAN"
  • "STDDEV"
Type: object
No Additional Properties

Type: enum (of string)

Must be one of:

  • "NUM_ROWS"
  • "NUM_NULL"
  • "PCT_NULL"
  • "NUM_UNIQUE"
  • "PCT_UNIQUE"
  • "NUM_EMPTY"
  • "PCT_EMPTY"
  • "MEAN"
  • "MIN"
  • "MAX"
  • "MEDIAN"
  • "STDDEV"

Type: object
No Additional Properties

Type: string

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.

Type: const
Specific value: "freshness"

Type: enum (of string)

Must be one of:

  • "INFO"
  • "WARNING"
  • "ERROR"
Type: object
No Additional Properties

Type: stringFormat: uuid

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.

Type: const
Specific value: "table_stats"

Type: enum (of string)

Must be one of:

  • "INFO"
  • "WARNING"
  • "ERROR"

Type: enum (of string)

Must be one of:

  • "PRECISE"
  • "BALANCED"
  • "RELAXED"

Type: enum (of string)

Must be one of:

  • "STANDARD"
  • "WEEKLY_PATTERN"
Type: object
No Additional Properties

Type: string

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.

Type: const
Specific value: "volume"

Type: enum (of string)

Must be one of:

  • "INFO"
  • "WARNING"
  • "ERROR"

The following properties are required:

  • type

Type: array
No Additional Items

Each item of this array must be:

Type: object

Type: object
No Additional Properties

Type: string

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.

Type: const
Specific value: "sql_tests"

Type: enum (of string)

Must be one of:

  • "INFO"
  • "WARNING"
  • "ERROR"

Type: array

Must contain a minimum of 1 items

No Additional Items

Each item of this array must be:

Type: object
No Additional Properties

Type: string

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.

Type: const
Specific value: "table_stats"

Type: enum (of string)

Must be one of:

  • "INFO"
  • "WARNING"
  • "ERROR"

Type: enum (of string)

Must be one of:

  • "PRECISE"
  • "BALANCED"
  • "RELAXED"

Type: enum (of string)

Must be one of:

  • "STANDARD"
  • "WEEKLY_PATTERN"

The following properties are required:

  • type

Type: array
No Additional Items

Each item of this array must be:

Type: object
No Additional Properties

Type: string

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.

Type: enum (of string)

Must be one of:

  • "table_stats"