Understand massively parallel processing concepts

Synapse SQL MPP Architecture

Photo by Ivan Bandura on Unsplash

Synapse SQL architecture components

Azure Synapse Analytics uses a node-based architecture. Applications connect and issue T-SQL commands to a Control node, which is the single point of entry for the data warehouse. The Control node runs the Massively Parallel Processing (MPP) engine…

--

--

--

making the🌎 a better place by taking care of data

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Ways to reduce your Oracle Licensing Cost by migrating to Oracle Cloud

Behavior Driven Development, Cucumber, BDD with Cucumber.

A Plan for OSCP

Libre Software isn’t Radical (RFC)

Implementing Azure Redis Cache in .Net Core

New listing on BYBIT

Wireframe(d)Space

Attended vs. Unattended RPA: What’s The Difference?

Attended vs. Unattended bots

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
dataninja

dataninja

making the🌎 a better place by taking care of data

More from Medium

Data engineering with Azure Synapse Apache Spark Pools — Part 1, with Apache Spark

Azure Synapse Spark Pool: PySpark Upsert Function for Azure SQL

Built-In DateTime Transformation Functions Used in PySpark in Databricks

Databricks — An Introduction and Tutorial