Knowledge Base Articles
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!
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...
Create an ODBC Connection to Incorta
Applies to: Any Incorta version On-Prem/Cloud Question: How to configure an ODBC connection?Unable to connect to Incorta using ODBC Overview: Any program that uses Open Database Connectivity (ODBC) to connect to a remote database needs a way to iden...
Multi-Source Table Design
Struggling to wrangle data from multiple sources? Learn about how and when to combine similar data points from disparate sources with three different approaches using the Incorta Platform.
Variables
Read this article to review variable types in Incorta, when you use them, and best practices around using variables.
Incorta Data Agent
Learn how the Data Agent allows you to connect data sources behind your firewall to the Incorta Cloud
How to connect to Oracle Cloud (Autonomous) Database from Incorta On-Prem
A simple guide to getting connected to Oracle Cloud (Autonomous) Database
ML with IRIS data set using Incorta
This article shows how to use a classification Machine Learning (ML) algorithm on the Iris Flower data set. It first creates a model based on a training data set and then scores the the test data set and gives the prediction of the flower based on th...
Supporting Slowly Changing Dimension (SCD) Type2 dimension in Incorta
A slowly changing dimensions (SCD) is a dimension that stores and manages both current and historical data over time.
How to add a Custom Database Connection to Incorta
Setup to a connection a wide variety of connectors for SQL-based, Cloud-based, file system-based sources.
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.
Connecting to Data
Introduction Incorta has a wide variety of external data source connectors. A connector specifies how Incorta can connect to an external system or application , ingest data and publish to destinations. Incorta includes many out-of-the-box connector...
