Data & Schemas Knowledgebase
A solid data foundation leads to analytics. Build that foundation here.
cancel
Showing results for 
Search instead for 
Did you mean: 

Knowledge Base Articles

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 ...

Screen Shot 2022-03-11 at 1.36.46 PM.png

Formula Columns

 An expression can consist of built-in functions, built-in system variables, and other referenceable objects valid for the expression context.

Screen Shot 2022-03-11 at 1.45.08 PM.png

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...

spark.jpg
Tristan by Employee
  • 2700 Views
  • 0 comments
  • 0 kudos

Convert Data Type in Incorta Notebook

As a part of data cleaning in Machine Learning, you may need to convert the data from one data type to the other data type. In this article, you will learn how to use Incorta Notebook to covert the data. After you read data in Incorta Notebook, you c...

suxinji_0-1646338922057.png suxinji_1-1646338971707.png suxinji_2-1646338971735.png
suxinji by Employee Alumni
  • 1039 Views
  • 0 comments
  • 1 kudos

Save Spark ML Model

Introduction  Incorta supports the Machine Learning(ML) model creation process by using Incorta Materialized Views (MV). While you can put the logic of applying the ML model testing and actually use of the ML model for inference in the same MV, the ...

bulb.jpg
suxinji by Employee Alumni
  • 2855 Views
  • 0 comments
  • 1 kudos

Preview Data in an Incorta Notebook

Preview Data in Incorta Notebook In this article, you will learn how to preview data in Incorta Notebook.  Incorta notebook provide methods to let you preview data. using show(), head(), printSchema(), and describe().  incorta.show(df) incorta.hea...

suxinji_0-1646671882423.png suxinji_1-1646671882411.png suxinji_2-1646671882405.png suxinji_3-1646671882427.png
suxinji by Employee Alumni
  • 691 Views
  • 0 comments
  • 1 kudos

Find and Fill Missing Data in Incorta Notebook

Find and Fill Missing Data in Incorta NotebookIn this article, you will learn how to find and fill missing values in Incorta Notebook. Copy below find null value reusable codes.  from pyspark.sql.functions import isnan, when, count, col, lit def colu...

suxinji_0-1646672041325.png suxinji_1-1646672041312.png
suxinji by Employee Alumni
  • 938 Views
  • 0 comments
  • 0 kudos

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...

tile.jpg

Handling Deletes

There are a number of strategies that can be implemented depending on the size of your data and whether the deleted records can be easily identified.

delete.jpg
dylanwan by Employee
  • 1592 Views
  • 0 comments
  • 0 kudos