(v24) Visualize Schemas and Joins

Visualize Schemas and Joins

This applies to: Visual Data Discovery

Visualize the fields and tables in schemas included with your connection, and created by other users. Add relationships as needed. Visualize joins in your data sources.

When you create joins in a source, you can visualize and update your joins as well. See Fuse Data Sources.

Edit and View Relationships in Schemas

Users with appropriate permissions can view and edit the relationships using the Relationship tab for a supported connection. Select a schema from the list in the drop-down, then make and save any additions to the relationships as needed.

View or edit a schema for a connection

1. Open a supported connection and navigate to the Relationship tab. A work area opens you can use to navigate among the tables and relationships of a selected schema.

2. Select an available schema from the drop-down list. Larger data sets may take a few moments to load.

3. View the existing relationships and any user defined relationships.

4. Optionally, draw more relationships in this work area, then Save your changes.

   Note: To remove a user-applied join, double-click to select the join, then select the backspace key. The relationship is removed.

5. View or edit as many schemas as you need.

Important: If you add joins that create one-to-many relationships here, Symphony may return an error that prevents use of the data in a visual. For best results, when you create a one-to-many relationship with a specific left entity, any additional joins must refer to that table as the right entity. See Recommended Joins.

Note: For Postgres connections, both tables and data relationship information are read from the connection. Other supported connections include table information but do not read relationship information. See Connector Support for Schema Visualization. No information is provided for unsupported connections.

View Relationships of a Schema in a Source

You can view the relationships present in schemas you're using in your sources that use a supported connection. The Source Creation tab of the source includes a Schema drop-down you can use to select a schema for the source, with a view button that opens the work area.

View a schema in a source

1. Create or edit a source that uses a schema.

2. Select the view icon next to your selected Schema. A schema work area opens you can use to view the tables and relationships of that schema. Larger data sets may take a few moments to load.

3. View the existing relationships and any user defined joins to better understand the relationships present.

4. Close the schema or joins modal when you're done viewing the schema information, and repeat for other schemas if needed.

Connector Support for Schema Visualization

Support for this feature by connector is shown in the following table.

Key:Y - Supported; N - Not Supported; N/A - may not be supported.

Connector	Supported?
Amazon Redshift	Y
Amazon S3	Y
Apache Drill	N/A
Apache Phoenix	N/A
Apache Phoenix Query Server (QS)	N/A
Apache Solr	N/A
BigQuery	N/A
Cloudera Impala	Y
Cloudera Search	N/A
Couchbase	N/A
Dremio	N/A
Elasticsearch 7.0	N
Elasticsearch 8.0	N/A
File Upload	N/A
HDFS	Y
Hive	N/A
Jira	Y
MemSQL	Y
Microsoft SQL Server	Y
MongoDB	Y
MySQL	Y
Oracle	Y
PostgreSQL	Y
Python	N/A
Real Time Sales	Y
Salesforce	Y
SAP Hana	N/A
SAP S/4HANA	N/A
SAP IQ	N/A
Spark SQL	N/A
Snowflake	Y
Teradata	N/A
TIBCO DV	N/A
Trino	N/A
File Upload (Upload API)	N/A
Vertica	N/A