Symphony OpenSearch Connector Feature Support

This applies to: Visual Data Discovery

Connector support for specific features is shown in the following table.

Key: Y - Supported; N - Not Supported; N/A - not applicable

Feature	Supported?	Notes
Admin-Defined Functions	N
Box Plots	Y
Custom SQL Queries	Y	If you need to access a BigQuery partition, explicitly include an alias for the built in partition column in your select clause, such as `select *, _PARTITIONTIME as pt from projectId.datasetId.tableId`.
Derived Fields (Row-Level Expressions)	Y
Distinct Counts	Y
Fast Distinct Values	Y
Group By Multiple Fields	Y
Group By Time	Y
Group By UNIX Time	N
Histogram Floating Point Values	Y
Histograms	Y
Kerberos Authentication	N
Last Value	Y
Live Mode and Playback	Y
Multivalued Fields	Y
Nested Fields	Y
Partitions	N/A
Pushdown Joins for Fusion Data Sources	N
Schemas	N/A
Text Search	Y	You can sort keyword searches by Best Match and Most Recent (when you select a preferred time field from the source). Filter your search results by selecting fields in the Filter modal. Select Clear All to clear filtered search results.
TLS	Y
User Delegation	N
Wildcard Filters	Y
Wildcard Filters, Case-Insensitive Mode	N	Case-sensitivity cannot be enforced. Consequently, neither case-sensitive or case-insensitive wildcard filters are supported.
Wildcard Filters, Case-Sensitive Mode	N	Case-sensitivity cannot be enforced. Consequently, neither case-sensitive or case-insensitive wildcard filters are supported.

Important: If you are connecting to OpenSearch versions earlier than 2.x, use the Elasticsearch 7 connector.