What is Azure Synapse?
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.
- 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.
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.
- 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.