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 1,988 matching terms. Narrow the search to reduce the list.
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
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
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
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 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
Azure Storage Actions
Azure Storage Actions is a fully managed platform for automating data management tasks across Azure Blob Storage and Azure Data Lake Storage objects without provisioning separate compute.
Storage platform
intermediate
4 commands
Aliases: No aliases yet
Quick peek
Open full term page
Storage
premium
Azure Storage Discovery
Azure Storage Discovery is a fully managed service that provides enterprise-wide visibility into Azure Blob Storage and Azure Data Lake Storage estates for analysis, optimization, security, and operations.
Storage platform
intermediate
3 commands
Aliases: No aliases yet
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
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
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
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
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
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
Integration
premium
Event Hubs capture
Event Hubs Capture automatically writes streaming data from an event hub to Azure Blob Storage or Azure Data Lake Storage based on configured time or size intervals. Teams use it to archive raw event streams to storage for analytics, compliance, replay, or lakehouse ingestion without writing a separate capture consumer. It is not a consumer group, a checkpoint, a data transformation job, or a guarantee that downstream analytics has already processed the archived files. In production, confirm the namespace, event hub, partitions, capacity, identity, network path, consumer group, checkpoint behavior, monitoring, and owner before treating the stream as safe.
Event Hubs
intermediate
5 commands
Aliases: Azure Event Hubs Capture, Capture Streaming Events, Event Hubs archive capture
Quick peek
Open full term page
Storage
premium
POSIX ACL
Azure Data Lake Storage supports POSIX-like access control lists on files and directories. Each ACL entry associates a user, group, service principal, or managed identity with permissions, so fine-grained authorization can complement broader Azure RBAC roles on the storage account.
Data Lake Storage Gen2
fundamentals
5 commands
Aliases: ADLS ACL, Azure Data Lake ACL, Data Lake POSIX ACL, path ACL
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
Storage
premium
ABFS driver
The ABFS driver is the connector that lets Spark, Hadoop, Databricks, Synapse, and similar tools read and write ADLS Gen2 data using abfs:// or secure abfss:// paths instead of treating the storage account like ordinary blob storage.
Data Lake Storage Gen2
fundamentals
4 commands
Aliases: No aliases yet
Quick peek
Open full term page
Storage
premium
Access ACL
An access ACL is path-level permission in ADLS Gen2. It decides who can read, write, or traverse a file or directory. It works alongside Azure RBAC, so storage access often depends on both role assignments and ACL entries.
Data Lake Storage Gen2
fundamentals
4 commands
Aliases: No aliases yet
Quick peek
Open full term page
Storage
premium
Access control list inheritance
ACL inheritance in ADLS Gen2 means new files and folders can receive default permissions from a parent directory. It is not a magic fix for existing data; changing a default ACL affects future children unless you also update existing paths.
Azure Storage
intermediate
4 commands
Aliases: ACL inheritance
Quick peek
Open full term page
Storage
premium
Default ACL
A default ACL in Azure Data Lake Storage Gen2 is an ACL entry on a directory that new child files and directories inherit when they are created under that directory.
Data Lake Storage Gen2
intermediate
4 commands
Aliases: default access control list, ADLS Gen2 default ACL, directory default ACL
Quick peek
Open full term page
Storage
premium
Hierarchical namespace
Hierarchical namespace is a storage account capability that organizes blobs as directories and files so Data Lake Storage Gen2 can support file-system style operations.
Azure Data Lake Storage Gen2
intermediate
4 commands
Aliases: ADLS Gen2 hierarchical namespace, HNS enabled storage account, Hierarchical namespace, hierarchical-namespace
Quick peek
Open full term page
Storage
verified
Recursive ACL update
An Azure Data Lake Storage Gen2 operation that changes ACL entries across a directory tree instead of one path at a time.
Azure Storage
intermediate
6 commands
Aliases: No aliases yet
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
Storage
verified
Path ACL
In Azure Data Lake Storage Gen2, a path ACL is a POSIX-like access control list applied to a directory or file path. It works with Azure RBAC and ownership metadata to determine which users, groups, service principals, or managed identities can traverse, read, write, or execute data.
Data Lake Storage Gen2
intermediate
5 commands
Aliases: Data Lake path ACL, ADLS Gen2 ACL, access ACL, directory ACL, file ACL, POSIX ACL
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
complete
Spark pool
Microsoft Learn defines a Synapse Spark pool as a serverless Apache Spark pool definition that creates Spark instances when sessions or jobs run. Its settings control node size, scaling behavior, runtime, and time to live while data remains stored outside the pool.
Analytics platform
fundamentals
5 commands
Aliases: Synapse Spark pool, Apache Spark pool, serverless Spark pool, Synapse Apache Spark compute
Quick peek
Open full term page
Storage
field-manual-ready
Multi-protocol access
Multi-protocol access lets the same storage data be reached through more than one supported protocol or API surface.
Azure Data Lake Storage
intermediate
4 commands
Aliases: ADLS multi-protocol access, multi-protocol access, Data Lake Storage multi-protocol, Blob API hierarchical namespace
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
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
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
SFTP for Azure Blob Storage
SFTP for Azure Blob Storage lets clients connect to a storage account through SSH File Transfer Protocol for file access, transfer, and management. It requires a supported storage account with hierarchical namespace enabled, then local users and scoped permissions control access to containers and paths.
Storage platform
intermediate
5 commands
Aliases: Azure Blob Storage SFTP, SFTP support for Azure Blob Storage, storage account SFTP, Blob SFTP endpoint, SFTP for Azure Blob Storage
Quick peek
Open full term page
Storage
premium
Azure Storage Explorer
Azure Storage Explorer is a standalone app for Windows, macOS, and Linux that helps users connect to and manage Azure Storage data and resources through a graphical interface.
Storage tooling
fundamentals
4 commands
Aliases: No aliases yet
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
Databases
premium
Azure Database for MySQL Flexible Server
A fully managed Azure database service for MySQL workloads with configurable compute, storage, backups, networking, maintenance, and high availability options.
Managed MySQL
intermediate
5 commands
Aliases: MySQL Flexible Server
Quick peek
Open full term page
Databases
premium
Azure Database for PostgreSQL Flexible Server
A fully managed Azure PostgreSQL service with configurable compute, storage, backups, networking, maintenance, extensions, and high availability options.
Managed PostgreSQL
intermediate
5 commands
Aliases: PostgreSQL Flexible Server
Quick peek
Open full term page
Databases
premium
Azure SQL Database
Azure SQL Database is a fully managed relational database service in Azure that provides SQL Server-compatible engines as single databases, elastic pools, and serverless or provisioned compute choices. Microsoft Learn presents it as platform as a service with built-in availability, backups, patching, scaling, and security integration.
Database
intermediate
5 commands
Aliases: Azure SQL DB, Azure SQL Database, Azure SQL pooled database, Azure SQL single database, SQL Database
Quick peek
Open full term page
Databases
premium
Azure SQL Database DTU model
Azure SQL Database DTU model is a purchasing model that bundles compute, storage, and I/O resources into Database Transaction Units for Basic, Standard, and Premium tiers.
Azure SQL Database
fundamentals
5 commands
Aliases: Azure SQL Database DTU model, DTU model, DTU-based purchasing model, Database Transaction Unit, eDTU
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 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
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