Data & Schema Discussions

Resolved! Use of same data agent on a cluster clone ( DEV )?

[edit] 2022.9.0 in both clusters I have a data agent set up and working for a PROD environment. We're now in the process of standing up DEV - which is a clone of PROD.I assume I need to generate a new auth file and add it on the data agent server, ...

CASE Statement use in Select Statement

Dear All,Can we Use CASE Statement in SQL Query while "Creating View" with "SQL Query"...i.e...SELECT v.FianaceYear, v.FinanceMonth ,FT.FinanceType_Eng, M.Description_en,CASE WHEN v.tContractStatusId =3 and v.IsWriteOff IS NULL THEN 'Termianted'WHEN ...

Connect Incorta on-prem to web API

How can I connect Incorta on-prem to a source via web APIs?I don't see a relevant connector in the list available in my Incorta instance (list attached for reference)

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?