Data & Schema Discussions

Resolved! Performance Analysis of Postgress connection

Hi Community,Basically, I am creating a multi-source table using postgres connection, which utilizes the tables already existed in other Incorta schemas. Similar to writing an MV with Union All. I just wanted to understand the performance impact of t...

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?

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