How to Implement Oracle LISTAGG() Function in Incorta
Learn out to implement the Oracle LISTAGG() function in Incorta
Learn out to implement the Oracle LISTAGG() function in Incorta
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 ...
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...
Your MV ran successfully in Incorta Notebook, but when you tried to validate and save the MV, it failed.
Learn how to leverage MVs to build connections to pull from REST APIs.
Learn how Incorta Data Profiler can help you understand the quality of your data before you bring it into Incorta.
OverviewSolutionCreate GCS Data Source in TAZICreate the destination in TAZI to write to the shared GCS BucketLoad the data from GCS via the Incorta Data Lake Connector Overview This article discusses integrating Incorta Cloud with TAZI Cloud. ...
OverviewWhat is A/B testing?Case StudyData SetTest HypothesesAnalysis in PySparkLoad the data into SparkClean up the dataCalculate the summary of controlled and treatment groupZTest PySpark UDFCall the PySpark UDFConvert the Resulted Array to DataFra...
Introduction When creating visualizations based on multiple source systems, tables must be aligned to achieve a wholistic view of a business. For example, organizations that migrate from one ERP to another align invoice tables from each ERP to see al...
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.
Create analytics dashboards in Incorta with scored data from an outside AI/ML platform.
You can generate the data profiling report using SweetViz from Incorta Notebook. This article shows you step by step instructions.
Learn how to generate profile reports using Pandas Profiling package in Incorta Notebook
Incorta Notebook enables you to write SQL queries to create your data pipeline in Incorta Materalized Views.