Azure Synapse is Azure SQL Data Warehouse evolved
Azure Synapse is a limitless analytics service that brings together enterprise data warehousing and Big Data analytics. It gives you the freedom to query data on your terms, using either serverless on-demand 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 features
| Limitless scale | GA | Preview |
|---|---|---|
| Provisioned compute (data warehouse) | ||
| Materialized views | ||
| Workload importance | ||
| Workload isolation | ||
| On-demand query | ||
| Powerful insights | ||
| Power BI integration | ||
| Azure Machine Learning integration | ||
| Data lake exploration | ||
| Streaming analytics (data warehouse) | ||
| Apache Spark integration | ||
| Unified experience | ||
| Hybrid data ingestion | ||
| Azure Synapse studio | ||
| Unmatched security | ||
| Column- and row-level security | ||
| Dynamic data masking | ||
| Private endpoints |
Limitless scale
Deliver insights from all your data, across data warehouses and big data analytics systems, with blazing speed
Powerful insights
Expand discovery of insights from all your data and apply machine learning models to all your intelligent apps
Unified experience
Significantly reduce project development time with a unified experience for developing end-to-end analytics solutions
Unmatched security
Secure data with the most advanced security and privacy features in the market, such as column- and row-level security and dynamic data masking
Experience limitless scale and query data on your terms
Azure Synapse delivers insights from all your data, across data warehouses and big data analytics systems, with blazing speed. With Azure Synapse, data professionals can query both relational and non-relational data at petabyte-scale using the familiar SQL language. For mission-critical workloads, they can easily optimize the performance of all queries with intelligent workload management, workload isolation, and limitless concurrency.
Discover powerful insights across your most important data
With Azure Synapse, enabling BI and machine learning is a breeze. It is deeply integrated with Power BI and Azure Machine Learning to greatly expand discovery of insights from all your data and apply machine learning models to all your intelligent apps. Significantly reduce project development time for BI and machine learning projects with a limitless analytics service that enables you to seamlessly apply intelligence over all your most important data—from Dynamics 365, Office 365 to SaaS services that support Open Data Initiative—and easily share data with just a few clicks.
Harness the power of a unified analytics experience
Build end-to-end analytics solutions with a unified experience. The Azure Synapse studio provides a unified workspace for data prep, data management, data warehousing, big data, and AI tasks. Data engineers can use a code-free visual environment for managing data pipelines. Database administrators can automate query optimization. Data scientists can build proofs of concept in minutes. Business analysts can securely access datasets and use Power BI to build dashboards in minutes—all while using the same analytics service.
Safeguard data with unmatched security and privacy
Azure has the most advanced security and privacy features in the market. These features are built into the fabric of Azure Synapse, such as automated threat detection and always-on data encryption. And for fine-grained access control businesses can help ensure data stays safe and private using column-level security and native row-level security, as well as dynamic data masking to automatically protect sensitive data in real time.
Key Service Capabilities
Enterprise data warehousing
Build your data warehouse on the proven foundation of the industry’s top-performing SQL engine.
Deeply integrated Apache Spark and SQL engines
Enhance collaboration among data professionals working on advanced analytics solutions. Easily use T-SQL queries on both your data warehouse and embedded Spark engine.
Data lake exploration
Bring together relational and non-relational data, and easily query files in the data lake with the same service you use to build data warehousing solutions.
Streaming ingestion & analytics
Perform real-time analytics on streaming data directly in your data warehouse.
Choice of language
Use your preferred language, including T-SQL, Python, Scala, Spark SQL, and .Net—whether you use serverless or provisioned compute resources.
Integrated AI and BI
Complete your end-to-end analytics solution with deep integration of Azure Machine Learning and Power BI.
Code-free data orchestration
Build ETL/ELT processes in a code-free visual environment to easily ingest data from more than 85 native connectors.
Industry-leading management and security
Use built-in features to ensure your data and processes are seen by only those with authorized access.
Empower data professionals to achieve more
Data engineers
Simplify the steps to wrangle multiple data types from multiple sources, including streaming, transactional, and business data. Use a code-free visual environment to easily connect to data sources and ingest, transform, and place data in the data lake.
Data scientists
Build proofs of concept in minutes and easily create or adjust end-to-end solutions. Provision resources as needed or simply query existing resources on demand across massive amounts of data. Work with the language of your choice—T-SQL, R, Python, Scala, .Net, and Spark SQL.
IT professionals
Protect and manage your organization’s data more efficiently. Enable big data processing with both on-demand and provisioned compute. Secure access to cloud and hybrid configurations through tight integration with Azure Active Directory. Enforce privacy requirements using data masking as well as row-level and column-level security.
Business analysts
Securely access datasets and use Power BI to build dashboards available within Azure Synapse. Securely share data within and outside your organization through Azure Data Share.
Database administrators
Match your expanding responsibilities for data warehouses and data lakes. Use familiar languages and tools, such as T-SQL. Run as many workloads as you want with ease. Assign resources to escalate critical workloads based on intelligent workload importance, workload isolation, and enhanced concurrency capabilities.
Data security and privacy are non-negotiable
-
Secure, monitor, and manage your data and analytics solutions with a wide range of industry-leading security and compliance features.
-
Use single-sign-on and Azure Active Directory integration to enable data professionals to spend more time discovering insights.
-
Azure has more certifications than any other cloud provider. View the comprehensive list.
Pricing that gives you flexibility and control
Manage resources and costs with elastic scalability for provisioned compute and storage.
Get started with Azure Synapse
Documentation, training, and migration resources
Documentation
Start using Azure Synapse with our documentation.
"Our adoption of the Azure Analytics platform has revolutionized our ability to deliver insights to the business. We are very excited that Azure Synapse Analytics will streamline our analytics processes even further with the seamless integration the way all the pieces have come together so well."
Nallan Sriraman, Global Head of Technology, Unilever
"We anticipate Azure Synapse Analytics will drive faster insights from all our data, and thus, a faster path to better decisions and improved returns."
Danny Siegel, Vice President, Information Delivery, Newell Brands
"We believe that Azure Synapse Analytics can provide the scalability that an organization like Deutsche Bank requires for its analytic workloads, while reducing the complexity of our infrastructure. This will allow us to focus on our data, and value we can derive from it."
Paul Russell, Head of Engineering, Enterprise Analytics Platforms, Deutsche Bank
"In the modern data landscape, Azure Synapse Analytics is the missing link that enables discovery on massive data volumes, quickly, easily and with the minimum of fuss, maximizing value for our business."
Grant Nairn, CIO, Aggreko
Stay updated on the latest Azure Synapse news
-
UPDATE
Azure Synapse Analytics—Continuous integration and deployment with SSDT is now available
-
November 7, 2019
Azure SQL Data Warehouse is now Azure Synapse Analytics
John Macintyre, Director of Product, Azure Data
-
UPDATE
Azure Private Link is now available in all regions
-
UPDATE
Introducing Azure Synapse Analytics: A limitless analytics service with unmatched time to insight
-
November 4, 2019
Simply unmatched, truly limitless: Announcing Azure Synapse Analytics
Rohan Kumar, Corporate Vice President, Azure Data
-
November 4, 2019
Build a data-driven culture to accelerate innovation
John 'JG' Chirapurath, General Manager, Azure Data & AI
-
UPDATE
Azure Data Share—Support for sharing data from Azure SQL and SQL Data Warehouse
-
UPDATE
Azure Private Link is now available in preview
-
August 12, 2019
Six ways we’re making Azure reservations even more powerful
Yashesvi Sharma, Principal Program Manager, Azure Reservations
Frequently asked questions
-
Azure Synapse is a limitless analytics service that brings together enterprise data warehousing and Big Data analytics. It gives you the freedom to query data on your terms, using either serverless on-demand 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.
-
Simply put, Azure Synapse Analytics is Azure SQL Data Warehouse evolved. We have taken the same industry leading data warehouse to a whole new level of performance and capabilities. Businesses can continue running their existing data warehouse workloads in production today with Azure Synapse and will automatically benefit from the preview capabilities when they become generally available.
-
You can get started today with an Azure free account or contact sales for more information.