An older analytics offering in Azure that combined Spark, pipelines and SQL-pool data warehousing. People new to warehousing are now pointed by its documentation to Fabric Data Warehouse.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains Azure Synapse Analytics in context, with comparison tables and the common traps.
Terms in this definition
- Warehouse
Fabric item offering complete T-SQL support (DML, DDL, multi-table transactions) over Delta tables held in OneLake; lakehouse SQL analytics endpoints, by contrast, are read-only.
Related terms
- PolyBase
Way of loading data into Azure Synapse Analytics by querying external tables. The COPY statement is the faster alternative.
- Sql (service tag)
Represents the outbound IP ranges used by Azure SQL Database and Azure Synapse Analytics. Individual servers are not singled out, and SQL Managed Instance is excluded.
- Synapse workspace
Azure Synapse Analytics workspace that brings together pipelines, Spark pools and SQL pools. When it uses a managed VNet, data stores can be reached only via managed private endpoints.