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:

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:

DescriptionBusiness Schema ViewIncorta Analyzer ViewPostgreSQL (Incorta SQL) ViewSpark 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:

DescriptionBusiness Schema ViewIncorta Analyzer ViewPostgreSQL (Incorta SQL) ViewSpark SQL View
Standardized business terminology
Predefined/Standardized row-level formulas and
calculations
Predefined/Standardized aggregated formulas and
calculations
Object data lineage

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.