Data & Schema Discussions

Why is my Pyspark code output different from the output loaded into the Incorta analyzer?

Hey guys,Newbee here - I wrote some pyspark code and it ran perfectly with the output i wanted but in the incorta analyzer the data populates differently. Any tips to resolve this issue?

Incorta joins other than the inner joins (=)

Hi everyone !A quick question, how can two tables be joined as a union using the Joins section in Schemas ? If there's another alternative to union two tables, without using Materialized views, i'd be happy to hear about it too.Thank you !

Resolved! Load Data into Incorta using external sources

Hi everyone !Is there any chance we can push data into Incorta Schema/Business schema using python / jupyter notebooks ?I know we can read data from incorta, but just want to know if that's bidirectional.Thank you !

Resolved! Update and add values in a materialized view using incremental load

Hi all,I have quite a big MV that's takes about and 1.5 hours to finish loading, I've tried using incremental load but it doesn't seem to update values only append. I want to know if there's a way to keep data up till a certain date, and everything a...

Resolved! Time not matching

I time in DB column is coming as it is in the incorta table from query level. I executed the same script in DB and Schema level and the time was matching. Once the tables are loaded in incorta I explored the schema and found out that the time in DB w...