Data & Schema Discussions

Table Row Size Limitations

Hi,I couldn't find any limitation about table size. Is there any row count limitation for single table ? And is there any limitation for column unique value ? I mean, when primary key column starts from 1 , what is the max value for it ? 2 B, 3B or...

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)