DataPancake™ Docs
  • DataPancake™ Documentation
  • Overview
    • What is DataPancake™?
    • Understanding the Challenges of Semi-Structured Data
  • Getting Started
    • How to Guides (Script Builder)
      • Admin Guides
        • How to Purchase & Install DataPancake
        • How to Manage Access to DataPancake
        • How to Grant DataPancake Account & Cortex AI Privileges
        • How to Add Warehouses to DataPancake
      • Data Source Guides
        • How to Create a Single DataPancake Data Source (Script Builder)
        • How to Create Multiple DataPancake Data Sources (Script Builder)
      • Alert Guides
        • How to Create Schema Drift Alerts (Script Builder)
    • Application Overview
      • Data Source Overview
      • Manage Data Source
      • Manage Scan Configuration
      • Scan Data Source
      • Data Source Attributes
      • Dynamic Table SQL
      • Manage Warehouse
  • Topics
    • Warehouses
    • Data Sources
    • Scan Configurations
    • Attributes
    • Scan Processing
    • Views
    • Attribute Consolidation
    • Pricing
  • DEVELOPMENT
    • Release Notes
Powered by GitBook
On this page
  • Schema Summary
  • Schema Analysis
  1. Topics

Views

Schema Summary

  • VW_DATASOURCES

  • VW_DATASOURCE_BILLING_EVENTS (created when the product tier has been upgraded for a data source or scan has been performed in a given month.)

  • VW_DATASOURCE_PRODUCT_TIER_AUDIT_LOG (created when the product tier has changed for a particular data source)

  • VW_DATASOURCE_SCANS

  • VW_DATASOURCE_SCANS_IN_PROCESS

  • VW_DATASOURCE_SCAN_CONFIGURATIONS

  • VW_DATASOURCE_SCAN_ERRORS


Schema Analysis

  • VW_DATASOURCE_ALL_ATTRIBUTES (includes all polymorphic versions regardless of VERSION_STATUS ('active' or 'inactive'))

  • VW_DATASOURCE_VERSION_ALL_ATTRIBUTES (includes version information to monitor schema evolution/drift.)

Last updated 11 months ago