Data & Schemas Knowledgebase

MV Assistant Tool

The MV Assistant makes suggestions that make your MVs run faster.

Incorta MetaData is failing with Table 'incortametadata.CATALOG_LINK' doesn't exist

Symptoms After an upgrade, there is a possibility that incortaMetaData schema would fail with the following error: com.incorta.api.exceptions.DataException: INC_03070000: Failed retrieving sample data from [_IncortaMetadata] with properties [[increm...

Saving a Pandas DataFrame as a Materialized View (Convert to Spark)

Quickly save Pandas DataFrames as materialized views without manually defining each column's data type and function. These simple functions allow the switch between Spark and Pandas more efficiently.

Delta Sharing

Delta Sharing is a simple REST protocol that securely shares access to part of a cloud dataset. Learn more here!

Establishing an OAuth connection for CData SalesForce Connector

With the Custom CData Connector, you can use a CData JDBC driver to ingest data from any of the over 200 databases, applications, and object stores supported by CData JDBC drivers. In this article, we are concerned with establishing a connection to...

Incorta On-premises with DataRobot Batch Prediction API

Overview This article is one of the series of articles about Incorta and DataRobot integration via DataRobot APIs. In this article, we assume that Incorta is running in an on-premises environment. The DataRobot Batch Prediction API assumes that t...

Move Data from Dev/Test to Prod

Introduction It is a best practice to test configuration in the development/test environment(s) before moving it to production. In some cases, production data is loaded into the Dev/Test environments for validation purposes as well. This article di...

How to Implement Oracle LISTAGG() Function in Incorta

Learn out to implement the Oracle LISTAGG() function in Incorta

Query physical schema data from PySpark using the incorta_sql() function

Introduction The incorta_sql() function lets you directly query physical schema data in a PySpark MV without going through the old and cumbersome way. What you need to know before reading this article Previously, you could use spark.sql() to query ...

Query business schema data from PySpark using the incorta_sql_pg() function

Introduction The incorta_sql_pg() function lets you directly query business schema data in a PySpark MV without going through the old and cumbersome way. What you need to know before reading this article Previously, you could use spark.sql() to quer...

Incorta MV execution succeeds in the Incorta Notebook but fails to save

Your MV ran successfully in Incorta Notebook, but when you tried to validate and save the MV, it failed.

Deploy Incorta Data Profiler

OverviewDeployment OverviewSample DataInstallationStep 1: Install the DataPrepAPI Wheel FileStep 2: Upload the Data_Profiler_Datasets data filesStep 3: Import SchemaStep 4: Import DashboardStep 5: Add Session Variables (Optional)Related Materials Ove...

Customize Incorta Data Profiler

IntroductionCalling DataProfiler APIBasic Table InfoSummary TableCorrelation TableFrequency TableHistogram TableIncremental LoadRelated Materials Introduction This article will show you how to adjust the output of the Incorta data profiler with diffe...