Connectors with Case-Sensitive Filter Values
In most connector dialogs, you have the option to apply filters to limit the data that will be loaded into Data Prep Studio.
To do so, locate the column list on the dialog and check the Apply Filter on the header:
Then, for each column, select a filter method from the filter drop down and then enter the filter value in the Filter Value box.
Some data sources require case-sensitive filter values. Refer to the list below to check which data sources have case-sensitive filters.
|
Connector |
Case Sensitive |
|
Active Directory |
no |
|
Amazon EMR Hive |
yes |
|
Amazon Redshift |
yes |
|
Business Objects |
no |
|
Cassandra |
yes |
|
Cloudera Data Platform (formerly Cloudera CDH Hive) |
yes |
|
Cloudera Impala |
yes |
|
DB2 |
yes |
|
Google BigQuery |
yes |
|
Hadoop Hive |
yes |
|
Hortonworks |
yes |
|
Hubspot |
yes |
|
Informix |
yes |
|
HPE Ezmeral Data Fabric (formerly MapR Hive) |
yes |
|
MySQL |
no |
|
NetSuite |
no |
|
Odata |
no |
|
OLEDB |
no |
|
Oracle |
yes |
|
PostgreSQL |
yes |
|
ServiceNow |
yes |
|
SharePoint |
no |
|
Snowflake |
yes |
|
Spark SQL |
yes |
|
SQL Azure |
no |
|
SQL Server |
no |
|
Sybase IQ |
no |
|
Teradata |
yes |
|
Vertica |
yes |
Note: Information on case sensitivity is based on test results, but these results can vary depending on the data source configuration.
© 2025 Altair Engineering Inc. All Rights Reserved.