Azure Synapse Analytics
Accelerate time to insight across enterprise data warehouses and big data systems.
Experience a new class of data analytics
Azure Synapse Analytics is an enterprise analytics service that accelerates time to insight across data warehouses and big data systems. It brings together the best of SQL technologies used in enterprise data warehousing, Apache Spark technologies for big data, and Azure Data Explorer for log and time series analytics.
Limitless scale to rapidly deliver insights from all your data across data warehouses and big data analytics systems
Powerful insights uncovered from all your data transformed with machine learning models to enhance your intelligent apps
Unified experience for developing end-to-end analytics solutions to significantly reduce project development time
The most advanced security and privacy features on the market, including column- and row-level security and dynamic data masking
Experience limitless scale and query data on your terms
Gain insights from all your data, across data warehouses, data lakes, operational databases, and big data analytics systems. Query both relational and nonrelational data using the language of your choice. For mission-critical workloads, easily optimize the performance of all queries with intelligent workload management, workload isolation, and limitless concurrency.
Discover powerful insights across all your data
Expand discovery of insights from all your data through integration with Power BI and Azure Machine Learning. Enable practitioners to easily apply machine learning models to all your intelligent apps without any data movement. Significantly reduce project development time for BI and machine learning projects. Seamlessly apply intelligence over all your most important data—from Dynamics 365 and Microsoft 365 to third-party datasets— then share data with just a few clicks.
Build analytics solutions with a unified experience
The Synapse Studio provides a workspace for data prep, data management, data exploration, enterprise 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.
Converge data workloads with Azure Synapse Link
Go from after-the-fact analysis to near-real-time insights by eliminating barriers between Microsoft data stores and Azure Synapse Analytics. Use Azure Synapse Link to automatically move data from both operational databases and business applications without time-consuming extract, transform, and load (ETL) processes. Get an end-to-end view of your business by easily connecting separate systems—and democratize data access with a solution that brings the power of analytics to every data-connected team.
Safeguard data with unmatched security and privacy
Keep your data safe with advanced security and privacy features like automated threat detection and always-on encryption. Ensure fine-grained control with column-level and row-level security, column-level encryption, and dynamic data masking to automatically protect sensitive data in real time.
Comprehensive security and compliance, built in
-
Microsoft invests more than USD1 billion annually on cybersecurity research and development.
-
We employ more than 3,500 security experts who are dedicated to data security and privacy.
-
Azure has more certifications than any other cloud provider. View the comprehensive list.
-
Pricing that gives you flexibility and control
Manage resources and costs for your end-to-end analytics solution and pay for only the capabilities you use.
Get started with an Azure free account
1
2
After your credit, move to pay as you go to keep building with the same free services. Pay only if you use more than your free monthly amounts.
3
See why companies of all sizes choose Azure Synapse Analytics
Mitsubishi Heavy Industries
Mitsubishi Heavy Industries (MHI) built a data analysis platform that uses Azure Synapse Analytics to accelerate data transformation by reducing data preparation period by 90 percent and shifting to data-driven management.
East London NHS Foundation Trust
"The Azure platform has underpinned our agile and experimental approach to evolving the Co-op Data Platform, enabling us to learn on the go and pivot rapidly when needed."
Amar Shah, Chief Quality Officer, East London NHS Foundation Trust
Americana Group
“We show people that they can use data to monitor and expedite their tasks. However, the true value comes when they start changing their behavior and make informed decisions based on data.”
Navdeep Agarwal, Head of Business Intelligence, Americana Group Restaurants Division
Swiss Reinsurance Company
Swiss Reinsurance Company Ltd, commonly known as Swiss Re, is all about big data. As the world's second-largest reinsurer, the company drives deeper, faster insights with Azure Synapse Analytics and Power BI.
MultiChoice Group
“We are becoming an analytics-driven company that understands why treating our data as an asset in a digital world is critical.”
Debra Goosen, Analytics Innovation Lead, MultiChoice Group
Resources and documentation
Frequently asked questions
-
A data warehouse is a centralized repository that holds structured data (database tables, Excel sheets) and semi-structured data (XML files, webpages) for the purposes of reporting, analysis, and other forms of business intelligence. Learn more about data warehouses.
-
Azure Synapse is available in most regions worldwide—see the Azure products by region page for the latest details.
-
What was called Azure Synapse Analytics (formerly SQL DW) is now labeled as Dedicated SQL pool (formerly SQL Data Warehouse) in the Azure portal. Existing customers can continue running their existing data warehouse workloads in production today with Dedicated SQL pool (formerly SQL DW) without going through any changes. If existing customers want to take advantage of all the latest innovations now generally available with the unified experience in Azure Synapse Analytics, they can choose to manage their existing data warehouse with a Synapse workspace. This path allows existing Azure SQL Data Warehouse customers to continue running their current data warehouse without impacting their workload and easily begin using the latest innovations in Azure Synapse Analytics, such as serverless data lake exploration and integrated SQL and Apache Spark engines.
-