SHOW USER FUNCTIONS LIKE 'REVENUE_BY_REGION' IN SCHEMA SALES lists accessible UDFs matching that name and returns an is_secure field. The INFORMATION_SCHEMA.FUNCTIONS view for the current database contains a row for each UDF and its IS_SECURE value; therefore, querying it for the SALES schema and REVENUE_BY_REGION identifies both existence and security status. SNOWFLAKE.INFORMATION_SCHEMA refers to the SNOWFLAKE database rather than MYDATABASE; SHOW EXTERNAL FUNCTIONS is limited to external functions; and SHOW SECURE FUNCTIONS is not a supported command.
Community Discussion