Azure Synapse Analytics (Azure SQL Data Warehouse)
Azure Synapse Analytics (Azure SQL Data Warehouse)
Overview
Recent Reviews
Reviewer Pros & Cons
View all pros & consVideo Reviews
Leaving a video review helps other professionals like you evaluate products. Be the first one in your network to record a review of Azure Synapse Analytics (Azure SQL Data Warehouse), and make your voice heard!
Pricing
View all pricingEntry-level set up fee?
- No setup fee
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting / Integration Services
Would you like us to let the vendor know that you want pricing?
2 people want pricing too
Alternatives Pricing
Features Scorecard
No scorecards have been submitted for this product yet.Start a Scorecard.
Product Details
What is Azure Synapse Analytics (Azure SQL Data Warehouse)?
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 (Azure SQL Data Warehouse) Technical Details
Operating Systems | Unspecified |
---|---|
Mobile Application | No |
Comparisons
View all alternativesCompare with
Reviews and Ratings
 (34)
Reviews
(1-8 of 8)- Popular Filters
Companies can't remove reviews or game the system. Here's why
March 17, 2022
Azure Synapse Does It All
As a consulting company, we implement data warehouse solutions for our clients. We use Azure Synapse for enterprises data warehouse implementations. Data from various internal sources like sales, finance and operations are integrated into Synapse via Azure Data Factory and Data Lake. It’s used as reporting data source for Microsoft Power BI as well.
- Data integration via poly base
- Data distribution
- Create table as select
- Resource allocation via user groups (for production ETL and report users)
- Integrating external 3rd party data sources is very easy in Snowflake and it’s missing in Azure Synapse
- Master data services and data quality services are missing in Azure Synapse. They are useful features present in on Orem Sql server
- Resource usage reports (top 10 expensive queries, most frequently run queries, etc) are a feature that can be added in Azure Synapse. It’s present in an on-prem SQL server. DMVs are there but viewing it visually as a report is more helpful.
We've been using Azure Synapse Analytics to create data pipelines for onPrem/onCloud ETL processing where the transform data will store inside the Azure Data Lake for further processing using PowerBI.
- Create data pipelines to connect with multiple data workspace(s) and external data
- Ability to connect with Azure Data Lake (sequentially) for data warehousing
- Being able to manage connections and create integration runtimes (for onPrem data capture)
- Thus far haven't seen any complications and/or any missing features
November 30, 2021
Satisfied DBA/Data engineer
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.
- 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?
October 21, 2021
Azure Synapse Analytics - more powerful SQL for data warehousing
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).
- 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
August 25, 2021
Modern Database
We use Azure Synapse Analytics (Azure SQL Data Warehouse) to hold all our daily sales data to serve reports. Without any storage constraint, we save large datasets and process them in a matter of time, thanks to the Azure lake storage support and Massive Parallel processing capabilities. It supports major file formats like Avro, Parquet and many more.
- Easy to Manage data
- Blazing fast query processing
- Supports Modern fileformats
- Documentation and Usecases
- Pricing
- Admin capabilities
August 03, 2021
Plays with Power BI nicely
Microsoft Azure Synapse Analytics (formally Azure SQL Data Warehouse) is being used as our marketing data warehouse. We are pulling data down from a number of different API's such as Facebook ads, Google ads and Google analytics, and then pumping that information back into the Azure Synapse Analytics Warehouse on a daily basis.
- They unify many data sources easily
- There is some "code free" ETL work it enables
- There is some AI integration that works nice
- The cost structure is difficult to understand
- The job scheduling capabilities aren't easy to use
- The logging metrics aren't easy to see
July 22, 2016
SQL Data Warehouse- everything you need to know
SQL Data Warehouse is being used to hold all of our summary level reporting. The data is loaded using SSIS and transformed into a star schema. SQL does a great job mapping all of the OLAP values and providing efficient structures to house all of the reporting data. We then use a reporting tool to build cubes and publish the data
- It is very cost-effective
- Development time needed was much less in comparison to other systems
- Played very nicely with our ETL and OLAP reporting tools
- More features would be a plus
- I would like to see Microsoft offer some diagramming tools for data warehouse
- I believe processing time and speed could always be improved
July 15, 2016
Better than querying off your OLTP
We use it to store large amounts of SQL data for our predictive analytics and big data modeling. We use it across several team but I cannot say it is used for the entire organization as my department operates relatively independently of the rest of the organization. We have an extremely large data sets and need to store it in a way that makes it accessible and fast.
- Quick to return data. Queries in a SQL data warehouse architecture tend to return data much more quickly than a OLTP setup. Especially with columnar indexes.
- Ability to manage extremely large SQL tables. Our databases contain billions of records. This would be unwieldy without a proper SQL datawarehouse
- Backup and replication. Because we're already using SQL, moving the data to a datawarehouse makes it easier to manage as our users are already familiar with SQL.
- It takes some time to setup a proper SQL Datawarehouse architecture. Without proper SSIS/automation scripts, this can be a very daunting task.
- It takes a lot of foresight when designing a Data Warehouse. If not properly designed, it can be very troublesome to use and/or modify later on.
- It takes a lot of effort to maintain. Businesses are continually changing. With that, a full time staff member or more will be required to maintain the SQL Data Warehouse.