Schemas
This applies to: Visual Data Discovery
When a 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.
If you'd like to make a default schema available to your users, or hide a schema from your users, update the properties file of your connector. See Select Schemas .
Select Schemas
Control which data source schemas are treated as internal by Data Discovery and are not disclosed to users during source creation. Supported schemas are included in the Schema drop-down selector in the Source Creation tab of the data source configuration.
Add or edit the system.schemas property to the properties file of supported connectors to specify the schemas to use. Restart the connector after making these changes. The schemas you want to make available to users are visible in the Schema drop-down.
| Action | Update the properties file by: |
|---|---|
| Hide a data source schema from users | List the value of all default schemas, and add the value of the schema you want to hide to the system.schemas property. This hides all default schemas and the additional schema. |
| Show a data source schema that is hidden by default to users | List the value of all default schemas in the system.schemas property, except for the default schema you want to include for users. This hides all listed schemas, and displays the omitted default schema in the Schema drop-down. |
Support for this feature by connector 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 7.0 | N/A |
| Elasticsearch 8.0 | N/A |
| File Upload | Y |
| HDFS | Y |
| Hive | Y |
| Jira | Y |
| MemSQL | Y |
| Microsoft SQL Server | Y |
| MongoDB | Y |
| MySQL | Y |
| Oracle | Y |
| PostgreSQL | Y |
| Python | N |
| Real Time Sales | Y |
| Salesforce | Y |
| SAP Hana | Y |
| SAP IQ | Y |
| Spark SQL | Y |
| Snowflake | Y |
| Teradata | Y |
| TIBCO DV | Y |
| Trino | Y |
| File Upload (Upload API) | Y |
| Vertica | Y |