Trace Id is missing
Skip to main content

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.

Activate the value in your data faster with Synapse in Microsoft Fabric, now generally available. Learn more

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.

The report on availability for Microsoft Cloud for Healthcare

 

An overview of data services in Azure.

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.

The report on availability for Microsoft Cloud for Healthcare

 

An overview of data services in Azure.

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.

The report on availability for Microsoft Cloud for Healthcare

Comprehensive security and compliance, built in

Get started with an Azure free account

1

Start free. Get $200 credit to use within 30 days. While you have your credit, get free amounts of many of our most popular services, plus free amounts of 55+ other services that are always free.

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

After 12 months, you'll keep getting 55+ always-free services—and still pay only for what you use beyond your free monthly amounts.

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

Back to tabs

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.

Ready when you are—let's set up your Azure free account

Try Azure Synapse Analytics free