Views

System views for monitoring, querying, and integrating with DataPancake metadata and operations.

Overview

System views expose metadata about data sources, attributes, scans, configurations, and operations. All views are in the core schema. Most views accessible via app_public role; some require app_admin.

View Sections

• Schema Summary Views - Data source overview, scan history, configurations, billing events, audit logs

• Schema Analysis Views - Attribute metadata, polymorphic version tracking, schema evolution

• Security & Governance Views - Security policies, data dictionary, transformations, Gen AI semantic models

• Integration & Code Generation Views - Semantic layer, foreign keys, generated SQL code, Cortex Analyst integration

• Monitoring & Diagnostic Views - Integration process tracking, access control

Note: Primary attribute views (vw_datasource_active_attributes, vw_datasource_all_attributes, vw_datasource_version_all_attributes) are documented in Attributes: Integration & API.

Quick Reference

Schema: All views in core schema (e.g., core.vw_datasources)

Schema Summary: vw_datasources, vw_datasource_scans, vw_datasource_scans_in_process, vw_datasource_scan_configurations, vw_datasource_scan_errors, vw_datasource_scan_procedure_calls, vw_datasource_billing_events, vw_datasource_product_tier_audit_log

Schema Analysis: vw_datasource_attributes, vw_datasource_polymorphic_attributes (primary attribute views documented in Attributes: Integration & API)

Security & Governance: vw_datasource_attribute_security, vw_datasource_attribute_data_dictionary, vw_datasource_attribute_transformation, vw_datasource_attribute_genai, vw_datasource_schema_transformation

Integration & Code Generation: vw_datasource_active_attributes_semantic_layer, vw_datasource_active_attributes_gen_ai_semantic_model, vw_datasource_relationships_gen_ai_semantic_model, vw_datasource_queries_gen_ai_semantic_model, vw_datasource_foreign_keys, vw_datasource_relationships, vw_datasource_sql_code, vw_datasource_sql_code_summary

Monitoring & Diagnostic: vw_integration_process, vw_access_control_user_privileges (app_admin only)