DATA_QUALITY_DETAILS table

The DATA_QUALITY_DETAILS table contains details for all data quality assets in Atlan, including Atlan-native data quality rules and third-party entities such as AnomaloCheck, SodaCheck, and MCMonitor.

Source tables

This table consolidates data from the following entity types: AnomaloCheck, SodaCheck, MCMonitor, DataQualityRule, DataQualityRuleTemplate.

For complete entity type definitions and properties, refer to the Atlan Developer documentation.

Columns

The DATA_QUALITY_DETAILS table includes the following columns:

Column	Description
`guid`	The asset's globally-unique identifier
`asset_type`	The type of asset (for example, AnomaloCheck, SodaCheck, MCMonitor)
`status`	The asset's status (for example, ACTIVE, DELETED)
`source_url`	The source URL for this data quality check
`anomalo_check_type`	Type of Anomalo check
`anomalo_check_category_type`	Category type of the Anomalo check
`anomalo_check_priority_level`	Priority level of the Anomalo check
`anomalo_check_status`	Most recent status of the Anomalo check
`anomalo_check_last_run_completed_at`	Timestamp when the Anomalo check was last run
`anomalo_check_linked_asset_qualified_name`	Qualified name of the asset associated with the Anomalo check
`soda_check_id`	Identifier of the check in Soda
`soda_check_definition`	Definition of the Soda check
`soda_check_evaluation_status`	Most recent status of the Soda check
`soda_check_last_scan_at`	Timestamp when the Soda check was last run
`soda_check_columns`	List of columns associated with the Soda check
`soda_check_assets`	List of assets associated with the Soda check
`mc_monitor_id`	Identifier of the check in Monte Carlo
`mc_monitor_type`	Type of Monte Carlo monitor
`mc_monitor_rule_type`	Rule type of the Monte Carlo monitor
`mc_monitor_priority`	Priority level of the Monte Carlo monitor
`mc_monitor_status`	Most recent status of the Monte Carlo monitor
`mc_monitor_rule_last_execution_at`	Timestamp when the Monte Carlo monitor was last run
`mc_monitor_assets`	List of assets associated with the Monte Carlo monitor
`dq_rule_base_dataset_qualified_name`	Qualified name of the base dataset the rule is applied to
`dq_rule_base_column_qualified_name`	Qualified name of the column the rule is applied to
`dq_rule_dimension`	Dimension of the data quality rule (for example, completeness, accuracy)
`dq_rule_template_name`	Name of the data quality rule template used
`dq_rule_latest_result_computed_at`	Time (epoch) at which the latest rule result was evaluated
`dq_rule_latest_result`	Latest result for the rule's most recent execution
`dq_rule_alert_priority`	Data quality rule's alert priority (for example, LOW, NORMAL, URGENT)
`dq_rule_template_dimension`	Name of the dimension the rule template belongs to
`dq_rule_template_metric_value_type`	Type of metric value returned by the rule (absolute, percentage, time, etc.)
`dq_rules`	Data quality rules the template is attached to

Sample queries

Get all active failed DQ checks

Returns all currently active DQ checks that have a failure result, across all sources (Atlan native, Soda, Monte Carlo, Anomalo).

SELECT
    guid,
    asset_type,
    status,
    -- Anomalo fields
    anomalo_check_type,
    anomalo_check_status,
    anomalo_check_last_run_completed_at,
    anomalo_check_linked_asset_qualified_name,
    -- Soda fields
    soda_check_id,
    soda_check_evaluation_status,
    soda_check_last_scan_at,
    -- Monte Carlo fields
    mc_monitor_id,
    mc_monitor_type,
    mc_monitor_status,
    mc_monitor_rule_last_execution_at,
    -- Atlan native DQ fields
    dq_rule_dimension,
    dq_rule_latest_result,
    dq_rule_alert_priority
FROM gold.data_quality_details
WHERE status = 'ACTIVE'
  AND (
    anomalo_check_status = 'fail'
    OR anomalo_check_status = 'errored'
    OR soda_check_evaluation_status = 'fail'
    OR mc_monitor_status = 'ERROR'
    OR dq_rule_latest_result = 'FAIL'
  )
ORDER BY mc_monitor_rule_last_execution_at DESC NULLS LAST;

Get failed DQ checks by source system

SELECT
    asset_type AS source_system,
    COUNT(*) AS failed_checks
FROM gold.data_quality_details
WHERE status = 'ACTIVE'
  AND (
    anomalo_check_status = 'fail'
    OR anomalo_check_status = 'errored'
    OR soda_check_evaluation_status = 'fail'
    OR mc_monitor_status = 'ERROR'
    OR dq_rule_latest_result = 'FAIL'
  )
GROUP BY asset_type
ORDER BY failed_checks DESC;

Join Atlan-native DQ rules to asset details

Combines Atlan-native DQ rule results with the ASSETS table to show which data assets have failing rules, their owners, and certification status.

SELECT
    a.asset_name,
    a.asset_qualified_name,
    a.connector_name,
    a.certificate_status,
    a.owner_users,
    dq.asset_type AS dq_source,
    dq.dq_rule_dimension,
    dq.dq_rule_alert_priority,
    dq.dq_rule_latest_result
FROM gold.assets a
JOIN gold.data_quality_details dq
  ON a.asset_qualified_name = dq.dq_rule_base_dataset_qualified_name
WHERE a.status = 'ACTIVE'
  AND dq.status = 'ACTIVE'
  AND dq.asset_type = 'DataQualityRule'
  AND dq.dq_rule_latest_result = 'FAIL'
ORDER BY dq.dq_rule_alert_priority DESC;

Joining other DQ source types

The join key depends on the DQ source. For Anomalo checks, use dq.anomalo_check_linked_asset_qualified_name. For Soda and Monte Carlo, the linked assets are stored in array columns (soda_check_assets, mc_monitor_assets) and require unnesting.

Active vs deleted rules

Both active and deleted DQ rules are present in the table (retained for historical traceability). Always filter on status = 'ACTIVE' to see only current state. Deleted rules appear with status = 'DELETED'.

Source tables​

Columns​

Sample queries​

Get all active failed DQ checks​

Get failed DQ checks by source system​

Join Atlan-native DQ rules to asset details​

See also​