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.

  1. They are only available for connectors that are SQL-based and that support row-level expressions in derived fields and custom metrics.
  2. 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?
Amazon Redshift Y
Amazon S3 Y
Apache Drill Y
Apache Phoenix Y
Apache Phoenix Query Server (QS) Y
Apache Solr N
BigQuery Y
Cloudera Impala Y
Cloudera Search N
Couchbase Y
Dremio N
Elasticsearch 7.0 N
Elasticsearch 8.0 N
File Upload Y
HDFS Y
Hive Y
Jira N
MemSQL Y
Microsoft SQL Server Y
MongoDB N
MySQL Y
Oracle Y
PostgreSQL Y
Python N
Real Time Sales N/A
Salesforce N
SAP Hana Y
SAP IQ Y
Spark SQL Y
Snowflake Y
Teradata Y
TIBCO DV Y
Trino Y
File Upload (Upload API) Y
Vertica Y

If a connector supports derived fields, it also supports row-level expressions.

For more information, see: