External functions must be scalar functions

External functions must be scalar functions
A . TRUE
B. FALSE

View Answer

Answer: A

Explanation:

Limitations of External Functions

External functions have the following limitations:

Snowflake calls remote services indirectly through a cloud HTTP proxy service (such as the Amazon AWS API gateway), so the remote service for an external function must be callable from a proxy service. Fortunately, almost any function that can act as an HTTPS endpoint can be accessed as an external function via a proxy service. The function author must program the proxy service to call the remote service (e.g. a function running on AWS Lambda).

Currently, external functions cannot be shared with data consumers via Secure Data Sharing. Because the remote service is opaque to Snowflake, the optimizer might not be able to perform some optimizations that it could perform for non-external functions.

Currently, external functions must be scalar functions. A scalar external function returns a single value for each input "row".

External functions cannot be used in the following situations:

The DEFAULT clause of a CREATE TABLE statement. In other words, the default value for a column cannot be an expression that calls an external function. COPY transformations.

The external functions feature supports only functions, not stored procedures.