Wildcard Case-Sensitive Filters
This applies to: Visual Data Discovery
Many connectors support case-sensitive wildcard filters.
Support for this feature by connector is shown in the following table.
Key:Y - Supported; N - Not Supported; N/A - not applicable
| Connector | Supported? | Notes |
|---|---|---|
| Amazon Redshift | Y | |
| Amazon S3 | Y | |
| Apache Drill | Y | |
| Apache Phoenix | Y | |
| Apache Phoenix Query Server (QS) | Y | |
| Apache Solr | N | Apache Solr connectors support wildcard filters, but case-sensitivity cannot be enforced. Consequently, neither case-sensitive or case-insensitive wildcard filters are supported. |
| BigQuery | 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. |
| Cloudera Impala | Y | |
| Cloudera Search | N | Cloudera Search connectors support wildcard filters, but case-sensitivity cannot be enforced. Consequently, neither case-sensitive or case-insensitive wildcard filters are supported. |
| Couchbase | Y | |
| Dremio | N | |
| Elasticsearch 7.0 | N | Elasticsearch connectors support wildcard filters, but case-sensitivity cannot be enforced. Consequently, neither case-sensitive or case-insensitive wildcard filters are supported. |
| Elasticsearch 8.0 | N | |
| File Upload | Y | |
| HDFS | Y | |
| Hive | Y | |
| Jira | Y | |
| MemSQL | N | |
| Microsoft SQL Server | N | |
| MongoDB | Y | |
| MySQL | N | |
| Oracle | Y | |
| PostgreSQL | Y | |
| Python | Y | |
| Real Time Sales | Y | |
| Salesforce | Y | |
| SAP Hana | Y | |
| SAP IQ | Y | |
| Spark SQL | Y | |
| Snowflake | Y | |
| Teradata | Y | |
| TIBCO DV | N | |
| Trino | Y | |
| File Upload (Upload API) | Y | |
| Vertica | Y |