STRING

In the Ultra Transcenders books

DBX-DEPDBX-GENAI

Each book explains STRING 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.

Related terms

• Application ID URI

  Set on the Expose an API page, defaulting to api://<application-client-id>, this globally unique value names a web API. Prefixing it to a scope name gives the complete scope string.

• azure-ai-projects

  Python SDK for Microsoft Foundry; its AIProjectClient opens a connection to a project, and telemetry.get_application_insights_connection_string() fetches the connection string of the Application Insights resource linked to that project.

• Base64 data URI

  Embedding the image itself in image_url as a data:image/jpeg;base64,... string; this is the approach when no public URL hosts the image.

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

• COALESCE

  A SQL function that picks out the first non-NULL argument. CEL validation rejects a STRING cast inside the call, so a service policy function hands it the VARIANT field and casts what comes back.

• COLUMNS clause

  Controls column handling in AUTO CDC. COLUMNS TO UPDATE points to an array<string> field in the source listing what a given record changes, while COLUMNS sets what reaches the target: everything unless restricted, for instance with * EXCEPT (...).

• COMBINEVALUES

  Joins several text values into one string, placing a chosen separator between them. Its chief use is creating composite keys so that DirectQuery models can relate tables on more than one column.

• CONCATENATEX

  Builds one text string by computing an expression for every row of a table and stringing the results together. This DAX iterator can optionally take a separator and an order for sorting.