Schema Analysis Views

Views for analyzing attributes, polymorphic versions, and schema evolution.

Note: Primary attribute views (vw_datasource_active_attributes, vw_datasource_all_attributes, vw_datasource_version_all_attributes) are documented in Attributes: Integration & API. This page covers additional attribute-related views.

VW_DATASOURCE_ATTRIBUTES

Complete attribute metadata including all polymorphic versions and configuration.

Contents: Attribute identification, polymorphic version information, source schema metadata, destination schema configuration, transformation configuration, semantic layer configuration, security policy settings, code generation flags, Gen AI semantic model configuration

Use cases: Complete attribute metadata access, configuration review, integration workflows, code generation input

Example Query:

SELECT 
    attribute_path,
    polymorphic_attribute_name,
    source_data_type,
    data_platform_data_type,
    include_in_code_gen,
    transformation_expression
FROM core.vw_datasource_attributes
WHERE datasource_id = 'your-datasource-id'
  AND version_status = 'active'
ORDER BY attribute_path;

VW_DATASOURCE_POLYMORPHIC_ATTRIBUTES

Attributes that have multiple active polymorphic versions (polymorphic attributes).

Contents: Attributes with multiple active versions, polymorphic version count, attribute identification

Use cases: Identifying polymorphic attributes, polymorphism analysis, data quality assessment

Example Query:

SELECT 
    datasource_name,
    attribute_path,
    polymorphic_versions
FROM core.vw_datasource_polymorphic_attributes
WHERE datasource_id = 'your-datasource-id'
ORDER BY polymorphic_versions DESC;

VW_DATASOURCE_ACTIVE_ATTRIBUTE_CATALOG

Simplified catalog of active attributes for data dictionary and documentation.

Contents: Attribute paths/names, attribute comments/context, data source comments/context, attribute synonyms

Use cases: Data dictionary generation, documentation, attribute cataloging

VW_DATASOURCE_ACTIVE_ATTRIBUTE_VERSION_CATALOG

Catalog of active polymorphic versions for data dictionary.

Contents: Polymorphic version names, data types, sample values, alias names, W question categories, comments, synonyms

Use cases: Data dictionary generation, version cataloging, documentation

Note: These catalog views are not explicitly defined in the codebase; may be referenced but not created.