Zoomdata provides a set of functions that you can use in expressions to build derived fields or custom metrics. However, you may want to use your own functions (for which there is no Zoomdata equivalent) to extend your data analytics in Zoomdata. Examples of this might be functions available within your data store either natively or as user-defined functions. In such situations, you can leverage Zoomdata administrator-defined functions to expose this capability throughout Zoomdata.
Administrator-defined functions allow your organization to create functions at the connector level from SQL strings. These functions can be referenced later in data source configurations that use the connector.
Currently, the following limitations exist for administrator-defined functions.
- They are only available for connectors that are SQL-based and that support row-level expressions in derived fields and custom metrics.
- They are only available for functions that perform row-level operations, and not aggregation operations (for example, standard deviation or rank).
For a list of the connectors that support administrator-defined functions and derived fields, see Connector Feature Support. If a connector supports derived fields at the link, it also supports row-level expressions.