Skip to main content
TrustRadius
Azure Synapse Analytics

Azure Synapse Analytics
Formerly Azure SQL Data Warehouse

Overview

What is Azure Synapse Analytics?

Azure Synapse Analytics is described as the former Azure SQL Data Warehouse, evolved, and as a limitless analytics service that brings together enterprise data warehousing and Big Data analytics. It gives users the freedom to query data using either serverless…

Read more
Recent Reviews

Modern Database

8 out of 10
August 25, 2021
Incentivized
We use Azure Synapse Analytics (Azure SQL Data Warehouse) to hold all our daily sales data to serve reports. Without any storage …
Continue reading
Read all reviews

Awards

Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards

Return to navigation

Pricing

View all pricing

Tier 1

$4,700

Cloud
per month 5,000 Synapse Commit Units (SCUs)

Tier 2

$9,200

Cloud
per month 10,000 Synapse Commit Units (SCUs)

Tier 3

$21,360

Cloud
per month 24,000 Synapse Commit Units (SCUs)

Entry-level set up fee?

  • No setup fee
For the latest information on pricing, visithttps://azure.microsoft.com/en…

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting/Integration Services

Starting price (does not include set up fee)

  • $4,700 per month 5000 Synapse Commit Units (SCUs)
Return to navigation

Product Details

What is Azure Synapse Analytics?

Azure Synapse Analytics Technical Details

Deployment TypesSoftware as a Service (SaaS), Cloud, or Web-Based
Operating SystemsUnspecified
Mobile ApplicationNo

Frequently Asked Questions

Azure Synapse Analytics is described as the former Azure SQL Data Warehouse, evolved, and as a limitless analytics service that brings together enterprise data warehousing and Big Data analytics. It gives users the freedom to query data using either serverless or provisioned resources, at scale. Azure Synapse brings these two worlds together with a unified experience to ingest, prepare, manage, and serve data for immediate BI and machine learning needs.

Azure Synapse Analytics starts at $4700.

The most common users of Azure Synapse Analytics are from Enterprises (1,001+ employees).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

(51)

Attribute Ratings

Reviews

(1-2 of 2)
Companies can't remove reviews or game the system. Here's why
November 30, 2021

Satisfied DBA/Data engineer

Vladimír Mužný | TrustRadius Reviewer
Vladimír Mužný
Owner, Developer
DROPMAN s.r.o. (Computer Software, 1-10 employees)
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Use Cases and Deployment Scope
I am an independent developer using Azure Synapse for other companies. My company is machinery production oriented (i.e. automotive companies) so I'm used to [utilizing] the Synapse for statistics-driven quality control, some logistics stuff, etc.
Pros and Cons
  • The combination of SQL/unstructured data
  • Keeping things "complicated, but simple"; [heterogeneous] data formats seen as just SQL tables to business experts used to use Power BI, Excel, and any other traditional SQL-oriented BI tools
  • Integration options using "Synapse pipelines", the application of ADFs
  • The greatly integrated solution of independent things (Spark MPP cluster, MPP SQL Servers, ADFs) - all sitting under one roof. Great job!
  • Integration with super-fast, globally replicated data. I really appreciate the integration of NoSQL databases (namely Core API and Mongo API under Cosmos DB) with purely batch-processed BI data
  • I have no idea right now. But... Synapse Analytics are typically seen as batch-processing of source data. What about tighter cooperation with streaming features like Event Hubs?
Likelihood to Recommend
The most frequent answer to questions like this should be... IT DEPENDS. Synapse Analytics has some role in its DNA. It's not dedicated [to] tasks like some OLTP with many reads, however. When we are talking about Azure Synapse, we are talking about modernized BI stuff with great capabilities to involve big data processing to reach deeper insights [into] our data.
Return on Investment
  • It's actually hard to answer the question as it is built up, sorry. But imagine, you are used to [sending] paper letters to your customers. What are your spending [on] the letters? You have some imagination, however, but let's develop a simple chart showing your spendings related to any other spendings, or, more descriptively, compared with expected profit. Oh, my! Is it really so much? What about some e-mail campaign next time? We can talk about dozens of similar examples, folks. Until data is seen in graphical format, it's just some opinion on what's going on in our businesses.
  • Using Synapse Analytics as well as any other cloud resource needs a big change to the administrator's mindset. Basically, the cloud is not just about technical skills like "I love the MPP approach of data processing", but it is about, says, economies of operations. Scaling stuff up and down, pausing servers, this is what the utilization of the cloud is all about! Go and mention it to people!
Support Rating
10
N/A As a data processing expert I never needed official MS support :-)
Usability
10
Great integrated development for data transformation and analysis.
Contract Terms and Pricing Model
10
Basically, the billing is predictable, and this all about it.
October 21, 2021

Azure Synapse Analytics - more powerful SQL for data warehousing

Verified User
Consultant in Professional Services
Computer Software Company, 201-500 employees
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Use Cases and Deployment Scope
Azure Synapse Analytics is being used for data Warehousing - Azure Data Factory to pull in the initial data from source to Data Lake, then Spark notebook to process from raw (bronze) to staging (silver) in Synapse dedicated pools, then stored procedures in Synapse dedicated pool to process from staging to reporting (gold).
Pros and Cons
  • fast query results
  • integrated systems
  • one application/area for all processes
  • Delta Lake doesn't have full capabilities yet
  • spark doesn't yet have delta live tables
  • coding differences from Databricks' spark aren't well documented
Likelihood to Recommend
Azure Synapse Analytics is well suited to Data Warehouse scenarios with large data tables because of its distributed computing. If most tables have fewer than 1 million rows, then the cost of Synapse is not worthwhile - regular Azure SQL or Azure Analysis Services could suffice. If most tables have more than 1 million rows, then it's worthwhile to get the additional speed for querying large data sets.
Return on Investment
  • positive: faster reporting
  • negative: greater cost
  • positive: everything in one window rather than spread out everywhere
Support Rating
9
Microsoft does its best to support Synapse. More and more articles are being added to the documentation, providing more useful information on best utilizing its features. The examples provided work well for basic knowledge, but more complex examples should be added to further assist in discovering the vast abilities that the system has.
Usability
9
The data warehouse portion is very much like old style on-prem SQL server, so most SQL skills one has mastered carry over easily. Azure Data Factory has an easy drag and drop system which allows quick building of pipelines with minimal coding. The Spark portion is the only really complex portion, but if there's an in-house python expert, then the Spark portion is also quiet useable.
Return to navigation