- A big data analystics, Used to be called SQL data warehouse (SQL DW)
- a database designed for reporting and analytics, for processing large amounts of data and answering complex questions
- with SQL pool to process pentabtye of data (MMP)
- serverless on-demand or provisioned
- with machine learning elements
- not for day-to-day operation
Functions:
- Working with files in a data lake
- Ingesting and transforming data with pipelines (oschestration)
- Querying and manipulating data with SQL
- Processing and analyzing data with Apache Spark
- Exploring data with Data Explorer
- Integrating with other Azure data services (e.g. Purview, power bi, MS machine learning)
supports three types of distributed tables: - hash - round-robin - replicated