Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,363 questions
Error alter materialized view
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(48, 2%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERL%3C/text%3E%3C/svg%3E)
Richard Luis Díaz
21
Reputation points
When rebuilding a materialized view I get the following error:
I have tried to run the query and it works correctly, I have also recreated the view with another name and it also works correctly.
Instead the disable works correctly.
What is the problem?
Azure Synapse Analytics
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 26%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
HimanshuSinha-msft 19,486 Reputation points Microsoft Employee Moderator2021-08-06T20:19:02.013+00:00 Hello @Richard Luis Díaz ,
Thanks for the ask and using the Microsoft Q&A platform .
I was able to repro this issue , I am reaching out to the internal team to get more help on this .
Please do let me know how it goes .
Thanks
Himanshu -
HimanshuSinha-msft 19,486 Reputation points Microsoft Employee Moderator
2021-08-11T16:53:54.98+00:00 Hello @Richard Luis Díaz ,
Apologies for the delay in reply on this . I am not getting the response from the internal team as I was hoping for . I will share updates once I hear from them .
Thanks
Himanshu -
HimanshuSinha-msft 19,486 Reputation points Microsoft Employee Moderator
2021-08-17T16:00:48.1+00:00 Hello @Richard Luis Díaz ,
Thanks for the patience , unfortunately we are not getting the kind of response from the team here . if you have a support plan you may file a support ticket, else could you please send an email to azcommunity@microsoft.com with the below details, so that we can create a one-time-free support ticket for you to work closely on this matter.
Subscription ID:
Subject : Attn Himanshu
Please let me know once you have done the same.Thanks
Himanshu -
HimanshuSinha-msft 19,486 Reputation points Microsoft Employee Moderator
2021-08-18T16:19:22.657+00:00 Hello @Richard Luis Díaz ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if have already reached out to the Microsoft Support , please do share the SR# , othereise request you to please do the needful as requested in the last response .
Thanks
Himanshu
Sign in to comment
Sign in to answer