LENGTH

In the Ultra Transcenders books

DBX-GENAI

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

Terms in this definition

• STRING

  The SQL type that holds text.

• BINARY

  A SQL type that holds raw bytes. ai_parse_document needs its content argument in this type, so passing a file path as a string does not work.

• 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.

Related terms

• Automatic statistics

  When queries run against the Fabric Data Warehouse or the SQL analytics endpoint, the engine creates statistics (histograms, cardinality and average column length) on columns used for filtering, joining, grouping, sorting or DISTINCT. The histogram objects are named with a _WA_Sys_ prefix.

• Balanced hierarchy

  A hierarchy in which each path has an identical, fixed depth, as with year, quarter, month, date. Ragged hierarchies and parent-child (unbalanced) ones, by contrast, have branches of differing length.

• Chat playground

  Lets you try a deployed chat model in Foundry without writing code, adjusting the system message, temperature, past messages included and maximum response length.

• CIDR

  Notation for IP ranges that writes an address followed by a prefix length, as in 10.1.255.0/24; short for Classless Inter-Domain Routing.

• Data type

  A rule limiting what a column may contain, for example INT for integers, DECIMAL for numbers with fractions or VARCHAR for text of varying length. Which types exist depends on the database product.

• EDIT_DISTANCE_SIMILARITY

  Turns edit distance into a score from 0 to 100, adjusted for the length of the strings, so higher means more similar. It is a fuzzy string function in preview.

• finish_reason

  Explains why a chat completion ended. Values are stop (completed normally), length (truncated by max_tokens or the token limit), content_filter (content omitted) and tool_calls (a tool was invoked).

• Kimi K3

  A model from Moonshot AI hosted by Databricks and aimed at long-horizon coding and knowledge work, with support for vision, a 1 million token context length and a configurable reasoning effort.