States what a function gives back, as a type or a table, inside CREATE FUNCTION. SQL functions can leave it out and have the type worked out from their body.
Read more: Databricks docs
In the Ultra Transcenders books
Each book explains RETURNS in context, with comparison tables and the common traps.
Terms in this definition
- FUNCTION
Registered models count as functions in Unity Catalog, so this securable type governs them too: access is given through
GRANT ... ON FUNCTION, and REST calls passFUNCTIONassecurable_type. - Event
Table in Log Analytics where entries from Windows event logs are kept.
- CREATE FUNCTION
Adds a table function, or a Python or SQL UDF, to Unity Catalog so that it falls under governance like other objects. Doing so takes the relevant privilege on the schema.
- 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
- ACK
Short for the acknowledgement flag in TCP. A target that returns it on the chosen port passes a load balancer's TCP health check.
- ai_classify
Sorts content under labels you define, whether plain text or the VARIANT that
ai_parse_documentreturns. This task-specific AI Function can also take instructions and a description of each label. - ai_prep_search
Readies content for a search index: this AI Function, still in Beta, takes plain text, Markdown or the result of
ai_parse_documentand returns meaning-based chunks carrying context from the document. - AnalysisResult
Object that
poller.result()returns in Content Understanding; its JSON body carries the extracted fields and markdown content. - APD
A state where a storage device returns no permanent device loss code to an ESXi host, so the host carries on issuing I/O. After a storage-only outage, VMCP APD is what lets Metro Availability on ESXi move VMs elsewhere.
- Area of interest
Smart-crop capability of Image Analysis that, for a requested aspect ratio, returns a bounding box around the most important part of the image, useful for thumbnails and cropping.
- Autopilot Reset
Returns a Microsoft Entra joined device to a ready-for-work state by clearing personal files, apps and settings, while it stays Entra joined and enrolled in Intune. It can be triggered remotely or on the device with Ctrl+Win+R, but hybrid joined devices aren't supported.
- AVERAGEX
Returns the mean of an expression after computing it once for each row in a table; if the table has no rows, this DAX iterator gives BLANK.