Data & Schema Discussions

Formula column expression editor - what determines whether a table shows up?

I'm trying to build a formula column. Using the lookup() function, but I don't suspect that's meaningful to this question. - The schema has 45 tables in it. Only 9 of them show up in the expression editor's dialog box ( left side ) - Of the 45 ...

Unable to load SharePoint Online List data

I have setup OAuth connection with SharePoint Online and configured Datasource using it. While testing connection it shows Successful.But when I try to load data in Schema table, it only fetching metadata/columns but not the records.In Load status, N...

Incremental Loading - how do you use it after 5.1?

Hello - we are in the process of upgrading from 5.0 to 5.2 and have noticed a new requirement in 5.1. Changing a 'Key' column in a physical table now requires a full load of that table. We use incremental loads to load daily snapshots from source s...

Incorta against No SQL database

Hi - Has anyone tried Incorta schemas on NO SQL database like Mongo DB? can we use Incorta to pull JSON format data ?

Supporting variables within sql query

Does Incorta have any plans to support variables inside the SQL query?