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 $1 billion annually on cybersecurity research and development.
We employ more than 3,500 security experts who are dedicated to data security and privacy.
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
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.
See why companies of all sizes choose Azure Synapse Analytics
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.
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.