Azure Synapse Analytics – Feature Summary vs Status

Last Updated – 28th may 2021

Following my previous (more detailed) blog post on ‘Is Azure Synapse Analytics Ready for Production?‘ I was asked to summarize this understanding/opinion of Synapse into a simpler view.

Updated: I’ve tweaked a couple of the traffic lights and narrative based on the annoucements this week from the Microsoft Build conference. The main change being the support for Delta Tables from the SQL Serverless compute.


Synapse Summary - 28-05-2021

As a PDF if you prefer here.

Discuss 🙂

Thanks

5 thoughts on “Azure Synapse Analytics – Feature Summary vs Status

  1. Hi Paul,

    great overview, i would be interessted into Delta Lake Version differences between Databricks and Synapse. Especially now as DBRE 8.0 with 3.1 Spark is already in the preview.

    Cheers and thanks,
    Gapy

    Like

  2. SQL-on-demand
    * No CI/CD and no build possible!
    * No caching mechanism when data did not change
    The first is in my opinion a red flag. The second, annoying but can live with it.

    Like

  3. You should definitely change the status of Azure Spark Pools from yellow to red. I’m supposed to be implementing Azure Synapse Analytics at a customer and I’ve stumbled across some issues. I could live with the Spark version for now, however there is a much bigger issue: my Spark cluster has no queue. When I call a notebook in a loop, the job aborts if there are not enough nodes available. Why doesn’t it just wait and then start the job? Furthermore, each notebook starts a new session which takes 5 minutes to start.
    Also, a lot of features for the delta tables are missing.

    We will switch to Mapping Data Flows, which will run hopefully better.

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.