Glossary
Search Azure terms
Open a clear definition, then continue into exam context, architecture, commands, operational examples, common mistakes, and related concepts.
Search all
Commands
Learning guides
Concept graph
Compare
Search-first Azure knowledge base
Term results
Search for a term or click a category. Results render only after you ask for them, so the glossary does not dump every available term on first load. Each result includes Quick peek and Open full term page actions.
Start with a search or a category.
Try managed identity , resource group , az group , private endpoint , or click Databases to load all database-related terms.
Showing 50 of 519 matching terms. Narrow the search to reduce the list.
Analytics
premium
Dedicated SQL pool pause
Dedicated SQL pool pause stops compute resources for an Azure Synapse dedicated SQL pool so compute charges stop while the database storage remains available and billable.
Analytics platform
intermediate
4 commands
Aliases: pause dedicated SQL pool, Synapse SQL pool pause, pause SQL DW compute
Quick peek
Open full term page
Analytics
premium
Dedicated SQL pool resume
Dedicated SQL pool resume restarts compute for a paused Azure Synapse dedicated SQL pool so users and workloads can query the warehouse again and compute billing resumes.
Analytics platform
intermediate
4 commands
Aliases: resume dedicated SQL pool, Synapse SQL pool resume, start SQL DW compute
Quick peek
Open full term page
Analytics
complete
SQL pool DWU
Microsoft Learn describes Data Warehouse Units as the performance-level measure for dedicated SQL pool in Azure Synapse Analytics. DWUs, including compute-optimized cDWU levels, represent the blended compute, memory, and IO capacity available to the distributed data warehouse and can be changed to balance price and performance.
Azure Synapse dedicated SQL pool
intermediate
5 commands
Aliases: Data warehouse unit, DWU for dedicated SQL pool, cDWU, Synapse SQL pool performance level
Quick peek
Open full term page
Analytics
learning-path-anchor
Synapse workload group
A Synapse workload group is a dedicated SQL pool workload management object that reserves, caps, and grants resources for classified requests. It uses settings such as MIN_PERCENTAGE_RESOURCE, CAP_PERCENTAGE_RESOURCE, and request resource grant percentages to shape isolation, containment, concurrency, and execution behavior.
Synapse Analytics
fundamentals
5 commands
Aliases: workload group in Synapse, dedicated SQL pool workload group, CREATE WORKLOAD GROUP, Synapse workload isolation group
Quick peek
Open full term page
Analytics
learning-path-anchor
Synapse workload classifier
A Synapse workload classifier is a dedicated SQL pool workload management rule that assigns incoming requests to a workload group and importance level. It can classify by user or role, query label, session context, and time window so different workloads receive different resource behavior.
Synapse Analytics
fundamentals
3 commands
Aliases: workload classifier in Synapse, dedicated SQL pool classifier, CREATE WORKLOAD CLASSIFIER, Synapse classification rule
Quick peek
Open full term page
Analytics
field-manual-complete
Synapse result-set cache
Synapse result-set cache is a dedicated SQL pool feature that persists eligible query results in the user database so repeated executions can return from cache instead of recomputing. It improves response time, reduces compute usage, and lets cached queries avoid consuming concurrency slots.
Synapse Analytics
fundamentals
7 commands
Aliases: Azure Synapse result set caching, result set cache in dedicated SQL pool, Synapse SQL result-set cache, dedicated SQL pool cached results
Quick peek
Open full term page
Analytics
field-manual-complete
Synapse materialized view
A Synapse materialized view is a dedicated SQL pool object that stores the result of a T-SQL query and refreshes as base tables change. The optimizer can use it automatically for eligible joins and aggregations, improving response time without changing user queries.
Synapse Analytics
advanced
5 commands
Aliases: Azure Synapse materialized view, dedicated SQL pool materialized view, CREATE MATERIALIZED VIEW AS SELECT, Synapse SQL materialized view
Quick peek
Open full term page
Analytics
premium field-manual
Materialized view in Synapse
A materialized view in Synapse is a precomputed table-like query result in Synapse dedicated SQL pool that can improve repeated analytical queries. Teams use it when warehouse workloads repeatedly aggregate or join data and need faster response with managed storage tradeoffs. In plain English, it gives operators a named control for query acceleration for common reporting patterns with explicit design and refresh considerations instead of leaving the decision hidden in a portal setting, script, or deployment file. Treat it as production-ready only when the owner, dependencies, permission boundary, monitoring signal, and rollback evidence are clear.
Azure Synapse dedicated SQL pool
intermediate
4 commands
Aliases: Materialized view in Synapse, Synapse materialized view, dedicated SQL pool materialized view, CREATE MATERIALIZED VIEW AS SELECT, Azure Synapse Analytics dedicated SQL pool, Azure Synapse dedicated SQL pool
Quick peek
Open full term page
Analytics
premium
PolyBase
PolyBase lets a SQL engine work with files stored outside the database, especially in Azure Storage or Azure Data Lake Storage. In Azure Synapse dedicated SQL pool, teams use it to define external data sources, file formats, and external tables, then load data into warehouse tables with T-SQL. It is useful when data lands in a lake first and the warehouse needs a scalable way to read or ingest it. PolyBase is not a pipeline by itself; it is the SQL-side external data access pattern.
Synapse Analytics
advanced
6 commands
Aliases: polybase, PolyBase
Quick peek
Open full term page
Analytics
premium
Hash distribution
Hash distribution is spreading rows across compute distributions by hashing a chosen distribution column in an Azure Synapse dedicated SQL pool.
Synapse dedicated SQL pool
intermediate
4 commands
Aliases: Synapse hash distribution, dedicated SQL pool hash distribution, Hash distribution, hash-distribution
Quick peek
Open full term page
Analytics
premium
Hash-distributed table
Hash-distributed table is a dedicated SQL pool table whose rows are assigned to distributions using a hash value calculated from one or more distribution columns.
Synapse dedicated SQL pool
intermediate
4 commands
Aliases: hash distributed table, Synapse HASH table, Hash-distributed table, hash-distributed-table
Quick peek
Open full term page
Analytics
verified
Result set cache
Microsoft Learn describes result set caching in Azure Synapse dedicated SQL pool as a feature that stores query results in the user database for reuse. When a repeated query can use cached results, it avoids recomputation, reduces compute use, and does not consume concurrency slots.
Synapse Analytics
intermediate
7 commands
Aliases: result set caching, Synapse result set cache, SET RESULT_SET_CACHING, cached query results, dedicated SQL pool result cache
Quick peek
Open full term page
Analytics
premium
Dedicated SQL pool DWU
A data warehouse unit setting that controls performance for a dedicated SQL pool.
Analytics platform
intermediate
4 commands
Aliases: DWU
Quick peek
Open full term page
Analytics
verified
Replicated table
A replicated table in Azure Synapse dedicated SQL pool stores a full copy of a small table on each compute node. It reduces data movement during joins and aggregations, improving query performance when the table is relatively small, stable, and not frequently updated.
Synapse Analytics
fundamentals
5 commands
Aliases: Synapse replicated table, DISTRIBUTION = REPLICATE, replicated dimension table, dedicated SQL pool replicated distribution
Quick peek
Open full term page
Analytics
template-specs-upgraded
Result set caching
Microsoft Learn describes result set caching in Azure Synapse dedicated SQL pool as a database and session feature that stores eligible query results for repeated use. Matching queries can read persisted cached results instead of recomputing, reducing compute work, resource usage, and concurrency-slot pressure.
Synapse dedicated SQL pool
intermediate
5 commands
Aliases: result set caching, Synapse result set caching, dedicated SQL pool result cache, cached query results
Quick peek
Open full term page
Analytics
top-250-pre130-priority-upgraded
Dedicated SQL pool
Dedicated SQL pool is a provisioned massively parallel processing data warehouse resource in Azure Synapse Analytics used for relational analytical queries at a selected DWU level in Azure.
Analytics platform
fundamentals
7 commands
Aliases: Dedicated SQL pool
Quick peek
Open full term page
Analytics
learning-path-anchor
Synapse Spark pool
A Synapse Spark pool is the workspace compute definition Azure Synapse uses to start Apache Spark sessions. It records node size, node count, autoscale behavior, runtime version, packages, and idle timeout so notebooks, Spark jobs, and pipelines get repeatable distributed processing.
Synapse Analytics
fundamentals
8 commands
Aliases: Apache Spark pool, Spark pool, Synapse Apache Spark pool, serverless Spark pool
Quick peek
Open full term page
Analytics
learning-path-anchor
Synapse SQL CETAS
Synapse SQL CETAS means CREATE EXTERNAL TABLE AS SELECT. It creates external table metadata and exports the result of a T-SQL SELECT statement in parallel to files in Azure Storage or Azure Data Lake Storage Gen2 for later SQL or lake consumption.
Synapse Analytics
fundamentals
6 commands
Aliases: CREATE EXTERNAL TABLE AS SELECT, CETAS, Synapse CETAS, serverless SQL CETAS
Quick peek
Open full term page
Analytics
learning-path-anchor
Synapse SQL external table
A Synapse SQL external table is database metadata that lets Synapse SQL query files stored outside the database, usually in Azure Storage or ADLS Gen2. It references an external data source, file format, and file location for governed SQL analytics.
Synapse Analytics
fundamentals
6 commands
Aliases: external table in Synapse, Synapse external table, SQL external table, external table over lake files
Quick peek
Open full term page
Analytics
learning-path-anchor
Synapse SQL on-demand
Synapse SQL on-demand is the serverless SQL pool model in Azure Synapse Analytics. It lets teams run T-SQL queries over data in the lake without provisioning dedicated warehouse capacity, storing only metadata objects while using external data sources, views, functions, and security objects.
Synapse Analytics
fundamentals
6 commands
Aliases: SQL on-demand, Synapse serverless SQL, serverless SQL in Synapse, built-in serverless SQL pool
Quick peek
Open full term page
Analytics
learning-path-anchor
Synapse SQL script
A Synapse SQL script is a saved T-SQL authoring artifact in Synapse Studio. Users create or import scripts in the Develop hub, connect them to a dedicated or serverless SQL pool, run queries, review tabular results, export output, and organize scripts into folders.
Synapse Analytics
fundamentals
5 commands
Aliases: SQL script in Synapse, Synapse Studio SQL script, T-SQL script artifact, Synapse query script
Quick peek
Open full term page
Analytics
premium
Synapse SQL
Synapse SQL is the T-SQL analytics capability in Azure Synapse Analytics. It includes dedicated SQL pools for provisioned warehousing and serverless SQL pools for on-demand lake queries, letting teams analyze structured and semi-structured data through familiar SQL endpoints inside a Synapse workspace.
Synapse Analytics
intermediate
7 commands
Aliases: Synapse SQL engine, Azure Synapse SQL, Synapse serverless and dedicated SQL, SQL analytics in Synapse
Quick peek
Open full term page
Analytics
premium
Synapse SQL administrator
A Synapse SQL administrator is the Synapse RBAC role focused on serverless SQL access and SQL artifacts. It grants broad serverless SQL pool permissions plus create, read, update, and delete access to published SQL scripts, credentials, and linked services within a workspace.
Synapse Analytics
intermediate
6 commands
Aliases: Synapse SQL Administrator, Synapse SQL admin, SQL administrator in Synapse, Synapse SQL admin role
Quick peek
Open full term page
Analytics
premium
Serverless SQL pool
Serverless SQL pool in Azure Synapse Analytics lets users query data in the lake with T-SQL without provisioning dedicated SQL compute. It stores only metadata objects in databases, supports SELECT, CETAS, views, credentials, users, and object permissions, and charges based on data processed by queries.
Azure Synapse Analytics
fundamentals
5 commands
Aliases: No aliases yet
Quick peek
Open full term page
Analytics
field-manual-complete
Synapse data explorer pool
A analytics platform concept in Synapse Analytics that helps teams move, transform, query, and govern data at scale with clearer ownership, safety, and operational context.
Synapse Analytics
fundamentals
6 commands
Aliases: Azure Synapse data explorer pool, Data Explorer pool, Kusto pool in Synapse, Synapse Kusto pool, Synapse data explorer pool, legacy Synapse Data Explorer, synapse data explorer pool, synapse-data-explorer-pool
Quick peek
Open full term page
Databases
premium
Azure SQL elastic pool
Azure SQL elastic pool lets multiple Azure SQL databases on one logical server share a set of resources at a set price for variable usage patterns.
Azure SQL Database
fundamentals
5 commands
Aliases: Azure SQL elastic pool, SQL elastic pool, eDTU pool, elastic pool, pooled databases
Quick peek
Open full term page
Databases
complete
SQL elastic pool DTU
SQL elastic pool DTU means an Azure SQL elastic pool sized with the DTU purchasing model.
Data platform
intermediate
5 commands
Aliases: DTU elastic pool, Azure SQL DTU pool, eDTU pool, SQL elastic pool using DTUs
Quick peek
Open full term page
Databases
complete
SQL elastic pool vCore
SQL elastic pool vCore means an Azure SQL elastic pool sized with the vCore purchasing model.
Data platform
intermediate
5 commands
Aliases: vCore elastic pool, Azure SQL vCore pool, SQL elastic pool using vCores, shared vCore pool
Quick peek
Open full term page
Analytics
premium
Azure Synapse Analytics
Azure Synapse Analytics is Microsoft’s integrated analytics service for enterprise data warehousing, big data, data integration, and exploratory analytics.
Synapse Analytics
intermediate
6 commands
Aliases: No aliases yet
Quick peek
Open full term page
Analytics
premium
Serverless SQL external table
A serverless SQL external table in Azure Synapse SQL is a metadata object that references files in Azure Storage or Azure Data Lake Storage. Serverless SQL pools use native external tables to read external data, map columns, apply supported file formats, and support CETAS export patterns.
Azure Synapse Analytics
intermediate
5 commands
Aliases: No aliases yet
Quick peek
Open full term page
Analytics
learning-path-anchor
Synapse Studio
Synapse Studio is the browser-based workspace experience for Azure Synapse Analytics. It exposes hubs for data, development, integration, monitoring, and management, letting users author notebooks and SQL scripts, build pipelines, configure connections, review access, and work with Git-backed or live artifacts.
Synapse Analytics
fundamentals
6 commands
Aliases: Azure Synapse Studio, Synapse web workspace, Synapse workspace UI, Synapse authoring experience
Quick peek
Open full term page
Analytics
learning-path-anchor
Synapse workspace repository
A Synapse workspace repository is where a Synapse workspace saves its authoring artifacts when Git integration is enabled. Instead of every notebook, pipeline, SQL script, linked service, or dataset living only in the live workspace, the team works through branches, commits, pull requests, and a publish branch. That gives data engineers a familiar code-review...
Synapse Analytics
fundamentals
5 commands
Aliases: Synapse Git repository, Synapse source control, Synapse code repository, workspace Git integration
Quick peek
Open full term page
Analytics
learning-path-anchor
Databricks SQL warehouse
A Databricks SQL compute resource for interactive queries, dashboards, BI tools, and governed analytics workloads.
Databricks
intermediate
4 commands
Aliases: SQL warehouse, Databricks SQL compute, serverless SQL warehouse
Quick peek
Open full term page
Analytics
command-rich
Synapse workspace
A Synapse workspace is the main container where a team builds and operates Azure Synapse Analytics. It gives the team one named place for SQL pools, Spark pools, pipelines, notebooks, linked services, access rules, monitoring, and the connection to the default data lake. The workspace is not just a folder in the portal; it...
Analytics platform
fundamentals
9 commands
Aliases: Azure Synapse workspace, Synapse Analytics workspace, workspace in Azure Synapse, Synapse analytics boundary
Quick peek
Open full term page
Analytics
field-manual-complete
Synapse notebook
A Synapse notebook is a web authoring surface in Azure Synapse Analytics for live code, visualizations, and explanatory text. It is commonly used with Apache Spark for data preparation, exploration, machine learning, and repeatable transformations that can run interactively or from pipelines.
Synapse Analytics
fundamentals
8 commands
Aliases: Azure Synapse notebook, Synapse Spark notebook, Synapse Analytics notebook, notebook artifact in Synapse
Quick peek
Open full term page
Analytics
field-manual-complete
Synapse pipeline
A Synapse pipeline is a data-driven workflow in Azure Synapse Analytics that groups activities for moving, transforming, and orchestrating data. It can run manually or from triggers, pass parameters between activities, and record pipeline and activity run history for monitoring.
Synapse Analytics
fundamentals
8 commands
Aliases: Azure Synapse pipeline, Synapse Analytics pipeline, pipeline in Synapse, Synapse data integration pipeline
Quick peek
Open full term page
Analytics
field-manual-complete
Synapse private endpoint
A Synapse private endpoint is an Azure Private Link network interface that lets clients reach a Synapse workspace over a private IP address instead of the public internet. It is used with workspace development, SQL, and private-link patterns to reduce exposure and control network access.
Synapse Analytics
advanced
8 commands
Aliases: Azure Synapse private endpoint, Synapse workspace private endpoint, Private Link for Synapse, private endpoint for Synapse workspace
Quick peek
Open full term page
Analytics
field-manual-complete
Synapse role
A Synapse role is a workspace-level RBAC permission set that controls what users, groups, managed identities, and service principals can do inside Azure Synapse Analytics. Synapse RBAC governs workspace artifacts and actions, while Azure RBAC controls management of the Azure resources.
Synapse Analytics
intermediate
8 commands
Aliases: Azure Synapse role, Synapse RBAC role, Synapse workspace role, Synapse access role
Quick peek
Open full term page
Analytics
verified
OPENROWSET in Synapse
In Azure Synapse serverless SQL pool, OPENROWSET with BULK reads files in Azure Storage and returns them as rows in a query. It can infer or use external data sources, supports formats such as CSV, Parquet, and Delta, and is not supported in dedicated SQL pools.
Synapse Analytics
intermediate
7 commands
Aliases: Synapse OPENROWSET, OPENROWSET serverless SQL pool, serverless SQL OPENROWSET, OPENROWSET BULK in Synapse, Synapse lake query
Quick peek
Open full term page
Analytics
field-manual-complete
Synapse Link
A analytics platform concept in Synapse Analytics that helps teams move, transform, query, and govern data at scale with clearer ownership, safety, and operational context.
Synapse Analytics
advanced
7 commands
Aliases: Azure Synapse Link, Synapse Link, Synapse Link for SQL, link connection, near real-time analytics, synapse Link, synapse link, synapse-link
Quick peek
Open full term page
Analytics
field-manual-complete
Synapse distribution
A analytics platform concept in Synapse Analytics that helps teams move, transform, query, and govern data at scale with clearer ownership, safety, and operational context.
Synapse Analytics
fundamentals
5 commands
Aliases: Azure Synapse distribution, Synapse distribution, dedicated SQL pool distribution, hash distribution, replicated table, round robin distribution, synapse distribution, synapse-distribution
Quick peek
Open full term page
Analytics
field-manual-complete
Synapse lake database
Synapse lake database is documented by Microsoft as part of the Synapse Analytics area in Azure.
Synapse Analytics
fundamentals
5 commands
Aliases: Azure Synapse lake database, Synapse database designer, Synapse lake database, lake database, lake-backed database, metadata over data lake, synapse lake database, synapse-lake-database
Quick peek
Open full term page
Analytics
learning-path-anchor
Synapse workspace managed identity
A Synapse workspace managed identity is the workspace's own identity in Microsoft Entra ID. Instead of saving passwords, keys, or connection strings inside pipelines and notebooks, Synapse can use this identity to ask for tokens and reach trusted Azure resources. It is commonly used for Data Lake Storage, Key Vault, SQL, and linked service...
Synapse Analytics
intermediate
8 commands
Aliases: Synapse managed service identity, Synapse MSI, workspace system-assigned identity, Synapse workspace identity
Quick peek
Open full term page
Analytics
learning-path-anchor
Synapse workspace firewall
A Synapse workspace firewall is the IP allowlist around a Synapse workspace when it accepts public network traffic. It decides which client IPv4 ranges can attempt to connect before identity permissions are evaluated. It does not grant access by itself; a user or service still needs the right Azure, Synapse, or SQL permissions. It...
Synapse Analytics
intermediate
6 commands
Aliases: Synapse IP firewall rule, workspace firewall rule, Synapse workspace IP allowlist, Synapse public endpoint firewall
Quick peek
Open full term page
Databases
learning-path-anchor
Cosmos DB dedicated gateway
Azure Cosmos DB dedicated gateway is provisioned server-side compute that fronts an account and enables the integrated cache for supported NoSQL workloads.
Azure Cosmos DB
fundamentals
3 commands
Aliases: No aliases yet
Quick peek
Open full term page
Analytics
field-manual-complete
Synapse dataset
A data structure referenced by Synapse pipelines.
Data engineering and analytics
intermediate
5 commands
Aliases: Azure Synapse dataset, Azure Synapse dataset JSON, Synapse dataset, dataset linked service, integration dataset, pipeline dataset, synapse dataset, synapse-dataset
Quick peek
Open full term page
Databases
field-manual-complete
Synapse Link for Cosmos DB
Synapse Link for Cosmos DB is the legacy Azure integration that exposes Cosmos DB analytical store to Synapse for near-real-time analytics without custom ETL. Microsoft now directs new projects toward Cosmos DB Mirroring in Microsoft Fabric, so existing deployments need careful governance and migration planning.
Azure Cosmos DB
advanced
5 commands
Aliases: Azure Synapse Link for Azure Cosmos DB, Cosmos DB Synapse Link, Cosmos DB analytical store link, Synapse Link analytical store, HTAP for Cosmos DB
Quick peek
Open full term page
Analytics
field-manual-complete
Synapse managed virtual network
A Synapse managed virtual network is the Azure-managed network boundary associated with a Synapse workspace. It isolates workspace data integration and Spark resources, enables managed private endpoints, and can restrict outbound connectivity to approved targets when data exfiltration protection is enabled at workspace creation.
Synapse Analytics
intermediate
5 commands
Aliases: Azure Synapse managed virtual network, Synapse managed VNet, managed workspace virtual network, Synapse workspace managed VNet
Quick peek
Open full term page
Databases
complete
SQL server
Microsoft Learn describes an Azure SQL server as a logical construct that acts as the central administrative point for databases in Azure SQL Database and Azure Synapse. It provides the namespace, endpoint, region, and policy scope for databases, elastic pools, firewalls, auditing, and related management settings.
Azure SQL administration
intermediate
5 commands
Aliases: Azure SQL logical server, logical SQL server, SQL Database server, Azure SQL server resource
Quick peek
Open full term page
Databases
premium
Dedicated gateway
Dedicated gateway is documented by Microsoft as part of the Azure Cosmos DB area in Azure.
Azure Cosmos DB
intermediate
11 commands
Aliases: No aliases yet
Quick peek
Open full term page
No glossary terms matched that search.
Try a service name, acronym, command group, or category such as RBAC , az group , App Service , Application Insights , Databases , or Azure AI Search .
Clear filters and show matches
Reset search