Admin-Defined Functions
This applies to: Visual Data Discovery
Symphony 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 Symphony equivalent) to extend your data analytics in Symphony. Examples of this might be functions available within your data store either natively or as user-defined functions. In such situations, you can leverage Symphony administrator-defined functions to expose this capability throughout Symphony.
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 connector is shown in the following table.
Key:Y - Supported; N - Not Supported; N/A - not applicable
Connector | Supported? |
---|---|
Y |
|
Y |
|
Y |
|
Y |
|
Y |
|
N |
|
Y |
|
Y |
|
N |
|
Y |
|
N |
|
N |
|
N |
|
Y |
|
Y |
|
Y |
|
N |
|
Y |
|
Y |
|
N |
|
Y |
|
Y |
|
Y |
|
N |
|
N/A |
|
N |
|
Y |
|
Y |
|
Y |
|
Y |
|
Y |
|
Y |
|
Y |
|
Y |
|
Y |
|
Y |
If a connector supports derived fields, it also supports row-level expressions.
For more information, see:
Comments
0 comments
Please sign in to leave a comment.