Question

A data engineering team maintains a SQL UDF that encapsulates proprietary business logic to calculate a customer risk score. They plan to share this UDF with an external partner account through a data share. The team is concerned that the partner should be able to call the function and get results, but must NOT be able to view the underlying SQL expression that defines the calculation. Which approach satisfies this requirement?

Accepted Answer

Create the UDF as a SECURE UDF so its definition is hidden from users who did not create it, then grant usage through the share.

Answer

Create a standard UDF and rely on the partner not having the MONITOR privilege to inspect the definition.

Answer

Wrap the UDF logic in a JavaScript UDF, since JavaScript function bodies are always encrypted in Snowflake.

Answer

Store the UDF in a separate schema and revoke SELECT on the ACCOUNT_USAGE views from the partner account.