Azure Synapse Analytics
Limitless analytics service with unmatched time to insight
Experience a new class of data analytics
Azure Synapse Analytics is a limitless analytics service that brings together data integration, enterprise data warehousing and big data analytics. It gives you the freedom to query data on your terms, using either serverless or dedicated options—at scale. Azure Synapse brings these worlds together with a unified experience to ingest, explore, prepare, transform, manage and serve data for immediate BI and machine learning needs.
Azure Synapse database templatesLearn how industry-specific database templates make it easy to combine and shape data.
Analytics in Azure is simply unmatchedGet insights up to 380 percent faster and for 49 percent less than other cloud providers.
Azure Synapse for Data EngineersLearn how to get started with 30 days of videos, tutorials and training modules.
Azure Synapse Analytics features
|Limitless scale||Generally available||Preview|
|Intelligent workload management for data warehouses|
|Sub-second performance on large analytical queries with materialised views and result-set cache|
|Serverless data lake exploration with T-SQL|
|Auto-pause/resume and autoscale for Apache Spark workloads|
|Fast exploration of log and telemetry data|
|Power BI performance accelerator for Azure Synapse Analytics|
|Power BI integration|
|Streaming analytics (data warehouse)|
|Azure Machine Learning integration|
|Code-free ETL/ELT data integration|
|Unified management and monitoring|
|Database templates (industry-specific)|
|Azure Synapse Link for Azure Cosmos DB|
|Azure Synapse Link for Dataverse|
|Integration with Microsoft Purview for data governance|
|Dynamic data masking|
|Managed virtual network with private endpoints|
|Column- and row-level security|
Deliver insights from all your data, across data warehouses and big data analytics systems, with blasing speed.
Expand discovery of insights from all your data and apply machine learning models to all your intelligent apps.
Significantly reduce project development time with a unified experience for developing end-to-end analytics solutions.
Eliminate data barriers and perform analytics on operational and business apps data with Azure Synapse Link—no data movement.
Secure data with the most advanced security and privacy features in the market, such as column- and row-level security and dynamic data masking.
Gain insights from all your data, across data warehouses, data lakes, operational databases,= and big data analytics systems. Query both relational and non-relational data using the language of your choice. For mission-critical workloads, easily optimise the performance of all queries with intelligent workload management, workload isolation and limitless concurrency.Learn More
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 Office 365 to software-as-a-service (SaaS) services that support the Open Data Initiative— then share data with just a few clicks.Learn More
Build end-to-end analytics solutions with a unified experience. The Synapse Studio provides a workspace for data prep, data management, data exploration, data warehousing, big data and AI tasks. Data engineers can use a code-free visual environment for managing data pipelines. Database administrators, automate query optimisation. 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.
Go from after-the-fact analysis to near real-time insights by eliminating barriers between Microsoft data stores and Azure Synapse Analytics. With Azure Synapse Link you can 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.Learn More
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.Learn More
Key Service Capabilities
Unified analytics platform
Perform data integration, data exploration, data warehousing, big data analytics and machine learning tasks from a single, unified environment.
Serverless and dedicated options
Support both data lake and data warehouse use cases and choose the most cost-effective pricing option for each workload.
Enterprise data warehousing
Build your mission-critical data warehouse on the proven foundation of the industry's top-performing SQL engine.
Data lake exploration
Bring together relational and nonrelational data and easily query files in the data lake with the same service you use to build data warehousing solutions.
Code-free hybrid data integration
Build ETL/ELT processes in a code-free visual environment to easily ingest data from more than 95 native connectors.
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 Spark engines.
Log and telemetry analytics
Use industry-leading text-indexing technology to gain insights from time-series, log and telemetry data with the Azure Synapse data explorer distributed query engine.
Choice of language
Use your preferred language, including T-SQL, KQL, Python, Scala, Spark SQL and .Net—whether you use serverless or dedicated resources.
Integrated AI and BI
Complete your end-to-end analytics solution with deep integration of Azure Machine Learning, Azure Cognitive Services and Power BI.
Get insights from real-time transactional data stored in operational databases, such as Azure Cosmos DB, with a single click.
Limitless analytics service for all your data workloads
Optimised Apache Spark
Process big data with serverless Spark pools using the latest Spark runtime.
Perform data processing and machine learning tasks three times faster with Nvidia GPUs.
Autoscale, auto-pause/resume and caching
Launch clusters on demand and dynamically scale in, scale out, pause and resume.
Manage data pipelines in the same analytics platform as your data warehouse.
Code-free data wrangling
Perform code-free interactive data exploration and add it to your data pipeline.
Ingest data from software-as-a-service (SaaS) apps with more than 95 built-in connectors.
Build your mission-critical workloads on the industry's leading SQL engine.
SQL pool scalability
Easily scale your workloads and get predictable cost with no hidden charges.
In-engine predictive analytics
Generate millions of predictions in seconds directly in your data warehouse.
Intelligent workload management
Optimise your data warehouse to ensure resources are properly utilised.
Free utility for SQL code conversion
Automatically convert SQL code in minutes with Azure Synapse Pathway.
Immediate query results with adaptive caching
Get guaranteed fast performance on complex queries without any query charge.
Built-in ability to explore data lake
Immediately explore the data lake with the built-in serverless query endpoint.
Delta Lake support
Analyse and create reports on data stored in the Delta Lake file format.
Analyse all your data
Quickly analyse various data formats including Parquet, CSV and JSON.
Enhance developer productivity
Analyse data with a single click with automatic schema inference.
Maximise existing skills
Enable SQL professionals to explore the data lake while using T-SQL.
Pay only for executed queries rather than provisioning resources for each workload.
Perform analytics on operational data without copying or moving data.
Create streaming jobs with Event Hubs Premium—a linked service in Azure Synapse.
Automatically ingest and analyse business apps data with a few clicks.
Log and telemetry insights
Explore raw telemetry and time series data with Azure Synapse data explorer.
Code-free machine learning
Deploy machine learning models directly in Azure Synapse without using any code.
AI-infused data pipelines
Apply AI directly to your data pipelines in Azure Synapse and automate insights.
Accelerate data warehouse migration with Azure Synapse Pathway
Automate mandatory and critical data warehouse migration steps with a point-and-click solution that scans your source system, produces an inventory report and translates existing code in minutes—not weeks or months. No manual rewriting needed—get more than 100,000 lines of SQL code translated in minutes.
Azure Synapse Analytics for industries
Ensure data is secure with industry-leading features
Stay ahead of the competition with a modern approach to managing big data, data warehousing, curating personalised customer experiences, and implementing effective compliance and governance practises to protect customer data. Learn more about Azure for financial services.
Deliver personalised experiences
Connect disparate data sources to create 360-degree customer profiles and curate exceptional personalised experiences across every touchpoint.
Build customer trust with an end-to-end analytics solution that lets you monitor activity 24 hours a day across accounts and devices to detect fraud at the first instance.
Manage risk and mitigate threats with a consolidated and flexible approach to collecting and analysing enterprise data. Develop cost-effective solutions that enable a rapid and actionable response to risks.
Optimise your supply chain with real-time insights
Get real-time insights at scale with Azure Synapse Analytics. Industry 4.0 combines operational and analytic technologies and galvanises real-time access to new and existing data. Learn more about Azure for manufacturing.
Maximise overall equipment effectiveness (OEE)
Improve factory productivity by maximising availability, performance and quality. Generate powerful insights by using advanced analytics with limitless scale on Azure.
Reduced unplanned downtime
Predict asset failure to avoid costly downtime, reduce maintenance costs and improve operational efficiency. Apply advanced analytics and machine learning models with no data movement to optimise predictive maintenance.
Enhance supply chain visibility
Connect data sources throughout the supply chain to gain a complete view of your business. Improve visibility to increase resilience and gain a competitive advantage with advanced analytics and machine learning.
Know your customers and unify disparate data silos
Unify data from multiple channels and discover real-time insights with an end-to-end analytics service that helps you know your customers and create a resilient supply chain. Learn more about Azure for retail.
Ingest, process and analyse data to generate critical insights that help you provide better customer service. Consolidate disparate customer data sources and process data in real time to get a complete view of your customer.
Use omnichannel optimisation
Provide a seamless customer journey with omnichannel optimisation, which enables customers to switch platforms, devices and channels, while maintaining a cohesive experience.
Build a resilient supply chain
Detect trends from customers' browsing and post-purchasing behaviour to inform merchandising decisions. Eliminate data silos with end-to-end analytics and increase supplier collaboration by sharing of inventory data.
Secure data with industry-leading compliance features
The healthcare industry faces pressures from changing patient expectations, regulatory constraints and a shortage of care workers. Deliver personalised care, protect health information and empower care teams. Learn more about Azure for healthcare.
Intelligent, personalised care
Personalise care by providing patients with access to the health data they need to get the right care at the right time. Optimise operations by aggregating data across health IT systems and automating routine operations.
Implement clinical analytics
Analyse patient data to associate symptoms with diseases and recommend treatment protocols. Use clinical variables to detect trends and predictors to impact scoring for therapies and readmissions.
Apply compliance analytics
Identify regulatory risks and workflow efficiencies across datasets. Strengthen accountability and support quality measurement across health operations. Keep sensitive data secure and private at all times.
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 for your end-to-end analytics solution and pay for only the capabilities you use.
Get started with Azure Synapse Analytics
If you do not have an Azure account, sign up free to get instant access and $200 credit.
Sign in to your Azure account to create an Azure Synapse Analytics workspace with this simple quickstart.
Go to the knowledge centre inside the Synapse Studio to immediately create or use existing Spark and SQL pools, connect to and query Azure Open Datasets, load sample scripts and notebooks, access pipeline templates and take a tour.
Learn to quickly get started with Azure Synapse by setting up a free Azure account, creating a new workspace and starting your first project in the Knowledge Center.
Documentation, training and migration resources
DocumentationLearn more about Azure Synapse Analytics
See why companies of all sizes choose Azure Synapse Analytics
Walgreens transforms operations
Anne Cruz, IT Manager for Supply Chain and Merchandising, Walgreens
"With Azure Synapse, we were able to create a platform that is streamlined, scalable, elastic, and cost effective, enabling my business users to make the right decisions for the fast-paced market."
Co-op unlocks insights and new use cases
James Bleasby, Data Platform Programme Manager, Co-op
"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."
Marks and Spencer speeds up insights
James Ferguson, Product Manager, Marks and Spencer
"We needed a place where they could use self-service to get responses quickly. They're using Azure Synapse to push all that data out to Microsoft Power BI. Now, people who didn't typically have access to data or had to wait for IT to create a dashboard, they're able to figure it out themselves."
ClearSale protects online customers
Flavio Pega, Data Engineer, ClearSale
"Not only does Azure Synapse Analytics help us meet demand, [but] we are confident that our users can use direct queries to make sure they're always sharing the latest insights."
Neogrid synchronises its supply chain
Emerson Tobar, CTO, Neogrid
"Azure Synapse naturally facilitates collaboration and brings our data teams together. Working in the same analytics service will enable our teams to develop advanced analytics solutions faster, as well as provide a simplified and fast way to securely access and share data in a compliant manner."
CCC Marketing migrates from Oracle Exadata to Azure
Matsui Taro, IT Senior Manager, CCC Marketing
"By consolidating a system comprising three DB appliances into Azure Synapse Analytics, we were able to reduce the costs by 30 percent. The costs for data linkage and development were also significantly reduced."
Frequently asked questions
Azure Synapse Analytics is a limitless analytics service that brings together data integration, enterprise data warehousing and big data analytics. It gives you the freedom to query data on your terms, using either serverless or dedicated resources—at scale. Azure Synapse brings these worlds together with a unified experience to ingest, explore, prepare, transform, manage and serve data for immediate BI and machine learning needs.
What was called Azure Synapse Analytics (formerly SQL DW) is now labelled 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.