Scalar functions let you encapsulate a calculation into a stored procedure-like snippet of SQL. It’s common practice to return the results of a scalar function as a column in a SELECT query.

Snowflake is adding generative AI-powered SQL functions to help data analysts and their organizations analyze unstructured data with SQL. These new AISQL functions will be part of Snowflake’s ...