# Schema Analysis Views

**Note:** Primary attribute views (`vw_datasource_active_attributes`, `vw_datasource_all_attributes`, `vw_datasource_version_all_attributes`) are documented in [Attributes: Integration & API](https://docs.datapancake.com/core-concepts/attribute-metadata/integration-and-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:

```sql
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:

```sql
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.