Free Preparation Discussions
MENU
Snowflake DSA-C02 Exam - Topic 2 Question 29 Discussion
Topic #: 2
Which ones are the correct rules while using a data science model created via External function in Snowflake?
From the perspective of a user running a SQL statement, an external function behaves like any other UDF . External functions follow these rules:
External functions return a value.
External functions can accept parameters.
An external function can appear in any clause of a SQL statement in which other types of UDF can appear. For example:
1. select my_external_function_2(column_1, column_2)
2. from table_1;
1. select col1
2. from table_1
3. where my_external_function_3(col2) < 0;
1. create view view1 (col1) as
2. select my_external_function_5(col1)
3. from table9;
An external function can be part of a more complex expression:
1. select upper(zipcode_to_city_external_function(zipcode))
2. from address_table;
The returned value can be a compound value, such as a VARIANT that contains JSON.
External functions can be overloaded; two different functions can have the same name but different signatures (different numbers or data types of input parameters).
Casie
9 months agoFlorencia
9 months agoKristofer
9 months agoKimbery
10 months agoMing
10 months agoChristoper
10 months agoSueann
10 months agoMoon
10 months agoArlette
11 months agoKanisha
11 months agoHeike
11 months agoSvetlana
11 months agoMadelyn
11 months agoSommer
2 years agoColeen
2 years agoSherell
2 years agoCherelle
2 years agoYuki
2 years agoCharlette
2 years agoRupert
2 years agoPauline
2 years agoGussie
2 years agoJesusa
2 years agoDomingo
2 years agoJovita
2 years agoJovita
2 years agoJovita
2 years agoJovita
2 years agoEdna
2 years agoJustine
2 years agoJustine
2 years agoErick
2 years agoSamira
2 years ago