Data & Schema Discussions

How to connect SQL server via cloud

Hi,How to connect databases like SQL server / Postgre SQL from Incorta cloud.What are the prerequisites for connecting databases from Incorta cloud. Could you please help me. Thanks

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...