Content by Wiliam Rosa (2)

Wiliam Rosa explains how to use Azure Databricks ai_query to run a “decision model” (closed-set classification with probabilities) directly from SQL against Unity Catalog-governed tables, avoiding chat-style outputs and extra orchestration. The post covers required warehouse/runtime constraints, structured return types, hosting options, and governance caveats in Unity Gateway.

Wiliam Rosa explains Azure Databricks’ new (beta) configurable retention for supported system tables, including the 30–3,650 day range, the default behavior when enabled, and how to set the st_retention value via the Databricks Account Settings API for governance and long-term auditing needs.