Create Materialized Views based on Joins

Description

Currently Synapse does not allow Tables to be joined server-side. This is due to a need to protect the database from real-time queries that are not performant. However, we could add the ability to create views that joined data from multiple tables, backed by a materialized view in the db. This would give users the ability to actively edit / curate data in normalized form, and then drive performant UI elements in off of curated, denormalized, joined data.

Environment

None

Status

Assignee

Unassigned

Reporter

Ryan Luce

Labels

None

Validator

Bruce Hoff

Development Area

Portals - Results Sharing

Release Version History

None

Priority

Major

Epic Name

Create Materialized Views based on Joins
Configure