Azure Synapse Analytics
Limitless analytics service with unmatched time to insight
Experience a new class of 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 resources—at scale. Azure Synapse brings these worlds together with a unified experience to ingest, explore, prepare, manage, and serve data for immediate BI and machine learning needs.
See the latest innovations
Learn about the limitless capabilities now generally available in Azure Synapse Analytics.
Read the blogAnalytics in Azure is simply unmatched
Get insights up to 14 times faster and for 94 percent less than other cloud providers.
Compare costsAzure Synapse Analytics features
| Limitless scale | GA | Preview |
|---|---|---|
| Dedicated SQL pool (data warehouse) | ||
| Serverless SQL pool (data exploration) | ||
| Serverless Apache Spark pool (big data) | ||
| Intelligent workload management | ||
| Materialized views and result-set cache | ||
| Power BI performance accelerator for Azure Synapse Analytics | ||
| Powerful insights | ||
| Power BI integration | ||
| Streaming analytics (data warehouse) | ||
| Azure Cognitive Services integration (code-free) | ||
| Azure Machine Learning integration | ||
| Unified experience | ||
| Data integration (code-free) | ||
| Synapse Studio | ||
| Unified management and monitoring | ||
| Instant Clarity | ||
| Azure Synapse Link | ||
| Unmatched security | ||
| Dynamic data masking | ||
| Managed virtual network with private endpoints | ||
| Column- and row-level security | ||
| Column-level encryption |
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.
Instant clarity
Gain instant clarity on your business with the freshest data possible from your operational systems, in every moment, with Azure Synapse Link.
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.
Gain insights from all your data, across data warehouses, data lakes, and big data analytics systems. Query both relational and nonrelational data at petabyte scale 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.
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, use a code-free visual environment for managing data pipelines. Database administrators, automate query optimization. Data scientists, build proofs of concept in minutes. Business analysts, securely access datasets and use Power BI to build dashboards in minutes—all while using the same analytics service.
Bring immediate, in-the-moment insights to your business with a simple, low-cost, cloud-native hybrid transaction/analytical processing (HTAP) implementation using Azure Synapse Link. With a single click, remove the barriers between Azure databases and Azure Synapse Analytics to get insights from your live operational data stores in near-real time. No complex ETL pipelines or additional database compute resources are required. Run your analytics workloads on live data through Azure Synapse without affecting your operational systems.
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 moreKey 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.
Cloud-native HTAP
Get insights from real-time transactional data stored in operational databases, such as Azure Cosmos DB, with a single click.
Choice of language
Use your preferred language, including T-SQL, 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.
End-to-end management and monitoring
Simplify the monotonous, but necessary, data tasks that each team must do—secure your Synapse workspace and we’ll take care of the rest.
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 don't 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 center 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
Documentation
Tutorials
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 Program 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 & Spencer speeds up insights
James Ferguson, Product Manager, Marks & 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 synchronizes 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."
Stay updated on the latest Azure Synapse Analytics news
-
UPDATE
General availability: Data flows in Azure Data Factory and Azure Synapse now support Reserved Instances
-
February 3, 2021
Gain real-time insights on SAP ERP data with Azure and Qlik Data Integration
-
January 4, 2021
4 common analytics scenarios to build business agility
-
UPDATE
Additional support for managed identity in Azure Stream Analytics now in public preview
-
UPDATE
Azure Data Share snapshot sharing for SQL Database and Synapse generally available
-
November 30, 2020
Digital event: Explore how data and analytics will impact the future of your business
-
UPDATE
New version of SSMS and ADS tools for serverless SQL pools in Azure Synapse Analytics
-
UPDATE
Announcing Azure Data Explorer data connector for Azure Synapse
-
UPDATE
Azure Synapse Link for Azure Cosmos DB: SQL serverless runtime support in preview
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, manage, and serve data for immediate BI and machine learning needs.
-
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.
-
Get started today with an Azure free account, or contact sales for more information.