...
To query a materialized view, a Synapse user must have “download” permission on all source tables (if any exist). Additionally, rows that are derived from views will only be each row in a materialized view that is derived from a row in a view is only visible to Synapse users that have view permission of all of on the corresponding original files that were used to populate the source viewobject, such as a file. Rows that are derived from multiple objects in one or more views are only visible if the user has view permission on all referenced objects.