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 100 of 211 analytics terms. Narrow the search to reduce the list.
Analytics
learning-path-anchor
Databricks metastore
The top-level Unity Catalog container for catalogs, schemas, tables, volumes, models, functions, and governance permissions.
Databricks
intermediate
4 commands
Aliases: Unity Catalog metastore, Databricks Unity Catalog metastore, metastore
Quick peek
Open full term page
Analytics
learning-path-anchor
Databricks MLflow
The managed MLflow experience in Azure Databricks for experiments, runs, metrics, artifacts, model lineage, and MLOps evidence.
Databricks
fundamentals
4 commands
Aliases: MLflow on Databricks, Databricks experiment tracking, MLflow tracking
Quick peek
Open full term page
Analytics
learning-path-anchor
Databricks model serving
A managed serving endpoint pattern for exposing Databricks models or AI workloads for online inference with operational controls.
Databricks
intermediate
4 commands
Aliases: Databricks Model Serving, serving endpoint, model serving endpoint
Quick peek
Open full term page
Analytics
learning-path-anchor
Databricks notebook
A collaborative Azure Databricks document for code, SQL, visualizations, exploration, jobs, and ML workflows attached to compute.
Databricks
fundamentals
4 commands
Aliases: Azure Databricks notebook, Databricks workspace notebook, interactive notebook
Quick peek
Open full term page
Analytics
learning-path-anchor
Databricks Photon
The native vectorized Azure Databricks engine for accelerating eligible SQL, DataFrame, ETL, and streaming workloads.
Databricks
intermediate
4 commands
Aliases: Photon engine, Photon acceleration, Databricks vectorized engine
Quick peek
Open full term page
Analytics
learning-path-anchor
Databricks repo
A workspace Git integration, now called Git folders, for versioning notebooks and files used in Databricks development and CI/CD.
Databricks
fundamentals
4 commands
Aliases: Databricks Repos, Databricks Git folder, Azure Databricks Git folders, workspace Git folder
Quick peek
Open full term page
Analytics
learning-path-anchor
Databricks schema
A Unity Catalog namespace under a catalog that groups tables, views, volumes, models, functions, and permissions.
Databricks
fundamentals
4 commands
Aliases: Unity Catalog schema, Databricks database schema, schema in Unity Catalog
Quick peek
Open full term page
Analytics
learning-path-anchor
Databricks secret scope
A named Databricks collection of secrets used to store credentials and grant controlled read or manage access to workloads.
Databricks
fundamentals
4 commands
Aliases: Databricks secrets scope, secret scope, Azure Databricks secrets
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
learning-path-anchor
Databricks table
A governed Databricks data object, commonly managed, external, or foreign, queried through Unity Catalog and optimized for analytics.
Databricks
fundamentals
4 commands
Aliases: Unity Catalog table, Delta table in Databricks, Databricks managed table
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
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 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
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 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 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 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
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
command-rich
Watermark column
In Azure Data Factory incremental copy patterns, a watermark column is a source column, often a last-modified timestamp or increasing key, used to identify rows created or changed since the previous run. The maximum value becomes the next stored watermark.
Data engineering and analytics
intermediate
5 commands
Aliases: incremental copy watermark column, high watermark column, delta load column, LastModified watermark
Quick peek
Open full term page
Analytics
premium
Activity
Activity is a single work step inside an Azure Data Factory or Synapse pipeline. In everyday Azure work, teams use it to copy data, run a notebook, call a web endpoint, validate a condition, or control pipeline branching. The useful evidence is activity type, dependencies, retry policy, linked service, inputs, outputs, and run status. Treat
Data Factory
fundamentals
5 commands
Aliases: Data Factory activity, pipeline activity, Synapse pipeline activity
Quick peek
Open full term page
Analytics
premium
Activity run
Activity run is the execution record for one Azure Data Factory or Synapse pipeline activity during a specific pipeline run. In everyday Azure work, teams use it to pinpoint which step ran, failed, retried, timed out, or produced unexpected output. The useful evidence is run ID, activity name, type, start time, duration, status, error message,
Data Factory monitoring
intermediate
4 commands
Aliases: Data Factory activity run, Synapse activity run, pipeline activity execution
Quick peek
Open full term page
Analytics
premium
ADX dashboard
ADX dashboard is an Azure Data Explorer dashboard made of KQL-backed tiles and visuals for exploring telemetry or time-series data. In everyday Azure work, teams use it to turn Kusto queries into shared operational views for incidents, trends, business metrics, or engineering reviews. The useful evidence is dashboard owner, data source, base query, tile query,
Azure Data Explorer
intermediate
4 commands
Aliases: Azure Data Explorer dashboard, Kusto dashboard, ADX visualization dashboard
Quick peek
Open full term page
Analytics
premium
Apache Spark job
An Apache Spark job is a submitted Spark workload, often defined in Azure Synapse as a job definition, that runs batch or streaming code on a Spark pool.
Azure Synapse Analytics
intermediate
3 commands
Aliases: No aliases yet
Quick peek
Open full term page
Analytics
premium
Auto Loader
Auto Loader is the Azure Databricks feature that watches cloud storage and brings in new files without forcing engineers to rescan everything manually. In plain terms, it is a safer ingestion pattern for folders that keep receiving CSV, JSON, Parquet, images, or other data files. It can process existing files, then continue with new.
Analytics platform
intermediate
4 commands
Aliases: Databricks Auto Loader, cloudFiles, Auto Loader cloud files, Lakeflow Auto Loader
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
Analytics
premium
Azure Databricks Unity Catalog
A unified governance layer in Azure Databricks for data and AI assets, including catalogs, schemas, tables, volumes, models, privileges, and lineage.
Data governance
intermediate
5 commands
Aliases: Unity Catalog
Quick peek
Open full term page
Analytics
premium
Azure integration runtime
Azure integration runtime is the compute infrastructure used by Azure Data Factory and Synapse pipelines to move data, dispatch activities, and connect across network environments.
Data integration compute
intermediate
5 commands
Aliases: Integration Runtime, IR, ADF integration runtime
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
Azure-SSIS integration runtime
Azure-SSIS integration runtime is Azure Data Factory or Azure Synapse compute that lets organizations deploy, run, and manage SQL Server Integration Services packages in Azure.
Data Factory
intermediate
5 commands
Aliases: Azure SSIS integration runtime, Azure-SSIS IR
Quick peek
Open full term page
Analytics
premium
Azure-SSIS IR
Azure-SSIS IR is the Azure integration runtime option that supports deploying, managing, and running SQL Server Integration Services packages in Azure Data Factory or Synapse pipelines.
Data engineering and analytics
intermediate
5 commands
Aliases: Azure SSIS IR, Azure-SSIS integration runtime abbreviation
Quick peek
Open full term page
Analytics
premium
CETAS
Create External Table As Select, a pattern for writing query results to external storage.
Analytics platform
intermediate
8 commands
Aliases: Create External Table As Select
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
Copy activity
A analytics platform concept in Data Factory that helps teams move, transform, query, and govern data at scale with clearer ownership, safety, and operational context.
Data Factory
fundamentals
3 commands
Aliases: No aliases yet
Quick peek
Open full term page
Analytics
premium
Data Factory
Azure’s managed data integration service for creating pipelines that move, transform, schedule, and orchestrate data across cloud, SaaS, and hybrid stores.
Data integration and orchestration
Intermediate
6 commands
Aliases: Data Factory, Data Factory, data factory
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 debug run
An interactive test execution used while authoring a Data Factory pipeline or data flow before publishing or triggering it in production.
Data integration and orchestration
Intermediate
4 commands
Aliases: Data Factory debug run, ADF debug run, data factory debug run
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
Data Factory Git integration
The source-control connection that lets Data Factory authoring use Azure Repos or GitHub branches instead of editing only the live factory mode.
Data integration and orchestration
Intermediate
4 commands
Aliases: Data Factory Git integration, ADF Git integration, data factory git integration
Quick peek
Open full term page
Analytics
premium
Data Factory global parameter
A factory-level constant that pipelines can reference in expressions and that CI/CD can override per environment.
Data integration and orchestration
Intermediate
4 commands
Aliases: Data Factory global parameter, ADF global parameter, data factory global parameter
Quick peek
Open full term page
Analytics
premium
Data Factory managed identity
The Microsoft Entra identity assigned to a Data Factory so pipelines and linked services can access Azure resources without embedded passwords.
Data integration and orchestration
Intermediate
4 commands
Aliases: Data Factory managed identity, ADF managed identity, data factory managed identity
Quick peek
Open full term page
Analytics
premium
Data Factory managed virtual network
A Microsoft-managed network boundary used by Azure Integration Runtime to isolate data integration traffic and connect through managed private endpoints.
Data integration and orchestration
Intermediate
4 commands
Aliases: Data Factory managed virtual network, ADF managed virtual network, data factory managed virtual network
Quick peek
Open full term page
Analytics
premium
Data Factory monitoring
The operational view of Data Factory pipeline runs, activity runs, trigger history, integration runtime health, metrics, logs, and alerts.
Data integration and orchestration
Intermediate
4 commands
Aliases: Data Factory monitoring, ADF monitoring, data factory monitoring
Quick peek
Open full term page
Analytics
premium
Data Factory parameter
A read-only value passed into a Data Factory pipeline, dataset, linked service, or data flow so behavior can change at run time.
Data integration and orchestration
Intermediate
4 commands
Aliases: Data Factory parameter, ADF parameter, data factory parameter
Quick peek
Open full term page
Analytics
premium
Data Factory pipeline
A logical grouping of Data Factory activities that performs a coordinated data movement, transformation, or control-flow process.
Data integration and orchestration
Intermediate
5 commands
Aliases: Data Factory pipeline, ADF pipeline, data factory pipeline
Quick peek
Open full term page
Analytics
premium
Data Factory private endpoint
A Private Link connection that exposes Data Factory or related data movement targets through a private IP address instead of a public network path.
Data integration and orchestration
Intermediate
4 commands
Aliases: Data Factory private endpoint, ADF private endpoint, data factory private endpoint
Quick peek
Open full term page
Analytics
premium
Data Factory publish branch
The repository branch where Data Factory stores generated ARM templates after publishing from the collaboration branch.
Data integration and orchestration
Intermediate
4 commands
Aliases: Data Factory publish branch, ADF publish branch, data factory publish branch
Quick peek
Open full term page
Analytics
premium
Data Factory variable
A mutable pipeline-scoped value that Data Factory activities can set and read during a pipeline run.
Data integration and orchestration
Intermediate
4 commands
Aliases: Data Factory variable, ADF variable, data factory variable
Quick peek
Open full term page
Analytics
premium
Data flow cluster
The managed Spark compute that Azure Data Factory or Synapse uses to execute a mapping data flow during a debug session or scheduled pipeline run.
Data Factory
Intermediate
5 commands
Aliases: No aliases yet
Quick peek
Open full term page
Analytics
premium
Data flow debug
An interactive mapping data flow mode that lets designers preview transformed data and expression results by using an active Spark debug session.
Data Factory
Intermediate
5 commands
Aliases: No aliases yet
Quick peek
Open full term page
Analytics
premium
Data flow debug cluster
The live Spark cluster started for a mapping data flow debug session so designers can preview data and run transformation logic interactively.
Data Factory
Intermediate
5 commands
Aliases: No aliases yet
Quick peek
Open full term page
Analytics
premium
Data flow debug session
The active design-time session that keeps data flow debug compute available for previewing transformations, expressions, and pipeline debug activity behavior.
Data Factory
Intermediate
5 commands
Aliases: No aliases yet
Quick peek
Open full term page
Analytics
premium
Data flow sink
The mapping data flow transformation that writes processed rows to a target dataset, table, file path, or inline destination at the end of a flow branch.
Data Factory
Intermediate
5 commands
Aliases: No aliases yet
Quick peek
Open full term page
Analytics
premium
Data flow source
The mapping data flow transformation that reads input rows from a dataset or inline source before downstream transformations reshape the data.
Data Factory
Intermediate
5 commands
Aliases: No aliases yet
Quick peek
Open full term page
Analytics
premium
Data flow transformation
A visual operation in a mapping data flow that changes, filters, joins, aggregates, derives, routes, or otherwise reshapes rows between source and sink.
Data Factory
Intermediate
5 commands
Aliases: No aliases yet
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
Databricks access connector
A first-party Azure resource that gives Azure Databricks a managed identity for Unity Catalog storage credentials and other governed service access.
Azure Databricks
intermediate
6 commands
Aliases: Access Connector for Azure Databricks, Azure Databricks access connector, Databricks managed identity connector
Quick peek
Open full term page
Analytics
premium
Databricks catalog
The top-level Unity Catalog namespace that organizes schemas, tables, views, volumes, models, functions, permissions, lineage, and governed data ownership.
Azure Databricks
fundamentals
6 commands
Aliases: Unity Catalog catalog, Azure Databricks catalog, catalog object
Quick peek
Open full term page
Analytics
premium
Databricks cluster
A Databricks compute resource that runs notebooks, jobs, libraries, Spark workloads, and data processing tasks using configured runtime, workers, policies, and access controls.
Azure Databricks
fundamentals
6 commands
Aliases: Databricks compute, Azure Databricks compute cluster, classic cluster
Quick peek
Open full term page
Analytics
premium
Databricks cluster policy
A Databricks governance object that limits which cluster settings users can choose, helping control cost, security, runtime consistency, and workload standards.
Azure Databricks
intermediate
6 commands
Aliases: Databricks compute policy, cluster policy, compute policy
Quick peek
Open full term page
Analytics
premium
Databricks DBFS
The Databricks file-system abstraction behind dbfs:/ paths, useful for workspace files and legacy mounts but carefully governed alongside Unity Catalog.
Azure Databricks
fundamentals
6 commands
Aliases: DBFS, Databricks File System, dbfs:/
Quick peek
Open full term page
Analytics
premium
Databricks job
A scheduled or triggered Databricks workflow that runs one or more tasks using configured compute, parameters, retries, notifications, and access controls.
Azure Databricks
fundamentals
7 commands
Aliases: Databricks workflow job, Lakeflow Job, Databricks Jobs
Quick peek
Open full term page
Analytics
premium
Databricks managed resource group
The Azure resource group created or referenced for Databricks-managed infrastructure that supports a workspace and its classic compute resources.
Azure Databricks
intermediate
6 commands
Aliases: managed resource group, Azure Databricks managed resource group, workspace managed resource group
Quick peek
Open full term page
Analytics
premium
Databricks workflow
A Databricks workflow is a scheduled or triggered orchestration of tasks in Azure Databricks, commonly managed through Lakeflow Jobs, for running notebooks, SQL, pipelines, scripts, and production data workloads.
Data engineering and analytics
intermediate
5 commands
Aliases: Databricks Jobs workflow, Lakeflow Jobs workflow, Databricks scheduled workflow, Databricks orchestration
Quick peek
Open full term page
Analytics
premium
Databricks workspace
A Databricks workspace is the Azure resource and collaborative environment where teams create and operate notebooks, jobs, clusters, SQL warehouses, repositories, experiments, and governed data access.
Analytics platform
beginner
5 commands
Aliases: Azure Databricks workspace, Databricks workspace resource, workspace resource, Databricks environment
Quick peek
Open full term page
Analytics
premium
Databricks workspace Private Link
Databricks workspace Private Link is the Azure Private Link configuration that provides private connectivity paths to Azure Databricks workspace resources and related Databricks services without exposing traffic to the public internet.
Azure Databricks
advanced
5 commands
Aliases: Azure Databricks Private Link, Databricks private endpoint, workspace private endpoint, front-end Private Link
Quick peek
Open full term page
Analytics
premium
Databricks workspace VNet injection
Databricks workspace VNet injection is the deployment model that places Azure Databricks compute resources into customer-managed virtual network subnets so network security, routing, and private connectivity controls can be applied.
Databricks
advanced
5 commands
Aliases: VNet-injected Databricks workspace, customer-managed VNet workspace, Databricks VNet injection, workspace in customer VNet
Quick peek
Open full term page
Analytics
premium
Dataset
A dataset is a logical description of data used by analytics or integration services; in Azure Data Factory and Synapse pipelines, it describes the data structure, location, and linked service used by activities.
Data integration
beginner
5 commands
Aliases: data set, logical dataset, pipeline dataset, data reference
Quick peek
Open full term page
Analytics
premium
Dataset in Data Factory
A dataset in Data Factory is a named JSON definition that describes the data an activity reads or writes, including the linked service, dataset type, path, table, schema, parameters, and annotations.
Data Factory
beginner
5 commands
Aliases: ADF dataset, Azure Data Factory dataset, Data Factory dataset definition, Synapse dataset
Quick peek
Open full term page
Analytics
premium
Dataset parameter
A dataset parameter is a named value on a Data Factory or Synapse dataset that lets pipelines pass runtime information such as folder, file, schema, table, or partition values into a reusable dataset definition.
Data engineering and analytics
intermediate
5 commands
Aliases: ADF dataset parameter, Data Factory dataset parameter, parameterized dataset, dataset runtime value
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
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
Delta Lake table
A Delta Lake table is a Databricks table stored in Delta format, using data files and a transaction log to support reliable reads, writes, metadata, and table history.
Delta Lake
fundamentals
4 commands
Aliases: Delta table in Delta Lake, Databricks Delta Lake table, Delta format table, lakehouse Delta table
Quick peek
Open full term page
Analytics
premium
Delta Live Tables
Delta Live Tables is the former name for Lakeflow Spark Declarative Pipelines, a Databricks framework for declarative batch and streaming pipelines using SQL or Python.
Azure Databricks
intermediate
4 commands
Aliases: DLT, Lakeflow Spark Declarative Pipelines, Databricks declarative pipelines, Lakeflow pipelines
Quick peek
Open full term page
Analytics
premium
Delta table
A Delta table is a table stored in Delta Lake format, combining Parquet data files with a transaction log for reliable batch, streaming, and SQL operations.
Delta Lake
fundamentals
4 commands
Aliases: Databricks Delta table, Delta format table, Delta Lake table, managed Delta table
Quick peek
Open full term page
Analytics
premium
Delta time travel
Delta time travel is the ability to query or restore earlier versions of a Delta table by using the table history stored in the Delta transaction log.
Delta Lake
intermediate
5 commands
Aliases: Delta Lake time travel, table version query, query previous Delta version, restore Delta table version
Quick peek
Open full term page
Analytics
premium
Delta transaction log
The Delta transaction log is the file-based record that tracks Delta table commits, metadata, protocol information, and data-file actions for reliable table operations.
Delta Lake
intermediate
5 commands
Aliases: Delta log, _delta_log, Delta Lake log, Delta table log
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
Analytics
premium
Event trigger
An Event trigger starts an Azure Data Factory or Synapse pipeline in response to supported storage events such as blob creation or deletion. Teams use it to start pipelines automatically when files land, folders change, or storage events indicate that a data integration workflow should run. It is not a scheduled trigger, a tumbling-window trigger, an Event Hubs consumer, or a guarantee that the file is complete and ready for every downstream transformation. In production, confirm factory name, trigger state, storage scope, blob path filters, event type, target pipeline, parameter mapping, managed identity access, publish branch state, and run history.
Data Factory
intermediate
6 commands
Aliases: storage event trigger, Data Factory event trigger, event-based trigger
Quick peek
Open full term page
Analytics
premium
Execute Pipeline activity
The Execute Pipeline activity lets an Azure Data Factory or Synapse pipeline invoke another pipeline as part of a control-flow workflow. Teams use it to compose reusable parent and child pipelines, pass parameters, and control whether the parent waits for the child pipeline to finish. It is not a copy activity, a trigger, a stored procedure call, or a guarantee that child pipelines share variables or error handling automatically. In production, confirm parent pipeline, child pipeline, parameter map, wait-on-completion setting, activity output, run IDs, failure policy, publish branch, and monitoring evidence for both runs before treating the design as.
Data integration
intermediate
6 commands
Aliases: Execute Pipeline, child pipeline activity, pipeline invocation activity
Quick peek
Open full term page
Analytics
premium
Expression language
Expression language is the Azure Data Factory and Azure Synapse syntax used to build dynamic values, parameters, conditions, and function calls inside pipeline definitions. Teams use it to make pipeline paths, dates, conditions, parameters, linked-service values, and activity settings change at runtime instead of being hard-coded. It is not general programming code, a SQL dialect, a security boundary, or a guarantee that dynamic values are valid for every dataset and trigger context. In production, confirm expression syntax, parameter names, variable scope, activity output references, trigger metadata, evaluated values, published JSON, debug runs, run IDs, and downstream paths or queries before.
Data Factory
intermediate
6 commands
Aliases: ADF expression language, Data Factory expression language, pipeline expression language, dynamic content
Quick peek
Open full term page
Analytics
premium
External data source
An External data source is a database object that defines the location and connection information used by SQL engines to access external data. Teams use it to point serverless SQL, dedicated SQL pools, or PolyBase-style queries to data stored outside the database, such as Azure Storage or Data Lake paths. It is not the external table schema, the file format definition, the storage account itself, or proof that the credential can read every file under the path.
Synapse SQL and data virtualization
intermediate
6 commands
Aliases: CREATE EXTERNAL DATA SOURCE, PolyBase external data source, Synapse external data source
Quick peek
Open full term page
Analytics
premium
External file format
An External file format is a database object that describes the file type, delimiter, compression, and parsing options used to read or write external data. Teams use it to tell SQL engines how to interpret external files such as delimited text, Parquet, ORC, or compressed data before external tables and CETAS jobs use them. It is not the data source location, the external table schema, the actual lake file, or a guarantee that every file in a folder has the same structure.
Synapse SQL and data virtualization
intermediate
6 commands
Aliases: CREATE EXTERNAL FILE FORMAT, PolyBase file format, Synapse external file format
Quick peek
Open full term page
Analytics
premium
External table
An External table is a SQL table definition whose data is stored outside the database, commonly in Azure Storage or Azure Data Lake Storage. Teams use it to let SQL users query lake files or remote data through familiar table names while the actual data remains in external storage. It is not a managed internal database table, a copy of the data, a storage access policy, or proof that the external files are optimized, fresh, or secure.
Synapse SQL and data virtualization
intermediate
6 commands
Aliases: Synapse external table, SQL external table, PolyBase external table
Quick peek
Open full term page
Analytics
premium
Fabric capacity
A Fabric capacity is a dedicated pool of compute resources that powers Microsoft Fabric workloads assigned to workspaces. Teams use it to provide shared compute for Fabric workspaces, reports, lakehouses, warehouses, notebooks, pipelines, and real-time workloads under an assigned capacity SKU. It is not a single workspace, a Power BI report, a storage account, a Databricks cluster, or a guarantee that every tenant workload has unlimited performance. In production, confirm capacity name, SKU, region, admin list, assigned workspaces, workload settings, metrics app evidence, throttling, refresh history, pause state, billing owner, and reservation or scaling plan before treating the design as.
Microsoft Fabric
intermediate
6 commands
Aliases: Microsoft Fabric capacity, Fabric F SKU, Fabric compute capacity
Quick peek
Open full term page
Analytics
premium
ForEach activity
A ForEach activity is an Azure Data Factory or Azure Synapse pipeline control-flow activity that iterates over a collection and executes child activities for each item. Teams use it to run repeatable pipeline steps for files, tables, partitions, API pages, customers, dates, or metadata-driven work items without manually building one activity per item. It is not a mapping data flow transformation, a guarantee of ordered execution when parallelism is enabled, a substitute for idempotent design, or a safe pattern for unlimited fan-out.
Azure Data Factory
intermediate
6 commands
Aliases: ADF ForEach activity, Azure Data Factory ForEach, Synapse ForEach activity, pipeline loop activity
Quick peek
Open full term page
Analytics
premium
Get Metadata activity
Get Metadata activity is a pipeline step in Azure Data Factory or Synapse that reads information about data instead of copying or transforming the data itself. Teams use it to check whether files exist, list folders, inspect file size or structure, and decide what later pipeline activities should do. In daily Azure work, it shows up when engineers build metadata-driven ingestion, validate landing-zone files, branch with If Condition, loop over child items, or troubleshoot why a copy activity found no input.
Data Factory
beginner
3 commands
Aliases: ADF Get Metadata, Synapse Get Metadata, metadata activity
Quick peek
Open full term page
Analytics
premium
Global parameter
Global parameter is a Data Factory value defined once at the factory level so multiple pipelines can reference the same environment or configuration setting. Teams use it to avoid hardcoding repeated values such as storage containers, environment names, control-table names, feature flags, or standard paths across many pipelines. In daily Azure work, it shows up when engineers author pipeline expressions, promote factories through CI/CD, override values per environment, debug parameterized datasets, or troubleshoot missing deployment parameters.
Data Factory
beginner
4 commands
Aliases: ADF global parameter, Data Factory global parameter, factory global parameter
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
premium
Hopping window
Hopping window is a Stream Analytics time window that moves forward by a fixed hop while each event can belong to more than one overlapping window.
Stream Analytics
intermediate
4 commands
Aliases: HOPPINGWINDOW, Stream Analytics hopping window, Hopping window, hopping-window
Quick peek
Open full term page
Analytics
premium
Incremental copy
Incremental copy is the Azure concept that controls how data platforms move changes without reprocessing every source row or file. Teams see it when working with data factory pipelines, copy activity. It is not a full reload, a one-time migration, a backup job, or a blind append into a lake; that distinction matters because bad assumptions create duplicate records, missed changes. Use the term when reviewing ownership, access, monitoring, cost, recovery, or performance. It keeps architects, operators, security reviewers, and support teams focused on the same resource, setting, or behavior.
Azure Data Factory
Intermediate
5 commands
Aliases: incremental load, delta copy, watermark copy, CDC copy, last modified copy
Quick peek
Open full term page
Analytics
premium
Ingestion mapping
Ingestion mapping controls how streaming or batch data lands in the correct Kusto columns without corrupting schema, losing values, or forcing manual parsing later. Teams see it in azure data explorer tables, kusto databases. It is not a query projection, update policy, table schema alone, Data Factory mapping data flow, or index projection; confusing them can create null columns, failed ingestion. Use the term when reviewing access, monitoring, cost, recovery, or performance. It keeps architects, operators, security reviewers, and support teams focused on the same setting, resource, or behavior.
Azure Data Explorer
Intermediate
5 commands
Aliases: Kusto ingestion mapping, ADX ingestion mapping, table ingestion mapping, JSON ingestion mapping, CSV ingestion mapping
Quick peek
Open full term page
Analytics
premium
Kusto cache policy
Kusto cache policy controls which Azure Data Explorer data is kept in hot local cache versus colder storage for faster queries and managed cost.
Azure Data Explorer policies
Advanced
5 commands
Aliases: ADX cache policy, hot cache policy, Kusto hot cache, Azure Data Explorer caching policy
Quick peek
Open full term page
Analytics
premium
Kusto cluster
Kusto cluster is the Azure Data Explorer compute resource that hosts databases, ingestion, query processing, scale settings, networking, and monitoring for Kusto workloads.
Azure Data Explorer infrastructure
Intermediate
5 commands
Aliases: Azure Data Explorer cluster, ADX cluster, Microsoft.Kusto cluster
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