Azure Synapse Analytics – Feature Summary vs Status

Updated – 10th Feb 2021

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

This is what I did…



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.