Standard and user defined functions in the creation of Views

Related products: Functions

In the creation of some of our applications we use functions to change data, i.e. upper, lower, etc.

We also use other functions to do things like convert units or coordinate systems or even standardize operator names. What would the process be in FDM to allow that functionality. For example where a temperature is stored in Kelvins (SI) and we want to use a “view” to show it in Fahrenheit.

 

@Stuart Donaldson,
It’s in CDF roadmap for Unit support in Data Models.  I’ll need @Everton Colling  to provide an update on timeline of capabilities.
Jason

PS, I understand the current focus is unit support for time series data points.
 


NewPlanned for development

One of the examples I gave was unit conversion and I am aware that this is on the roadmap. We also use other “standard” functions (Upper, Lower, Substring) as well as “User Defined Functions” in our existing code. Is there any plan to offer that within view definitions in FDM


Beyond unit conversion support, being able to mutate a property value as it is being read from the data store, either by standard or custom functions in a view, is not currently on our roadmap.

Are you more or less looking for the equivalent of a calculated/generated column from the RDBMS world, or something more flexible?

What underlying problem would this functionality address?


I was investigating what it would take to convert some of our existing workflows in our data science workflows into views into the live data. There are some straightforward calculations (endDate-startDate = duration), but there are some instances where we have written user defined functions to do things like normalize operator names and those use regex type expressions. I was just trying to see if Cognite had any of those functionalities out of the box and if not were they on a road map somewhere. From your earlier comment I guess the answer is that they are not on your roadmap so if they are important to us we will raise a requirement and see how that goes.

Thanks for your response