How to: Create Materialized Views in Azure Synapse Analytics SQL Pools

In this video I show how a really easy way to create materialized views.
This technique using EXPLAIN WITH_RECOMMENDATIONS makes the job a way too easy.
For more info, check out the documentation
docs.microsoft...
#Azure #Synapse #AzureSynapse #SQLPools #MaterializedViews
docs.microsoft...

[@mitrareddy7946]

I am getting an error that the database has no stored procedure 'EXPLAIN'. How to resolve this issue?

[@MarkPryceMaher]

The explain works on a statement level (select/update/delete/etc). A proc can have many statements.

[@alexphatelevich3876]

@@MarkPryceMaher The same error ... Could not find stored procedure 'EXPLAIN'. SSMS 18.2 , SQLSERVER standard edition : 2019

[@MarkPryceMaher]

@@alexphatelevich3876 EXPLAIN is a feature of the dedicated SQL pool, it isn't supported in SQL SERVER.

[@jamieclarke2694]

The EXPLAIN part only worked for me in Azure Data Studio, not in SSMS, in case that helps anyone.

[@danielwelenc]

Hi Mark! Is there a way to disable enforced dependencies on MVs?