Skip to main content
Version: 0.0.39

Hierarchies in Datasources

The Hierarchies feature within Datasources is pivotal for structuring data analysis by forming hierarchical relationships rooted in datasource attributes and semantic constructs. This guide explains how hierarchies are generated and used within Lakehousecat for effective data query responses and interaction.

Understanding Hierarchies​

Hierarchies are integral to the semantic layer, providing a robust framework for data analysis. They are automatically generated during semantic layer operations, helping users leverage structured data insights directly from datasources.

Key Features​

  • Hierarchical Structures: Derived from datasource interactions, hierarchies present logical paths for analyzing data contextually.
  • Response Facilitation: Enable the system to efficiently respond to user queries by organizing data hierarchically.

Hierarchy Management​

While the hierarchies generated by the system are essential for data analysis, users can intervene to refine or adjust these structures:

Deactivation​

  • Purpose: Disable hierarchies that are redundant or misaligned with analytical needs.
  • Considerations: Carefully evaluate the relevance of each hierarchy before deactivation to ensure the integrity of the data model.

Adding Hierarchies​

  • User Contribution: Users can introduce new hierarchies to better align data structures with specific analysis requirements.
  • Locking Mechanisms: Protect critical hierarchies by locking them during the modeling phase, preventing unintentional modifications.

Best Practices​

  • Initial Hierarchies Evaluation: Preserve initial hierarchies unless significant reasons for modification exist.
  • Evaluate Hierarchical Logic: Validate that existing or new hierarchies support the broader analytical goals before making changes.
  • Lock Essential Structures: Use locking features to maintain essential hierarchies, ensuring consistency in data analysis.

Conclusion​

Hierarchies in Lakehousecat Datasources provide a structured method of organizing data interaction, enhancing the system's ability to deliver precise analytical insights through semantic logic. By effectively managing hierarchies, users can improve data analysis and empower informed decision-making within their organizations.