Composer 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 Composer equivalent) to extend your data analytics in Composer. Examples of this might be functions available within your data store either natively or as user-defined functions. In such situations, you can leverage Composer administrator-defined functions to expose this capability throughout Composer.
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).
Support for this feature by Composer connectors is shown in the following table.
Key: Y - Supported; N - Not Supported; N/A - not applicable
|Apache Phoenix Query Server (QS)||Y|
|Microsoft SQL Server||Y|
|Real Time Sales||N/A|
If a connector supports derived fields, it also supports row-level expressions.
For more information, see: