Data & Schema Discussions

Spark Sql Execution Plan

Is there any way to get the Spark execution plan in an MV when selecting Spark SQL? I know I can take the below approach, but I prefer to do this in Spark SQL and not have to rebuild the Spark SQL queries. %pysparkdf = read("EBS_PARTY_COMMON.HZ_PARTI...

Data source in Incorta

HII need assistance in setting up a data source in Incorta. I have a colleague who updates an Excel file monthly on his device. I would like to know the best way to use this file as a data source in Incorta, allowing my colleague to continue updating...

Resolved! PySpark log stdout

I am building materialized view with Python Spark and since I am very new to Python I am struggling a little bit. In order to do some debugging I would like to be able to log some hints from the code, most likely in stdout (but I will be happy with a...

Connection to Enovia (Matrix Query Language)

My company uses a Product Lifecyle Management software called Enovia. We want to extract some product design review information to report in Incorta.Does Incorta have the capability to connect to databases that use a Matrix Query Language?3DEXPERIEN...

Incorta Regex formula

Hi, I am trying to get regex to work in a materialized view but keep running into "undefined function" errors Is there something wrong with my format? SELECT Name, UniversalId, Item_Description, REG...