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 407 matching terms. Narrow the search to reduce the list.
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
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 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 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 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 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
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
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 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
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
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
premium
Synapse workspace key
A Synapse workspace key is the customer-managed encryption key that a Synapse workspace uses when an organization does not want to rely only on Microsoft-managed encryption. The key is stored in Azure Key Vault, and the workspace references it by name and key identifier. For operators, this is not just a checkbox. The key...
Synapse Analytics
fundamentals
8 commands
Aliases: Synapse customer-managed key, Synapse CMK, workspace encryption key, Synapse workspace customer-managed key
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 workspace package
A Synapse workspace package is a library file stored at the workspace level so Spark workloads can use custom code or pinned dependencies. Instead of downloading a library manually in every notebook, the team uploads a wheel, JAR, or R package archive and attaches it to Spark pools that need it. This is helpful...
Synapse Analytics
fundamentals
7 commands
Aliases: Synapse workspace library, Synapse Spark workspace package, workspace package file, Synapse custom Spark package
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
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 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 Apache Spark
Synapse Apache Spark is the big-data processing engine inside Azure Synapse Analytics. It lets teams run Spark code without building and maintaining their own cluster platform. Data engineers use it to clean files, join large datasets, prepare lakehouse tables, explore data in notebooks, and run batch transformations. It works with a Synapse workspace, Spark pools, storage such as Azure Data Lake Storage, identities, libraries, and monitoring. The main value is scalable data processing with Azure-managed operational pieces.
Azure Synapse Analytics
intermediate
6 commands
Aliases: Apache Spark in Synapse, Synapse Spark, Azure Synapse Spark, Spark in Azure Synapse Analytics
Quick peek
Open full term page
Analytics
field-manual-complete
Synapse Apache Spark notebook
A Synapse Apache Spark notebook is an interactive workbook for Spark code inside a Synapse workspace. Data engineers and analysts use cells to read data, transform it, visualize samples, and test logic before turning it into a scheduled job or pipeline step. The notebook itself is not the compute; it attaches to a Spark pool that runs the work. This makes it useful for exploration and production preparation, but it also needs source control, parameter discipline, access review, and cost awareness.
Azure Synapse Analytics
intermediate
6 commands
Aliases: Synapse Spark notebook, Apache Spark notebook in Synapse, Synapse notebook, Spark notebook
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
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
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
field-manual-complete
Synapse linked service
A Synapse linked service is a JSON-defined connection object that tells Azure Synapse how to reach a data store, compute service, or external system. Datasets and pipeline activities reference it so connection details, authentication, endpoints, and integration runtime choices are managed separately from activity logic.
Synapse Analytics
advanced
5 commands
Aliases: Azure Synapse linked service, Synapse connection artifact, Synapse linked-service JSON, ADF linked service in Synapse
Quick peek
Open full term page
Analytics
field-manual-complete
Synapse managed private endpoint
A Synapse managed private endpoint is a private endpoint that Azure Synapse creates inside a workspace managed virtual network to reach a specific Azure resource over Private Link. It supports approved, resource-scoped connectivity for storage, databases, Cosmos DB, and other targets without opening public network paths.
Synapse Analytics
intermediate
5 commands
Aliases: Azure Synapse managed private endpoint, Synapse MPE, managed private endpoint in Synapse, Synapse Private Link endpoint
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
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
Change data capture in Data Factory
A Data Factory capability for processing changed data from supported sources.
Data integration
intermediate
10 commands
Aliases: CDC
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
Azure Data Explorer
A fully managed, high-performance analytics service for near-real-time analysis of large telemetry, log, event, and time-series datasets.
Real-time analytics
intermediate
5 commands
Aliases: ADX, Kusto
Quick peek
Open full term page
Analytics
premium
Azure Databricks
A unified, open analytics platform on Azure for building, deploying, sharing, and maintaining enterprise data, analytics, and AI solutions at scale.
Data engineering and AI
intermediate
5 commands
Aliases: Databricks on Azure
Quick peek
Open full term page
Databases
premium
Azure SQL auditing
Azure SQL auditing tracks database events and writes audit logs to supported destinations such as storage, Log Analytics, or Event Hubs.
Azure SQL Database
fundamentals
5 commands
Aliases: Azure SQL audit logs, Azure SQL auditing, SQL auditing, database auditing
Quick peek
Open full term page
Analytics
premium
Data warehouse unit
Data warehouse unit is documented by Microsoft as part of the Synapse Analytics area in Azure.
Synapse Analytics
intermediate
5 commands
Aliases: No aliases yet
Quick peek
Open full term page
Analytics
premium
Pipeline parameter
In Azure Data Factory and Azure Synapse pipelines, a pipeline parameter is a run-time input defined at the pipeline level. It cannot be modified during a run, but manual starts, triggers, parent pipelines, and activities can pass values that control paths, settings, filters, or behavior.
Data Factory
fundamentals
5 commands
Aliases: No aliases yet
Quick peek
Open full term page
Analytics
premium
Pipeline variable
In Azure Data Factory and Azure Synapse, a pipeline variable is a value stored within a pipeline run and changed by activities such as Set Variable. Variables are scoped to the pipeline, support String, Bool, and Array types, and are not safe for parallel mutation.
Data Factory
fundamentals
5 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
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
premium
Data Factory connector
A built-in or configured integration capability that lets Data Factory read from or write to a supported data store, SaaS application, or service endpoint.
Data integration and orchestration
Intermediate
4 commands
Aliases: Data Factory connector, ADF connector, data factory connector
Quick peek
Open full term page
Analytics
premium
Data Factory expression language
The syntax and function set used in Data Factory to build dynamic values, reference parameters, inspect activity output, and control pipeline behavior.
Data integration and orchestration
Intermediate
4 commands
Aliases: Data Factory expression language, ADF expression language, data factory expression language
Quick peek
Open full term page
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
premium
Distribution column
A distribution column is the column used by a hash-distributed dedicated SQL pool table to assign rows across distributions for parallel query processing.
Dedicated SQL pool
intermediate
4 commands
Aliases: Synapse distribution column, hash distribution column, dedicated SQL pool distribution column, distributed table column
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