Data & Schema Discussions

Data Agent w/ multiple Incorta environments

I'm working out the best way to create and maintain a DEV environment. One factor is the source data is ingested via a data agent. If I set up a new cluster ( cloud admin cluster ) do I need to install a second data agent on the source box? I thi...

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