Data & Schema Discussions

Incorta API Setup

I am trying to set up a python notebook (ipynb) to the Incorta API, however I keep running into a few errors.Following the python specific documentation here, I run into a "no such file in directory" error when I try to pip in the .whl file (screensh...

Resolved! Calculations in Schema

Two questions - 1. Round - according to documentation and per our testing round only works to the nearest whole integer. Anyone find a way to round to two decimals (like you can in Oracle SQL developer or excel?)Ex. 2.5621 in incorta will round to 3 ...

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