Azure Synapse Analytics is GA!
(Note: I will give a demo on Azure Synapse Analytics this Saturday Dec 5th at 1:10pm EST, at the PASS SQL Saturday Atlanta BI (info) (register) (full schedule))
Great news! Azure Synapse Analytics is now GA (see announcement). While most of the feature are GA, there are a few that are still in preview:
For those of you who were using the public preview version of Azure Synapse Analytics, nothing has changed – just access your Synapse workspace as before.
For those of you who have a Synapse database (i.e. SQL DW database) that was not under a Synapse workspace, your existing data warehouse resources are now listed under “Dedicated SQL pool (formerly SQL DW)” in the Azure portal (where you can still create a standalone database, called a SQL pool). You now have three migration options going forward for your existing database:
- Standalone: Keep the database (called a SQL pool) as is and get none of the new workspace features listed here, but you are able to continue using your database, operations, automation, and tooling like before with no changes
- Enable Azure Synapse workspace features: Go to the overview page for your existing database and choose “New synapse workspace” in the top menu bar and get all the new features except unified management and monitoring. All management operations will continue via SQL resource provider. Except for SQL requests submitted via the Synapse Studio, all SQL monitoring capabilities remain on the database (dedicated SQL pool). So basically you should just continue to use your current processes for monitoring your SQL resources on the server. For more details on the steps to enable the workspace features see Enabling Synapse workspace features for an existing dedicated SQL pool (formerly SQL DW)
- Migrate to Azure Synapse workspace: Create a user-defined restore point through the Azure portal, create a new synapse workspace or use an existing one, and then restore the database and get all the new features. All monitoring and management is done via the Synapse workspace and the Synapse Studio experience
I also wanted to point out that Dedicated SQL pools costs have dropped 83% to $23 per TB per month (East US)! Check out the Azure Calculator.
More info:
Microsoft introduces Azure Purview data catalog; announces GA of Synapse Analytics
Thank you for sharing the info, it is very helpful. A quick question:
Is there any down time or any risks we need to mitigate while excercising option 2 or 3 above?
Hi Shadid…there are no risks…the only down time would be with option 3 during the backup and restore.
Are they still working on Delta support from serverless, James?
Hi Leo, yes the are, but I don’t have an ETA on when it will be available.
Hi James, is there anywhere we can view your PASS demo of 12/5?
Only if you attended the PASS Summit, but I will make another recording in the next few weeks and post it on my blog.
That would be great thanks!
Hi James, Do you have the recorded session of your demo ?
Hi Vijay, sorry, no recording yet. But I hope to record one in the next couple weeks and post it on my blog.
Hi James
What’s the difference between option 2 and 3, is the outcome different?
Option 2 implies your data is real time and you don’t need another SQL pool whereas option 3 uses a snapshot and another SQL pool.
Ideally we don’t want to create another SQL pool if we already have one
Thanks for your help
Hi Dean…option 3 requires another copy of your existing database, where you would likely delete the original database after the restore is done. So you would have to plan for some downtime.
Thanks James
Makes sense now
Hi James,
Do you know if this GA release supports multi-clusters? This is the feature that Rohan Kumar demo’ed at ignite a while ago.
Thanks,
Ibrahim
Hi Ibrahim,
This GA release does not support multi-cluster. You will see that feature sometime next year.
Pingback:Load data from Databricks to Azure Analysis Services (AAS) | Tech Programing