MATCH

In the Ultra Transcenders books

DP-800

Each book explains MATCH in context, with comparison tables and the common traps.

Terms in this definition

• WHERE

  Limits a SELECT, UPDATE or DELETE to just the rows meeting a condition. Omit it, and the statement hits every row.

• Serverless

  Compute tier for single Azure SQL databases that scales automatically, pauses when idle and charges by the second. It is offered in General Purpose and Hyperscale, not Business Critical, and reserved capacity does not apply.

• LIKE

  Compares strings with a pattern that can contain the % and _ wildcards. Because it only understands character patterns, searching big volumes of text this way is much slower than using full-text search.

Related terms

• ABAC policy

  Governed tags drive this kind of Unity Catalog rule: when a table or column has tags that satisfy its WHEN and MATCH COLUMNS conditions, a row filter or column mask UDF is put on it automatically. Policies are written with CREATE POLICY and can sit on a metastore, catalog, schema or table.

• Allow gateway transit

  Peering option set on the hub, which owns the gateway, so that peered VNets can share its ExpressRoute or VPN gateway. The spoke sets Use remote gateways to match; on a VNet lacking a gateway the option has no effect.

• Application Gateway Ingress Controller

  Add-on for AKS that reads Kubernetes Ingress resources and sets up an Application Gateway, WAF v2 included, to match them.

• Assume referential integrity

  A relationship setting in DirectQuery and Direct Lake models that lets the engine send faster INNER JOIN queries to the source rather than OUTER JOINs. Only switch it on when every key on the many side has a match, otherwise unmatched fact rows quietly vanish from results.

• Automatic index management

  Lets the database add and remove indexes by itself to match the workload, through the CREATE_INDEX and DROP_INDEX automatic tuning options. You'll only find it in SQL database in Fabric and Azure SQL Database.

• Autoscaling

  A classic compute option where you give a minimum and maximum worker count and Azure Databricks adjusts the number of workers within that range to match the load.

• Azure AI Face

  Foundry Tool limited to human faces: it detects them, verifies whether two match (1:1) and identifies a person from a group (1:many). Verification and identification are Limited Access features.

• Azure Information Protection

  Service that classifies and protects documents in Office apps, applying a single label to each (if several match, the last one in the policy wins). Its classic client has been retired, with Microsoft Purview sensitivity labels taking over.