External functions can appear in a view definition.

• A. True
• B. False
• C. Only in materialized views
• D. Only in dynamic views

Answer: (A)

External functions can appear in a view definition because a view is just a saved SQL query, and you can call any supported function within that query. An external function is a function that calls out to code or services outside Snowflake, defined with an API integration and a handler. When you query the view, Snowflake executes the stored query and, for each row, may invoke the external function to compute its value, returning that result as part of the view’s output. This works for standard views and isn’t limited to a special type of view. Just be mindful of potential latency and cost since each row can trigger a call to an external service, and ensure the external function is properly secured and configured.