Data & Schemas Knowledgebase

Exploratory Data Analysis using SweetViz and Incorta Notebook

You can generate the data profiling report using SweetViz from Incorta Notebook. This article shows you step by step instructions.

Generate profile reports using Pandas Profiling package within Incorta Notebook

Learn how to generate profile reports using Pandas Profiling package in Incorta Notebook

Screen Shot 2022-05-08 at 3.45.21 PM.png

Run SQL Queries from PySpark and Incorta Notebook

Incorta Notebook enables you to write SQL queries to create your data pipeline in Incorta Materalized Views.

Screen Shot 2022-04-19 at 10.30.07 AM.png

Screen Shot 2022-04-18 at 10.32.27 AM.png

Level Based Aggregate using Incorta Materialized View

Overview This is the second part of the articles that discusses level-based measures. The essential part of a level based measure is an aggregation that is calculated at a specific level of detail with a result can be repeated at the lower level ...

Level-Based Aggregate in Incorta

Compare the discounts given in different area, business units and at the different levels of details.

Install the Python Package in Incorta Cloud

Learn how to install the python package in Incorta Cloud!

Data Alert for Current Running Job

An Incorta job runs for more than 40 hours and none of us noticed until business users contacted us and asked why they do not see the updated data from the dashboard. Incorta provided us the Long Spinning Job Alert before. Why does it not work?

Calculating Z-Score with Incorta

Have you ever needed to calculate a Z-score?

Create a Kafka Data Source

This article will review how to create a Kafka Data Source.

JSON - Avro Extractor Tool and Configuring Kafka Data Sources

This article provides more information about the Avro Extractor tool that generates an Avro file from a provided JSON file.

Kafka Overview

Apache Kafka is a distributed publish-subscribe messaging system that can handle a high volume of data and enables you to pass messages from one end-point to another.

How Joins Work in Incorta

Understanding Incorta Joins: A Comprehensive Guide In data analytics, effectively linking and analyzing data from diverse sources is crucial for deriving actionable insights. Incorta’s advanced join capabilities enable businesses to seamlessly integr...

Configure an Incorta v4 Cluster using the CMC step by step

Prerequisites: CMC instance is up and runningNode agent instance(s) are up and runningZookeeper is up and running (either shipped with incorta or a clustered zookeeper)An empty schema is created (either oracle metadata or MySQL metadata)A common/shar...

Incorta Cloud with DataRobot GCP Batch Prediction API

Use Incorta to prepare data and create an ML model in DataRobot. You can then send the data as part of an Incorta data pipeline to DataRobot for making predictions. The DataRobot Batch Prediction API can be called from an Incorta MV to complete the prediction job.