Data & Schema Discussions

Schema Model Update error question

TL/DR - What's going on under the hood w/ schema model sync and update? I'm looking at a physical schema which loads daily - and looks to have been loading successfully for over a month ( for easier viewing of when it last failed please vote for htt...

Dynamic SQL

Is there an option to build a query using variables. I have the table names in a lookup table and i would like to use that to build dynamic SQL in Incorta. Is there such an option available in Incorta?

How to force stop Model update syncing

Hi,How to force stop 'Model Sync' for a schema. There is script available to force stop a schema load, but is there such script or CLI command to force stop schema Model sync? Thanks,Harsha

Can not create/calculate field as it may contain a deleted data column.

I am trying to use a lookup function in a formula field and I get this message:"Can not create/calculate field [schema table and field name here ] as it may contain a deleted data column."The details don't provide any additional value.The columns I a...

Any advice on setting up a SharePoint data source connector in Incorta is welcome

Hello Incorta Community,Does anyone have any advice or guidelines in setting up a SharePoint data source connector to Incorta? For example, what service account user credentials are needed? Read only good enough? Would you recommend "Basic authentica...