Azure Synapse
What 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?
Apache Spark
Spark is a fast and general processing engine compatible with Hadoop data. It can run in Hadoop clusters through YARN or Spark's standalone mode, and it can process data in HDFS, HBase, Cassandra, Hive, and any Hadoop InputFormat. It is designed to perform both batch processing (similar to MapReduce) and new workloads like streaming, interactive queries, and machine learning.
Google BigQuery
Run super-fast, SQL-like queries against terabytes of data in seconds, using the processing power of Google's infrastructure. Load data with ease. Bulk load your data using Google Cloud Storage or stream it in. Easy access. Access BigQuery by using a browser tool, a command-line tool, or by making calls to the BigQuery REST API with client libraries such as Java, PHP or Python.
Amazon Redshift
It is optimized for data sets ranging from a few hundred gigabytes to a petabyte or more and costs less than $1,000 per terabyte per year, a tenth the cost of most traditional data warehousing solutions.
