Tells the engine, in CREATE FUNCTION, that identical inputs always give identical outputs, which can help optimisation. The engine takes this on trust and does not verify it against the function's code.
Read more: Databricks docs
In the Ultra Transcenders books
Each book explains DETERMINISTIC in context, with comparison tables and the common traps.
Terms in this definition
- 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.
- 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.
Related terms
- CHECK constraint
Added via
ALTER TABLE ... ADD CONSTRAINT name CHECK (expr), this Delta rule requires a deterministic Boolean expression to be true for each row. Current rows are validated before it takes effect, and writes that would break it fail. - Computed column
A column calculated from an expression over other columns in the same row. It isn't stored unless marked
PERSISTED, and it can be indexed if the expression is precise and deterministic. - Temperature
A randomness control for inference, set between 0 and 2. Settings near 0.2 make responses focused and close to deterministic, whereas higher settings make them more creative.