Resolved! Incremental Loads
Is it possible to set a non-incremental table to load from staging (rather than performing a full load) when an incremental load is run?
Is it possible to set a non-incremental table to load from staging (rather than performing a full load) when an incremental load is run?
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...
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...
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-...
Can we use analytic functions like LEAD or LAG in Incorta Sparksql?