Azure Synapse Analytics

Limitless analytics service with unmatched time to insight

Already an Azure customer? Getting started

Azure Synapse is Azure SQL Data Warehouse evolved

Azure Synapse is a limitless analytics service that brings together enterprise data warehousing and Big Data analytics. It gives you the freedom to query data on your terms, using either serverless or provisioned resources – at scale. Azure Synapse brings these two worlds together with a unified experience to ingest, prepare, manage and serve data for immediate BI and machine learning needs.

Now save up to 76 per cent

New limited-time offer enables qualifying customers who currently use an on-premises data warehouse to save up to 76 per cent when migrating to Azure Synapse.

Learn more

Analytics in Azure is simply unmatched

Insights for all at incredible value. Simply unmatched. Analytics in Azure is up to 14 times faster and costs 94 per cent less than other cloud providers. Why go anywhere else?

Learn more

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 of your data and apply machine learning models to all of 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 by using the freshest data possible from your operational systems, in every moment, with 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

Experience limitless scale and query data on your terms

Azure Synapse delivers insights from all of your data, across data warehouses and big data analytics systems, with blazing speed. With Azure Synapse, data professionals can query both relational and non-relational data at petabyte-scale using the familiar SQL language. For mission-critical workloads, they can easily optimise the performance of all queries with intelligent workload management, workload isolation and limitless concurrency.

Architecture deep dive

Discover powerful insights across your most important data

With Azure Synapse, enabling BI and machine learning is a breeze. It is deeply integrated with Power BI and Azure Machine Learning to greatly expand discovery of insights from all your data and apply machine learning models to all your intelligent apps. Significantly reduce project development time for BI and machine learning projects with a limitless analytics service that enables you to seamlessly apply intelligence over all your most important data – from Dynamics 365, Office 365 to SaaS services that support Open Data Initiative – and easily share data with just a few clicks.

The Power BI Professional’s Guide to Azure Synapse Analytics

Harness the power of a unified analytics experience

Build end-to-end analytics solutions with a unified experience. The Azure Synapse studio provides a unified workspace for data prep, data management, 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 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.

Data lake and data warehouse unified with Azure Synapse Analytics

Gain instant clarity using the freshest operational data at all times

Bring immediate, in-the-moment insights to your business with a simple, low cost, cloud-native HTAP implementation using Azure Synapse Link. With a single click, you can remove the barriers between Azure databases and Azure Synapse to get insights from your live operational data stores in near-real time. No complex ETL pipelines or additional database compute resources are required and you can run your analytics workloads on live data through Azure Synapse, without affecting your operational systems. Business analysts, data engineers and data scientists can now use Azure Synapse to run near real-time business intelligence, analytics and machine learning pipelines without affecting the performance of their transactional workloads on Azure Cosmos DB.

Safeguard data with unmatched security and privacy

Azure has the most advanced security and privacy features in the market. These features are built into the fabric of Azure Synapse, such as automated threat detection and always-on data encryption. And for fine-grained access control, businesses can help ensure that data stays safe and private by using column-level security and native row-level security, as well as dynamic data masking to automatically protect sensitive data in real time.

Seven key principles of cloud security and privacy

Key service capabilities

Enterprise data warehousing

Build your data warehouse on the proven foundation of the industry’s top-performing SQL engine.

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 embedded Spark engine.

Data lake exploration

Bring together relational and non-relational data, and easily query files in the data lake with the same service that you use to build data warehousing solutions.

Streaming ingestion & analytics

Perform real-time analytics on streaming data directly in your data warehouse.

Choice of language

Use your preferred language, including T-SQL, Python, Scala, Spark SQL and .Net – whether you use serverless or provisioned compute resources.

Integrated AI and BI

Complete your end-to-end analytics solution with deep integration of Azure Machine Learning and Power BI.

Code-free data orchestration

Build ETL/ELT processes in a code-free visual environment to easily ingest data from more than 85 native connectors.

Industry-leading management and security

Use built-in features to ensure that your data and processes are only seen by those with authorised access.

Empower data professionals to achieve more

Data engineers

Simplify the steps to wrangle multiple data types from multiple sources, including streaming, transactional and business data. Use a code-free visual environment to easily connect to data sources and ingest, transform and place data in the data lake.

Data scientists

Build proofs of concept in minutes and easily create or adjust end-to-end solutions. Provision resources as needed or simply query existing resources on demand across massive amounts of data. Work with the language of your choice – T-SQL, R, Python, Scala, .Net and Spark SQL.

IT professionals

Protect and manage your organisation’s data more efficiently. Enable big data processing with both on-demand and provisioned compute. Secure access to cloud and hybrid configurations through tight integration with Azure Active Directory. Enforce privacy requirements using data masking as well as row-level and column-level security.

Business analysts

Securely access datasets and use Power BI to build dashboards available within Azure Synapse. Securely share data within and outside your organisation through Azure Data Share.

Database administrators

Match your expanding responsibilities for data warehouses and data lakes. Use familiar languages and tools, such as T-SQL. Run as many workloads as you want with ease. Assign resources to escalate critical workloads based on intelligent workload importance, workload isolation and enhanced concurrency capabilities.

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 end-to-end analytics including pipelines, embedded Apache Spark, serverless data lake exploration and provisioned compute and storage.

Get started with Azure Synapse

Get instant access and $200 credit by signing up for your Azure free account.

Learn how to use Azure Synapse – explore tutorials, videos and documentation.

Keep building your skills with Azure Synapse.

Documentation, training and resources

Documentation

Start using Azure Synapse with our documentation.

The scientist, the engineer and the warehouse

Organisations rely on data science to support innovation, competitive advantage and efficiency, and the data scientist role is vital to this practice.

Read the study

Analytics in Azure virtual event

Register for this virtual event to learn how to simplify your data lake and data warehousing solutions with Azure Synapse Analytics.

Register now

Stay updated on the latest Azure Synapse news

  • Azure Synapse is a limitless analytics service that brings together enterprise data warehousing and Big Data analytics. It gives you the freedom to query data on your terms, using either serverless on-demand or provisioned resources – at scale. Azure Synapse brings these two worlds together with a unified experience to ingest, prepare, manage and serve data for immediate BI and machine learning needs.
  • Simply put, Azure Synapse Analytics is Azure SQL Data Warehouse evolved. We have taken the same industry-leading data warehouse to a whole new level of performance and capabilities. Businesses can continue running their existing data warehouse workloads in production today with Azure Synapse and will automatically benefit from the preview capabilities when they become generally available.
  • You can get started today with an Azure free account or contact sales for more information.

Try Azure Synapse with your Azure free account