Attribute Metadata

Overview

Attributes are discovered during scanning and serve as the metadata foundation for generating Dynamic Tables and Views. DataPancake discovers every attribute path at any nesting depth, including:

• All nested structures (any depth)
• Embedded/stringified JSON (recursively parsed)
• Polymorphic variations (same path, different data types)

Key DataPancake Behavior: When an attribute is first discovered, DataPancake proactively creates all 7 polymorphic versions immediately. Only versions matching discovered data types are activated (VERSION_STATUS = 'active'). Inactive versions remain ready for future activation, enabling seamless schema evolution.

---

Documentation

• Attribute Discovery - Discovery process and embedded JSON handling
• Attribute Types - Discovered, Schema, and Virtual attributes
• Polymorphic Versions - The 7 polymorphic variations and proactive creation
• Attribute Metadata Fields - Complete field reference
• Arrays & Nested Structures - Array handling and relationships
• Attribute Lifecycle - Creation, versioning, and schema evolution
• Attributes in Code Generation - How attributes become SQL columns
• Integration & API - Stored procedures and views

---

Quick Reference

Attribute Types:

• 'Discovered' - Found during scanning (ATTRIBUTE_CREATE_TYPE = 'Discover')
• 'Schema' - Created from schema samples (ATTRIBUTE_CREATE_TYPE = 'Schema')
• 'Virtual' - User-created via UI/API

The 7 Polymorphic Versions (created proactively for every attribute):

1. str → {name}_str
2. int → {name}_int
3. float → {name}_float
4. bool → {name}_bool
5. object → {name}_object
6. array_primitive → {name}_array_primitive
7. array_object → {name}_array_object

Key Tables:

• core.datasource_attribute - Core attribute metadata
• core.datasource_attribute_polymorphic_version - Version-specific metadata