QuestionQ19
Implement Snowflake data science best practicesA Data Scientist at a telecommunications company needs to store churn scores calculated by a Snowflake external function that is configured to connect to a model endpoint.
The environment conditions are:
The External Function DDL:

The CUSTOMER_DAILY table:

The churn value is stored in a new table named CUSTOMER_CHURN:

Based on these environmental conditions, how can the Data Scientist persistently store the churn scores from the external function in Showflake?
- A insert into customer_churnselectcust_id,get_churn(*) as churn_scorefromcustomer_daily;
- B insert into customer_churnselectcust_id,call get_churn(object_construct(*)) as churn_scorefromcustomer_daily;
- C insert into customer_churnselectcust_id,call get_churn(*) as churn_scorefromcustomer_daily;
- D insert into customer_churnselectcust_id,get_churn(object_construct(*)) as churn_scorefromcustomer_daily;
Community Discussion