Data & Schema Discussions

Move a table/joins from one schema to another

I have a situation where I had to create a key column as a formula column - however, I can't join to a table in another schema with a formula column, so I'm thinking of moving the target table into the same schema as the original table. 1) Is there a...

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.