Schema Analysis Views

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

Note: The primary attribute views (vw_datasource_active_attributes, vw_datasource_all_attributes, vw_datasource_version_all_attributes) are fully documented in Attributes: Integration & API. This page covers additional attribute-related views not covered there.

VW_DATASOURCE_ATTRIBUTES

Purpose: Complete attribute metadata including all polymorphic versions and configuration.

Contents:

• Attribute identification (path, name, level, order)

• Polymorphic version information (type, name, status)

• Source schema metadata (data types, sample values, embedded content)

• Destination schema configuration (Snowflake data types, precision, scale, datetime formats)

• Transformation configuration (expressions, null handling, aliases)

• 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

Purpose: 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

Purpose: Simplified catalog of active attributes for data dictionary and documentation.

Contents:

• Attribute paths and names

• Attribute comments and context

• Data source comments and context

• Attribute synonyms

Use Cases:

• Data dictionary generation

• Documentation

• Attribute cataloging

• AI-powered description generation

VW_DATASOURCE_ACTIVE_ATTRIBUTE_VERSION_CATALOG

Purpose: Catalog of active polymorphic versions for data dictionary.

Contents:

• Polymorphic version names

• Data types and sample values

• Alias names

• W question categories

• Comments and synonyms

Use Cases:

• Data dictionary generation

• Version cataloging

• Documentation