(v7) Schemas

Schemas

When a Composer connector supports schemas, it supports namespace, schema, or catalog notation for organizing collections. When schemas are supported, the Source Creation tab of the data source configuration displays a Schema drop-down you can use to select a schema for the data source configuration. 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
File Upload	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
File Upload (Upload API)	Y
Vertica	Y