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 143 matching terms. Narrow the search to reduce the list.
Analytics
top-250-pre130-priority-upgraded
Delta Lake
Delta Lake is an open-source storage layer that extends Parquet data files with a transaction log to support ACID transactions, scalable metadata, and reliable batch and streaming workloads.
Data lake
intermediate
4 commands
Aliases: Delta format, Delta table storage, lakehouse Delta, Delta Lake
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 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
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
Microsoft Fabric lakehouse
Microsoft Fabric lakehouse is a Microsoft Fabric data item that stores files and tables in OneLake while exposing lakehouse-style analytics and engineering experiences. Teams should manage it with clear ownership, monitoring, rollback evidence, and production change discipline.
Microsoft Fabric
intermediate
4 commands
Aliases: Fabric lakehouse, lakehouse item, OneLake lakehouse
Quick peek
Open full term page
Analytics
field-manual-complete
Lakehouse architecture
Lakehouse architecture combines data lake scale with warehouse-style querying, governance, and analytics patterns. On Azure, it commonly uses Delta Lake, OneLake or ADLS storage, Spark, SQL experiences, BI tools, and layered data design such as bronze, silver, and gold at enterprise scale.
Azure Databricks
intermediate
4 commands
Aliases: No aliases yet
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
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 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 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
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
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 field-manual
Medallion architecture
Medallion architecture is a lakehouse data design that organizes data into bronze, silver, and gold layers as quality improves. Teams use it when data teams need a shared pattern for raw ingestion, cleaned data, curated analytics, and trusted consumption. In plain English, it gives operators a named control for clear data quality stages, ownership boundaries, and reusable analytics products 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.
Lakehouse architecture
intermediate
4 commands
Aliases: Medallion architecture, bronze silver gold architecture, medallion lakehouse, bronze silver gold layers, lakehouse medallion pattern, bronze-silver-gold, bronze-silver-gold pattern, Azure Databricks, Microsoft Fabric, and lakehouse platforms, Lakehouse architecture
Quick peek
Open full term page
Storage
learning-path-anchor
Data Lake storage account
A storage feature or access model in Data Lake Storage Gen2 that helps teams store, protect, move, and govern application or analytics data with clearer ownership, safety, and operational context.
Data Lake Storage Gen2
advanced
19 commands
Aliases: No aliases yet
Quick peek
Open full term page
Storage
premium
Data Lake gold layer
The Data Lake gold layer is the business-ready medallion layer where curated, aggregated, and governed data is published for analytics, reporting, and decision support.
Medallion lakehouse architecture
intermediate
5 commands
Aliases: gold layer, gold zone, curated business layer, trusted reporting layer
Quick peek
Open full term page
Storage
premium
Data Lake partition folder
A Data Lake partition folder is a directory pattern, often key=value, that groups files by values such as date, region, tenant, or business domain for efficient reads.
Data Lake Storage Gen2
intermediate
5 commands
Aliases: partition folder, Hive-style partition folder, date partition folder, lake partition path
Quick peek
Open full term page
Storage
premium
Data Lake analytics workload
A production analytics workload that stores, transforms, governs, and serves large data sets from a data lake using Azure services such as ADLS Gen2, Data Factory, Databricks, Synapse, or Fabric.
Data Lake Storage
Intermediate
6 commands
Aliases: No aliases yet
Quick peek
Open full term page
Storage
premium
Data Lake bronze layer
The raw ingestion layer in a lakehouse or medallion architecture where source data first lands with minimal transformation and strong traceability.
Data Lake Storage Gen2
Intermediate
6 commands
Aliases: No aliases yet
Quick peek
Open full term page
Storage
premium
Data Lake curated zone
The governed, consumer-ready area of a data lake where cleaned, conformed, and documented datasets are served for reporting, analytics, AI, or downstream applications.
Data Lake Storage Gen2
Intermediate
6 commands
Aliases: No aliases yet
Quick peek
Open full term page
Storage
premium
Data Lake directory
A directory in Azure Data Lake Storage Gen2 is a hierarchical namespace path segment that can contain files and child directories and can have access controls applied.
Data Lake Storage Gen2
fundamentals
5 commands
Aliases: ADLS directory, Data Lake folder, Gen2 directory, lake folder
Quick peek
Open full term page
Storage
premium
Data Lake file system
A Data Lake file system is the top-level container namespace in Azure Data Lake Storage Gen2 that holds directories and files for analytics workloads.
Data Lake Storage Gen2
fundamentals
5 commands
Aliases: ADLS file system, Data Lake Storage file system, Gen2 file system, lake container
Quick peek
Open full term page
Storage
premium
Data Lake filesystem
Data Lake filesystem is the compact API and CLI naming for the ADLS Gen2 file-system resource that contains directories and files.
Data Lake Storage Gen2
fundamentals
5 commands
Aliases: filesystem, ADLS filesystem, storage fs, Azure storage fs
Quick peek
Open full term page
Storage
premium
Data Lake Gen2 endpoint
A Data Lake Gen2 endpoint is the DFS endpoint on a storage account used by Azure Data Lake Storage Gen2 APIs, ABFS URIs, and hierarchical namespace operations.
Data Lake Storage Gen2
intermediate
5 commands
Aliases: ADLS Gen2 endpoint, DFS endpoint, dfs.core.windows.net endpoint, Data Lake endpoint
Quick peek
Open full term page
Storage
premium
Data Lake ingestion zone
A Data Lake ingestion zone is the controlled landing area where source data first arrives before validation, transformation, enrichment, or publication.
Data Lake Storage Gen2
fundamentals
5 commands
Aliases: landing zone, raw ingestion zone, lake landing area, ingest zone
Quick peek
Open full term page
Storage
premium
Data Lake namespace
A Data Lake namespace is the hierarchical address space in Azure Data Lake Storage Gen2 that organizes file systems, directories, files, and paths for analytics.
Data Lake Storage Gen2
intermediate
5 commands
Aliases: ADLS namespace, hierarchical namespace, HNS namespace, lake namespace
Quick peek
Open full term page
Storage
premium
Data Lake path ACL
A Data Lake path ACL is the access control list applied to a file or directory path in Azure Data Lake Storage Gen2 for fine-grained permissions.
Data Lake Storage Gen2
intermediate
5 commands
Aliases: ADLS path ACL, Data Lake path access control, path access control list, data-lake-path-ac
Quick peek
Open full term page
Storage
premium
Data Lake raw zone
A storage feature or access model in Data Lake Storage Gen2 that helps teams store, protect, move, and govern application or analytics data with clearer ownership, safety, and operational context.
Data Lake Storage Gen2
fundamentals
5 commands
Aliases: No aliases yet
Quick peek
Open full term page
Storage
premium
Data Lake silver layer
A storage feature or access model in Data Lake Storage Gen2 that helps teams store, protect, move, and govern application or analytics data with clearer ownership, safety, and operational context.
Data Lake Storage Gen2
fundamentals
5 commands
Aliases: No aliases yet
Quick peek
Open full term page
Storage
premium
Filesystem in Data Lake Storage
Filesystem in Data Lake Storage is the top-level container-like namespace in Azure Data Lake Storage Gen2 that holds directories and files in Azure.
Data Lake Storage Gen2
intermediate
4 commands
Aliases: Filesystem in Data Lake Storage, filesystem in data lake storage
Quick peek
Open full term page
Storage
field-manual-complete
Data Lake Storage Gen2
Data Lake Storage Gen2 is Azure Blob Storage with a hierarchical namespace enabled for analytics workloads. Microsoft Learn describes it as combining file-system style directories, ACLs, and large-scale throughput with Blob Storage durability, security, lifecycle, tiering, and ecosystem compatibility for big data scenarios.
Analytics storage
fundamentals
8 commands
Aliases: ADLS Gen2
Quick peek
Open full term page
Storage
field-manual-complete
Data Lake path
A Data Lake path is the directory or file location inside an ADLS Gen2 file system, where permissions, pipelines, and analytics jobs meet data layout.
Data Lake Storage Gen2
fundamentals
5 commands
Aliases: ADLS path, lake path, Data Lake directory path
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
Lake database
A lake database in Azure Synapse Analytics combines database design, metadata, and storage layout for data stored in the lake, helping teams describe structure and query files through shared Spark and serverless SQL metadata without turning the data lake into a traditional database.
Analytics platform
intermediate
4 commands
Aliases: No aliases yet
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 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
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
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
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
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 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
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
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
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