VW_DATASET_TABLES

Overview

VW_DATASET_TABLES provides a comprehensive view of every metadata table and view registered across all data sources in your Validatar environment. Each row represents one table or view and includes its identity, trust scores, custom field values, and table-level profile metrics.

This is the primary view for building reports on data asset inventory, trust score dashboards, and metadata governance workflows.

Schema

Identity Columns

Date Columns

Trust Score Columns

Impact Rating Columns

Custom Field Columns

Columns prefixed with CUSTOM_ contain values from custom metadata fields configured in your environment. Common examples:

The full set of custom columns depends on your environment's custom field configuration.

Profile Columns

Relationships

VW_DATASET_TABLES
    │
    ├── TABLE_ID → VW_DATASET_COLUMNS.TABLE_ID (one-to-many)
    ├── TABLE_KEY → VW_DATASET_TESTS.TEST_PRIMARY_METADATA_LINK_OBJECT_KEY
    ├── TABLE_KEY → VW_DATASET_METADATA_OBJECTS.OBJECT_KEY
    ├── DATA_SOURCE_ID → VW_DATASET_TEST_EXECUTIONS.TEST_DATA_SOURCE_ID
    └── DATA_SOURCE_ID → VW_SECURE_USER_DATA_SOURCE_ACCESS.META_DATA_SOURCE_ID

Example Queries

Tables with Trust Scores Below Target

SELECT
    DATA_SOURCE_NAME,
    FULL_PATH,
    TRUST_SCORE,
    IMPACT_RATING,
    IMPACT_RATING_TARGET_TRUST_SCORE,
    TRUST_SCORE_BADGE
FROM REPOSITORY.VW_DATASET_TABLES
WHERE TRUST_SCORE_BADGE = 'Below Target'
ORDER BY TRUST_SCORE ASC;

Find Tables by Subject Area

SELECT
    FULL_PATH,
    CUSTOM_SUBJECT_AREA,
    CUSTOM_TABLE_TYPE,
    TRUST_SCORE,
    PROFILE_RECORD_COUNT
FROM REPOSITORY.VW_DATASET_TABLES
WHERE CUSTOM_SUBJECT_AREA = 'Finance'
ORDER BY FULL_PATH;

Tables Not Profiled in 30+ Days

SELECT
    DATA_SOURCE_NAME,
    FULL_PATH,
    DATE_LAST_PROFILED,
    DATEDIFF(day, DATE_LAST_PROFILED, CURRENT_DATE) AS DAYS_SINCE_PROFILED
FROM REPOSITORY.VW_DATASET_TABLES
WHERE DATE_LAST_PROFILED < DATEADD(day, -30, CURRENT_DATE)
    OR DATE_LAST_PROFILED IS NULL
ORDER BY DATE_LAST_PROFILED ASC NULLS FIRST;

Data Source Inventory Summary

SELECT
    DATA_SOURCE_NAME,
    TABLE_TYPE_NAME,
    COUNT(*) AS OBJECT_COUNT,
    AVG(TRUST_SCORE) AS AVG_TRUST_SCORE,
    SUM(CASE WHEN TRUST_SCORE_BADGE = 'Below Target' THEN 1 ELSE 0 END) AS BELOW_TARGET_COUNT
FROM REPOSITORY.VW_DATASET_TABLES
GROUP BY DATA_SOURCE_NAME, TABLE_TYPE_NAME
ORDER BY DATA_SOURCE_NAME;

Databricks Notes

• Replace DATEADD(day, -30, CURRENT_DATE) with DATE_ADD(CURRENT_DATE(), -30)
• Replace DATEDIFF(day, col, CURRENT_DATE) with DATEDIFF(CURRENT_DATE(), col)
• NULLS FIRST / NULLS LAST works the same in both engines