Data & Schema Discussions

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

Resolved! Next Run Time stamp - Strikethrough

Hi,I'm trying to schedule a schema load and the next run timestamp is strike-through.The schedule never triggers as well.Any help would be appreciated.Thanks