Level-Based Aggregate in Incorta
Compare the discounts given in different area, business units and at the different levels of details.
Knowledge Base Articles
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?
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.
Fuzzy Text Matching in PySpark UDF
String matching is a very common problem in business. You will learn how to perform address matching using FuzzyWuzzy in Incorta.
Convert R DataFrame into Spark DataFrame
use as.DataFrame()and createDataFrame()to convert R data frame into Spark DataFrame.
Convert Spark DataFrame into R DataFrame
Use collect() to collect the data from Spark DataFrame to R DataFrame.
Interactive Analysis using Incorta Notebook and SparkR
Run SQL queries to do interactive analysis in Incorta Notebook with SparkR.
How to handle Date Time in Spark MV
We would like to get the current hour, how can we get it in Spark SQL? We also need the time as of one hour ago, how do we do that?
