Data & Schema Discussions

MV Incremental Load

Can anyone confirm that get_last_refresh_time() that is referenced in the link below is meant to be equivalent to "?" for SQL MV's? This function only returns 0 for me. https://community.incorta.com/t5/dashboards-analytics/creating-materialized-view-...

Resolved! Can we use analytic functions like LEAD or LAG in Incorta Sparksql?

Can we use analytic functions like LEAD or LAG in Incorta Sparksql?

Resolved! Incorta Table load fails for a large Oracle table with 'Snapshot too old' error

While trying to load an Incorta table with nearly 1 billion rows from Oracle the load fails with 'ORA-01555 ERROR MESSAGE “SNAPSHOT TOO OLD”' error.

Resolved! Scheduled Schema Loads

Is there a way to trigger a schema load when another one finishes? I know it is generally best practice to put tables that need to be loaded together into the same schema. However, for security/access reasons I need keep these tables in separate sche...

Sample Data

As a fresh rookie to Incorta, I have been working through some of the documentation and training and am trying to work with some of the sample data that is loaded to a tenant with the Sample data. Unfortunately, I do not have CMC access yet, so I ca...