Schemas

When a Composer connector supports schemas, it supports namespace, schema, or catalog notation for organizing collections. When schemas are supported, the Tables/Indices Tab of the data source configuration displays with the Schema drop-down and the Tables list and you can select a schema for the data source configuration. If schemas are not supported, then the list of collections displays on the Tables/Indices Tab. Elasticsearch has a custom UI for displaying multiple indices.

Support for this feature by Composer connectors 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/A
BigQuery Y
Cloudera Impala Y
Cloudera Search N/A
Couchbase Y
Dremio Y
Elasticsearch 6.0 N/A
Elasticsearch 7.0 N/A
Flat File Y
HDFS Y
Hive Y
MemSQL Y
Microsoft SQL Server Y
MongoDB Y
MySQL Y
Oracle Y
PostgreSQL Y
Presto Y
Real Time Sales Y
SAP Hana Y
SAP IQ Y
Snowflake Y
Spark SQL Y
Teradata Y
TIBCO DV Y
Upload API Y
Vertica Y