Azure Synapse – BI for petabytes of data

November 11th, 2019 by Stephen Jones Leave a reply »

Microsoft introduced Azure Synapse Analytics last week as , the “next evolution” of Azure SQL Data Warehouse.

It promises better performance and more capabilities, than Azure SQL Data Warehouse, and existing customers will “automatically benefit” from the enhancements that are now in preview.

Azure Synapse is a “limitless” analytics service, and accommodates all data warehouses, data lakes, machine learning, and BI needs, either with a serverless or provisioned resources approach.

Among the benefits of Synapse:
• The service can query both relational and non-relationship data using SQL
• It can “apply intelligence” over all data, including Dynamics 365, Office 365 and SaaS services that support the Open Data Initiative
• It offers a unified experience for data prep, data management, data warehousing, big data, and AI
• Privacy and security features include: automated threat detection, always-on data encryption, column level security, and dynamic data masking

In an Ignite demo, Rohan Kumar, Microsoft corporate vice president for Azure Data claimed a petabyte scale query across multiple data sources ran in Synapse in 9 seconds, versus over eleven minutes in Google’s BigQuery. He also claimed that both AWS Redshift and BigQuery degrade more as concurrent load increase

Advertisement

Comments are closed.