Security & Governance Views

Views for security policy configuration, data dictionary metadata, and transformation settings.

VW_DATASOURCE_ATTRIBUTE_SECURITY

Purpose: Security policy configuration for attributes (row-level security and masking policies).

Contents:

• Security policy settings

• Row-level security configuration

• Masking policy information

• Security metadata (updated by, updated at)

• View names for security policy application

Note: Requires Security Policy Integration product tier.

Use Cases:

• Security policy review

• Compliance auditing

• Security configuration management

• Policy documentation

Example query:

Example Query

SELECT 
    attribute_path,
    polymorphic_attribute_name,
    include_in_row_access_policy,
    column_masking_policy_name,
    view_name
FROM core.vw_datasource_attribute_security
WHERE datasource_id = 'your-datasource-id'
  AND include_in_row_access_policy = TRUE;

---

VW_DATASOURCE_ATTRIBUTE_DATA_DICTIONARY

Purpose: Data dictionary metadata for attributes including descriptions, synonyms, and context.

Contents:

• Attribute and version identification

• Comments and context (attribute, version, data source)

• Data types and sample values

• Synonyms

• Update tracking

Use Cases:

• Data dictionary generation

• Documentation

• AI-powered enhancement

• Metadata management

---

VW_DATASOURCE_ATTRIBUTE_TRANSFORMATION

Purpose: Transformation configuration for attributes including expressions and semantic layer settings.

Contents:

• Transformation expressions

• Null value expressions

• Semantic layer expressions

• Transformation comments

• Configuration metadata

Use Cases:

• Transformation review

• Configuration management

• Documentation

• Integration workflows

---

VW_DATASOURCE_ATTRIBUTE_GENAI

Purpose: Gen AI semantic model configuration for Cortex Analyst integration.

Contents:

• W question categories

• Gen AI semantic model expressions

• Search configuration

• Synonyms and comments

• Semantic model metadata

Use Cases:

• Cortex Analyst integration

• Semantic model configuration

• Gen AI query optimization

---

VW_DATASOURCE_SCHEMA_TRANSFORMATION

Purpose: Schema consolidation and transformation configuration.

Contents:

• Schema consolidation expressions

• Regular expression patterns

• Transformation metadata

Use Cases:

• Schema consolidation review

• Transformation management