Azure Synapse
DatabasesWhat is Azure Synapse?
It is an 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. It brings these two worlds together with a unified experience to ingest, prepare, manage, and serve data for immediate BI and machine learning needs.
Azure Synapse is a tool in the Databases category of a tech stack.
Key Features
Complete T-SQL based analytics – Generally AvailableDeeply integrated Apache SparkHybrid data integrationUnified user experience
Azure Synapse Pros & Cons
Pros of Azure Synapse
- ✓ETL
- ✓Security
- ✓Serverless
- ✓Doesn't support cross database query
Cons of Azure Synapse
- ✗Concurrency
- ✗Dictionary Size Limitation - CCI
Azure Synapse Alternatives & Comparisons
What are some alternatives to Azure Synapse?
MySQL
The MySQL software delivers a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server. MySQL Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed software.
PostgreSQL
PostgreSQL is an advanced object-relational database management system that supports an extended subset of the SQL standard, including transactions, foreign keys, subqueries, triggers, user-defined types and functions.
MongoDB
MongoDB stores data in JSON-like documents that can vary in structure, offering a dynamic, flexible schema. MongoDB was also designed for high availability and scalability, with built-in replication and auto-sharding.
