Workaround for materialized views with left join

Copper Contributor

I need to create a materialized view in Synapse that will contain a left join of 2 large tables. Can you please indicate a workaround for that based on your experience?

thank you very much for your input.

0 Replies