Data & Schema Discussions

Best Practices for DEV -> PROD migration

I'm about to embark on a change which will impact a whole bunch ( tech term ) of measures from different tables and views in both physical and business schemae. I have a DEV environment - huzzah! - so I intend to make changes there. That brings...

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