Which object can a User-Defined Function (UDF) reference?
Snowflake SQL UDFs can reference views and materialized views by name. Snowflake’s supported-object-dependencies table includes SQL UDF as a referencing object and includes both View and Materialized View as supported referenced objects; streams and external tables are not included in that referenced-object list.
SQL UDF
View
Materialized View
Community Discussion