Concepts → Runtime Business View
About a runtime business view
A Runtime Business View conceptually describes the types of views that you can create in a Business Schema.
There types of runtime business views are:
- Business Schema View
- Incorta Analyzer View
- PostgreSQL (Incorta SQL) View
- Spark SQL View (available starting 2024.7.x)
These view types —business schema view, Incorta Analyzer View, PostgreSQL (Incorta SQL) View, and Spark SQL— can exist within the same business schema. You can create a business schema view with the Business Schema Designer, an Incorta Analyzer View with the Analyzer, a PostgreSQL (Incorta SQL) View with the PostgreSQL Query Editor, and the Spark SQL with the Spark Query Editor.
From a conceptual perspective, a runtime business view represents a logical view of a subset of data within related physical schema tables. The following table describes how:
Description | Business Schema View | Incorta Analyzer View | PostgreSQL (Incorta SQL) View | Spark SQL View |
---|---|---|---|---|
Narrow and curate the columns exposed the underlying physical schema tables | ✔ | ✔ | ✔ | ✔ |
Filtering the number of individual rows | ✔ | ✔ | ✔ | |
Filtering the aggregated results for a given measure | ✔ | ✔ | ✔ |
A runtime business view also introduces a semantic layer. The following table describes how:
Description | Business Schema View | Incorta Analyzer View | PostgreSQL (Incorta SQL) View | Spark SQL View |
---|---|---|---|---|
Standardized business terminology | ✔ | ✔ | ✔ | ✔ |
Predefined/Standardized row-level formulas and calculations | ✔ | ✔ | ✔ | ✔ |
Predefined/Standardized aggregated formulas and calculations | ✔ | ✔ | ✔ |
You can view the data lineage of runtime business views in the Data Lineage Viewer v2 that displays a diagram with the entities referenced in the runtime business view (upstream lineage) and entities where the runtime business view is referenced (downstream lineage). Additionally, you can view the data lineage per column or formula column (as applicable) in the business view.
This feature is not supported for Spark SQL Views as of 2024.7.x.