Search Azure terms

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 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 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 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 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 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 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 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 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 top-250-pre130-priority-upgraded Dedicated SQL pool Dedicated SQL pool is a provisioned massively parallel processing data warehouse resource in Azure Synapse Analytics used for relational analytical queries at a selected DWU level in Azure. Analytics platform fundamentals 7 commands Aliases: Dedicated SQL pool Quick peek Open full term page

Analytics 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 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 Unity Catalog Unity Catalog is Azure Databricks’ unified governance layer for data and AI assets. It centralizes access control, auditing, lineage, discovery, and classification across workspaces so teams can govern tables, views, volumes, functions, and models through a shared metastore and three-level namespace. Azure Databricks intermediate 5 commands Aliases: Databricks Unity Catalog, Azure Databricks Unity Catalog, unified governance layer, Unity Catalog metastore Quick peek Open full term page

Analytics field-manual-complete Unity Catalog catalog A Unity Catalog catalog is the top level of the Unity Catalog three-level namespace. It groups schemas and their tables, views, volumes, functions, and models under a governance boundary, with permissions, workspace bindings, and ownership patterns that help separate domains, environments, or data products. Azure Databricks intermediate 5 commands Aliases: catalog in Unity Catalog, Databricks catalog, UC catalog, catalog.schema.table namespace Quick peek Open full term page

Analytics field-manual-complete Unity Catalog schema A Unity Catalog schema is the namespace inside a catalog that contains tables, views, volumes, functions, and models. It gives teams a more granular organization and permission boundary than the catalog level while keeping assets in the catalog.schema.object hierarchy used by Azure Databricks. Azure Databricks intermediate 5 commands Aliases: schema in Unity Catalog, Databricks schema, UC schema, catalog schema namespace 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

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

AI and Machine Learning field-manual-ready MLflow experiment An MLflow experiment groups related MLflow runs so teams can compare metrics, parameters, artifacts, and candidate models. Azure Machine Learning and MLflow intermediate 4 commands Aliases: ML experiment, MLflow experiment tracking, experiment container Quick peek Open full term page

Analytics verified Data warehouse A data warehouse stores curated, structured data for analytics and reporting. Analytics platform fundamentals 2 commands Aliases: No aliases yet 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

Monitoring and Observability premium Log Analytics table A Log Analytics table is the named storage structure inside a Log Analytics workspace that holds one kind of Azure Monitor log record, with its own schema, plan, retention behavior, access considerations, and KQL query patterns for troubleshooting, analytics, and compliance. Azure Monitor Logs fundamentals 4 commands Aliases: No aliases yet Quick peek Open full term page

Monitoring and Observability premium Log Analytics workspace A Log Analytics workspace is the Azure Monitor Logs data store where collected log records are retained, secured, queried with KQL, and used by alerts, workbooks, Microsoft Sentinel, Application Insights, and operations teams to troubleshoot and govern Azure workloads in governed production environments. Azure Monitor Logs fundamentals 4 commands Aliases: workspace, LAW Quick peek Open full term page

Analytics field-manual-complete Stream Analytics no-code editor The Stream Analytics no-code editor is a visual way to build a streaming job without typing the query yourself. You connect supported inputs, shape the data with drag-and-drop transformations, preview records, and choose outputs. Azure then creates a Stream Analytics job behind the experience. It is useful for analysts, platform teams, and engineers who need a quick, governed pipeline but do not want every small stream-processing task to become custom code. It still needs engineering review before production. Stream Analytics intermediate 5 commands Aliases: Stream Analytics no-code editor, ASA no-code editor, no-code Stream Analytics, drag-and-drop Stream Analytics editor, Stream Analytics visual editor 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

Management and Governance premium Platform baseline A platform baseline is the minimum set of governance, security, identity, networking, monitoring, and cost controls an Azure environment should inherit before workloads deploy. It sets standard expectations for subscriptions, landing zones, policy assignments, RBAC, logging, tags, and operational ownership across the estate. Governance operations fundamentals 5 commands Aliases: Azure platform baseline, governance baseline, enterprise platform baseline Quick peek Open full term page

Management and Governance premium Platform landing zone A platform landing zone is the shared Azure foundation that hosts common services for workload landing zones. It commonly includes connectivity, identity integration, management groups, policy, security monitoring, private DNS, logging, and automation so application teams can build on consistent enterprise guardrails. Governance operations fundamentals 5 commands Aliases: Azure platform landing zone, shared platform landing zone, enterprise-scale platform landing zone Quick peek Open full term page

Monitoring and Observability premium Platform metrics Platform metrics are numeric measurements that Azure resources emit and Azure Monitor collects at regular intervals. They describe resource health, capacity, utilization, latency, throughput, failures, and dimensions over time, helping operators chart behavior, create alerts, and diagnose service conditions quickly. Monitoring fundamentals 5 commands Aliases: Azure platform metrics, Azure Monitor platform metrics, resource metrics Quick peek Open full term page

Databases premium PostgreSQL log analytics PostgreSQL log analytics means collecting PostgreSQL flexible server logs in Azure Monitor so operators can search them, build alerts, and investigate problems with KQL. Instead of downloading log files manually or guessing from symptoms, teams route PostgreSQLLogs and related categories to a Log Analytics workspace. The value comes from patterns: failed connections, slow queries, audit events, PgBouncer signals, configuration effects, and workload changes. It is not free and not automatically useful; teams must choose categories, retention, workspace access, alert logic, and dashboards that match the database risk. PostgreSQL flexible server fundamentals 5 commands Aliases: PostgreSQL log analytics, postgresql log analytics, Azure Database for PostgreSQL flexible server Quick peek Open full term page

Identity premium Log Analytics Data Reader A Log Analytics Data Reader assignment is an Azure built-in RBAC role for letting approved users, groups, or workload identities query the Log Analytics logs they are allowed to view across workspaces and tables without granting workspace administration, table management, or broader monitoring control. Azure RBAC fundamentals 4 commands Aliases: No aliases yet Quick peek Open full term page

Storage field-manual-complete Storage analytics logs Storage Analytics logs are classic Azure Storage logs that record details about successful and failed requests for Blob, Queue, and Table services. They help troubleshoot request-level behavior, but Azure Monitor storage logs are generally preferred for modern monitoring, querying, alerting, and centralized retention. Storage monitoring fundamentals 5 commands Aliases: classic storage logs, Azure Storage Analytics logging, storage request logs Quick peek Open full term page

Analytics field-manual-complete Stream Analytics Azure Stream Analytics is a managed real-time analytics service for processing fast-moving event streams. It connects to inputs such as Event Hubs, IoT Hub, Blob Storage, or Data Lake Storage, runs SQL-like queries over the stream, and writes transformed results to supported outputs. Stream processing fundamentals 5 commands Aliases: Azure Stream Analytics, ASA, stream processing job, real-time analytics job, Stream Analytics Quick peek Open full term page

Analytics field-manual-complete Stream Analytics cluster A Stream Analytics cluster is a dedicated single-tenant environment for running Azure Stream Analytics jobs. It is intended for demanding streaming workloads, gives teams control over which jobs use the cluster, and supports private connectivity scenarios that are not covered by ordinary multi-tenant job placement. Stream Analytics intermediate 5 commands Aliases: Stream Analytics cluster, ASA cluster, dedicated Stream Analytics cluster, single-tenant Stream Analytics capacity Quick peek Open full term page

Analytics field-manual-complete Stream Analytics compatibility level Stream Analytics compatibility level is a job setting that controls selected runtime behaviors for query processing. It lets teams keep older jobs stable or opt into newer processing behavior, so changes in query semantics, partitioning, and supported features can be managed deliberately. Streaming analytics fundamentals 5 commands Aliases: Stream Analytics compatibility level, ASA compatibility level, job compatibility level, Stream Analytics runtime compatibility Quick peek Open full term page

Analytics field-manual-complete Stream Analytics function A Stream Analytics function is custom logic that can be invoked from a Stream Analytics query. Functions extend the SQL-like language for operations such as specialized calculations, string handling, enrichment, aggregation, or machine-learning scoring when built-in query expressions are not enough. Stream Analytics intermediate 5 commands Aliases: Stream Analytics function, ASA function, Stream Analytics user-defined function, JavaScript UDF for Stream Analytics Quick peek Open full term page

Analytics field-manual-complete Stream Analytics input A Stream Analytics input is a named connection between a Stream Analytics job and a data source. Inputs can represent live event streams or reference data, are used by name in the query, and define source type, serialization, authentication, and related connection settings. Streaming analytics fundamentals 5 commands Aliases: Stream Analytics input, ASA input, stream input, reference input for Stream Analytics Quick peek Open full term page

Analytics field-manual-complete Stream Analytics job A Stream Analytics job is the thing that actually runs your real-time processing. You give it input sources, a SQL-like query, optional functions, output destinations, and capacity settings. When the job starts, it continuously reads events, applies the query logic, and pushes results somewhere useful. For a learner, think of the job as the streaming application container. For an operator, it is the Azure resource you start, stop, scale, monitor, troubleshoot, secure, and include in deployment automation. Streaming analytics fundamentals 5 commands Aliases: Stream Analytics job, Azure Stream Analytics job, ASA job, streaming job, real-time analytics job Quick peek Open full term page

Analytics field-manual-complete Stream Analytics query A Stream Analytics query is the logic that turns incoming events into useful results. It looks like SQL, but it is built for streams, time windows, late events, joins, reference data, and continuous output. The query decides what fields to keep, what events to filter, how to group data, and where each result goes. For operators, a query is not just code; it is production behavior that can change alerts, dashboards, and records within seconds. Streaming analytics fundamentals 5 commands Aliases: Stream Analytics query, ASA query, Stream Analytics SQL query, streaming query, ASAQL query Quick peek Open full term page

Analytics field-manual-complete Stream Analytics reference data Stream Analytics reference data is the lookup table your stream uses while events are flowing. Instead of sending every business attribute inside each event, you keep stable or slowly changing information separately, such as device metadata, route codes, tariff bands, or product categories. The query joins live events to that reference set and produces richer output. The key idea is simple: events tell you what happened now, while reference data explains what that event means in the business context your operators care about. Streaming analytics intermediate 5 commands Aliases: Azure Stream Analytics reference data, reference data input, ASA reference data, lookup data for Stream Analytics Quick peek Open full term page

Analytics field-manual-complete Stream Analytics watermark A Stream Analytics watermark is the job’s best answer to the question, “How far through event time are we?” Streaming data does not always arrive in perfect order. Devices can be offline, brokers can buffer messages, and clocks can drift. The watermark lets the service decide when it is safe to close a time window and produce output. A larger tolerance accepts more late data but delays results. A smaller tolerance produces faster answers but may drop or adjust late events. Streaming analytics fundamentals 5 commands Aliases: Azure Stream Analytics watermark, ASA watermark, event-time watermark, watermark delay Quick peek Open full term page

Analytics field-manual-complete Stream Analytics windowing function A Stream Analytics windowing function lets you ask questions about events over time instead of one event at a time. You might count transactions every minute, average machine temperature over five minutes, detect user activity sessions, or compare current values with a snapshot. The window defines which events belong together before the query aggregates them. Choosing the wrong window can make alerts noisy, late, or misleading, so it is one of the most important design choices in a streaming query. Streaming analytics fundamentals 5 commands Aliases: Azure Stream Analytics windowing function, ASA window function, temporal window, streaming window function Quick peek Open full term page

Analytics field-manual-complete Stream Analytics job diagram A Stream Analytics job diagram is a visual map of what the job is doing. Instead of reading only a query file and metric table, you can see inputs, query steps, outputs, and sometimes physical streaming nodes on one canvas. It is especially helpful when a job runs but produces no results, late results, or results that look wrong. The diagram gives developers and operators a faster way to narrow the problem before rewriting the query or scaling blindly. Stream Analytics intermediate 4 commands Aliases: Stream Analytics job diagram, ASA job diagram, Stream Analytics logical diagram, Stream Analytics physical diagram, job diagram preview Quick peek Open full term page

Analytics field-manual-complete Stream Analytics output A Stream Analytics output is where processed events go after the query runs. It might be a storage account, SQL table, Event Hubs stream, Cosmos DB container, Azure Data Explorer table, Power BI dataset, Azure Function, or another supported sink. The output name is used in the query, so a small naming or schema mistake can send results nowhere useful. For operators, outputs are the handoff point between real-time processing and the systems people actually read, alert from, or store. Streaming analytics fundamentals 4 commands Aliases: Stream Analytics output, ASA output, Stream Analytics sink, output sink, query output destination 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

Databases learning-path-anchor Table A table is the basic place where structured data lives in a database. Each row is one record, and each column describes one attribute, such as customer ID, order date, amount, or status. In Azure, tables show up in Azure SQL Database, SQL Managed Instance, Synapse dedicated SQL pools, Fabric warehouses, PostgreSQL, MySQL, and... Database intermediate 4 commands Aliases: database table, SQL table, relational table, data table Quick peek Open full term page

Monitoring and Observability learning-path-anchor Throughput Throughput is the amount of work a system completes over time, such as requests, messages, bytes, events, or transactions per second. In Azure, teams measure it with service metrics, logs, and capacity settings to judge whether an app, database, storage account, or messaging pipeline can sustain demand. Performance intermediate 4 commands Aliases: Throughput, throughput, Azure Throughput, Microsoft Learn Throughput, requests per second, events per second, transactions per second, bytes per second, work completed over time 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 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