Creating Snapshot tables with Incorta
A snapshot table holds the same transactional data as its source system, with additional fields for tracking the snapshot date.
Knowledge Base Articles
How to output a csv file for schema.table.column details
This python script takes an unzipped tenant export file or an unzipped schema export file and produces a csv file which has all the table column details like datatype, etc... in a schema. This csv file can then be imported into Incorta and a dashboar...
Record Level Security
Learn about how Incorta allows you to restrict user data access in the Incorta Direct Data Platform.
Modeling Schemas, Tables, and Joins
The purpose of this article is help users understand data modeling concepts and best practices in Incorta .
Data Validation Tips
How to validate data between a Incorta report and my legacy BI report.
Modeling Schemas, Tables, and Joins
The purpose of this article is help users understand data modeling concepts and best practices in Incorta.
Date Dimension
Date is a common dimension used in most application deployments. It is primarily used to roll up data so it can be viewed across a broad time range, facilitating trend analysis.
Organizing Business Schemas
Introduction Business Schemas are a useful way to group content for business users that can be used in one or more dashboards. They also remove the need to understand all of the underlying data relationships even when they span several source data ...
Formula Columns
An expression can consist of built-in functions, built-in system variables, and other referenceable objects valid for the expression context.
Performance of Materialized Views (MV)
Introduction Incorta Materialized Views are a powerful way to enrich data contained in Incorta tables. Leveraging Spark's processing engine, Materialized Views (MVs) can be defined to introduce enrichments and advanced analytics to reshape your dat...
Regular vs. Analyzer Views
Introduction Incorta offers two types of business schema views- regular and analyzer (Runtime or Incorta) views and both are useful to support various use cases. What you should know before reading this article We recommend that you be familiar with...
Using Formula Columns in Business Views
Introduction A formula column contains an expression that, depending on the expression and the expression context, returns a scalar or an array of values of a specific data type. An expression can consist of built-in functions, built-in system variab...
