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?
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?
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
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...
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...
I need to do some reporting on a week-over-week basis. The built-in "ago" and "toDate" functions only support "month", "quarter" and "year".Any thoughts on how to do this inside a formula on a business schema? My last-ditch thoughts:1) create a date ...