Upsert

In the Ultra Transcenders books

DP-600DP-700

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

Terms in this definition

• Index field attributes

  Settings applied to each field in an Azure AI Search index: searchable for full text, retrievable to return it, filterable for exact-match $filter, sortable, facetable for counts, and key for the unique document ID.

• MATCH

  Used in WHERE when querying SQL Graph, it describes how to walk from node to node through edge tables, with patterns written like p1-(f1)->p2.

• ALL

  A DAX function that ignores any filters and gives back every row of a table or every value of the named columns. Used within CALCULATE, it works as a modifier that clears filters, although REMOVEFILTERS states that intent more clearly where it is available.

• Copy activity

  Activity in a Data Factory pipeline that moves data from one store to another.

• Lakehouse

  Fabric storage item in OneLake that holds structured and unstructured content side by side: managed Delta tables go under Tables, other files under Files. Spark is used for processing, and a read-only SQL analytics endpoint allows T-SQL queries.

• Copy job

  Moves data between a source and a destination in Fabric Data Factory with no pipeline required. Runs can copy everything or just changes (incremental mode, driven by CDC or a watermark column), and the item keeps track of where the previous run stopped.

• MERGE

  A SQL command that compares a source with a target table and, depending on whether rows match, inserts, updates or deletes them. Fabric Warehouse supports it as generally available, and Spark SQL offers MERGE INTO for Delta tables.

Related terms

• HOLDLOCK

  A table hint that behaves like SERIALIZABLE, keeping key-range locks until the transaction finishes. Adding it to a MERGE upsert prevents two sessions from inserting the same key at once.