This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Introduction
This article discusses how to unlock complex data questions with Spark SQL Views and streamline Data Access with Real-World Examples.
What you should know before reading this article
We recommend that you be familiar with these Incorta ...
Introduction
This article elaborates the steps to convert complex Oracle SQLS or views to Incorta.
What you should know before reading this article
We recommend that you be familiar with these Incorta concepts before exploring this topic further
De...
Question
How do I parse a JSON string from column to flattened structure in Incorta?
Answer
Assuming a Incorta table has a column with JSON string then here is a sample pyspark code which you can use to create a Materialized view in Incorta -
from...
1) First see if the EBS connection is working or not
2) Then open that schema table in Incorta, go to dataset and open the query and try to execute it and see if you see rows .
If you do not see CSV as a valid output then edit the BIP report and click "View List" in the far right. Then in the screen shown navigate to output formats (these are the allowed output formats) - click on csv and save. After this, schedule shows th...
.png "Employee"){kind=icon}
