Caps how many rows a SQL query gives back. Don't treat what you get as random or representative.
Read more: Databricks docs
In the Ultra Transcenders books
Each book explains LIMIT in context, with comparison tables and the common traps.
Terms in this definition
- 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.
- Get
Key Vault permission on secrets that allows a single secret to be read; App Service Key Vault references need nothing beyond it.
Related terms
- Administrative units
Containers in Microsoft Entra ID that limit the reach of directory administrators to particular users, groups or devices. They are neither Azure Policy scopes nor cost groupings.
- Always ready instances
To avoid cold starts, a baseline of instances can be kept running and billed, either for chosen functions or function groups on Flex Consumption or for the whole app on Premium. Flex Consumption doesn't count them toward its maximum instance limit.
- Autopilot
A playbook setting that keeps rerunning a play until a KPI hits its goal or the attempt limit is reached. It is only available when a metric-based alert starts the playbook.
- Azure Functions Dedicated plan
Running Functions on an App Service plan. Executions have no time limit, and from the Basic tier upwards apps can integrate with a VNet.
- Azure Functions Premium plan
Functions hosting plan that keeps instances pre-warmed to avoid cold starts and supports VNet integration; executions default to 30 minutes, a limit you can raise in host.json.
- Azure Spot Virtual Machines
Heavily discounted VMs using Azure's spare capacity. Azure can reclaim them with 30 seconds' warning when it needs the capacity back or the price rises above your limit, and with no SLA they fit work that can tolerate interruption.
- Backfill runs
Lets a scheduled Lakeflow job be run for each point in a span of dates, with values supplied for references like
{{backfill.iso_datetime}}. The limit is 100 runs per backfill. - BGE
Databricks hosts this English embedding model as
databricks-bge-large-en; expect 1024-dimension output and a limit of 512 tokens on what it reads.