1. Home
  2. Previous Releases
  3. Latest Release
  4. Guides
  5. Concepts
    1. Aggregate filter
    2. Alias
    3. Apache Avro™
    4. Apache Kafka™
    5. Applied filter
    6. Base table
    7. Bookmark
    8. Business schema
    9. Business schema view
    10. Business schema view column
    11. Business schema view formula column
    12. Column
    13. Connector
    14. Dashboard filter
    15. Dashboard folder
    16. Dashboard runtime filter
    17. Data agent
    18. Data alert
    19. Data destination
    20. Data Purge
    21. Data Retention
    22. Date system variable
    23. Distinct filter
    24. Dynamic Field
    25. Expression
    26. External data source
    27. External session variable
    28. Filter expression
    29. Filter expression session variable
    30. Filter option
    31. Formula column
    32. Formula expression
    33. Full load
    34. Global variable
    35. Incorta Analyzer Table
    36. Incorta Analyzer Table column
    37. Incorta Analyzer Table formula column
    38. Incorta Analyzer View
    39. Incorta Analyzer View formula column
    40. Incorta Spark SQL View
    41. Incorta SQL Table
    42. Individual filter
    43. Insight filter
    44. Internal query expression
    45. Internal session variable
    46. Join
    47. Join condition
    48. Join condition column
    49. Join filter
    50. Join filter column
    51. Level based measure
    52. Load filter
    53. Local data file
    54. Local data folder
    55. Materialized View
    56. Materialized View Column
    57. Materialized View Formula Column
    58. Measure filter
    59. Miscellaneous system variable
    60. Multi-Source table
    61. Physical schema
    62. Physical schema table
    63. Physical schema table column
    64. Physical schema table formula column
    65. Physical schema table runtime security filter
    66. PostgreSQL (Incorta SQL) View
    67. Presentation variable
    68. Prompt
    69. Query system variable
    70. Runtime business view
    71. Runtime business view formula column
    72. Runtime security filter
    73. Schema evolution
    74. Session variable
    75. Shared Storage
    76. Upgrade Readiness
    77. Variable
    78. Visualization
  6. Tools
  7. References
  8. Integrations
  9. Data applications
  10. Releases
  11. Incorta Premium

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.