Notifications
Announcements
No record found.
Hi Everyone,
Trying to do a tidy up the tables in Azure Synapse Analytics. There are a number of tables that I have Deactivated in Finance and Operations Export to Data Lake which still come through on Synapse. CDMutil doesn't seem to take them out and I can't drop the tables in Synapse, SSMS or Azure data Studio.
Dose anyone have any tips for removing deactivated tables from Synapse?
Hi,
Related question and discussions are found for you, please check them:
Azure Synapse Unable to drop created table - Microsoft Q&A
Drop Database Error For Azure Synapse Database - Stack Overflow
Hope these will be useful!
Best Regards,
Hana
This post is my own opinion and does not necessarily reflect the opinion or view of my company.
Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.
Thanks Hana,
Yea had read those before, not exactly what I'm after.
My main thing here is how are others dealing with deactivating tables in Finance and Operations then cleaning up their Data Lake and Synapse so they don't have lots of orphaned tables per se.
Can't seem to find a lot written on the subject....
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 663 Most Valuable Professional
André Arnaud de Cal... 540 Super User 2025 Season 2
Sohaib Cheema 348 User Group Leader
