Snowflake - Build and Architect Data Pipelines Using AWS - Lab - Write Tabular UDF in SQL

The video tutorial introduces tabular User Defined Functions (UDFs) in SQL, explaining their purpose and usage. It demonstrates how to create a UDF that calculates the total quantity sold for a given supplier on a specific day by joining supplier and line item tables. The tutorial covers the process of writing the SQL query, creating the UDF function with parameters, and executing it within a SQL statement. The video concludes with a brief mention of JavaScript UDFs as the next topic.

What is the primary purpose of joining the supplier and line item tables in the given scenario?

• To find the total quantity sold for a specific supplier on a given day

• To list all suppliers with their respective keys

• To calculate the average price of items

• To update the supplier information

What parameters does the tabular UDF function accept?

• Product ID and quantity

• Order date and customer ID

• Ship date and supply key

• Supplier name and item price

What does the tabular UDF function return?

• A single value

• A list of product names

• A summary of all transactions

• A table with supplier key and quantity sold

Which keyword is necessary when calling a tabular UDF in a SQL select statement?

• JOIN

• TABLE

• GROUP BY

• ORDER BY

What assumption does Snowflake make if the language is not specified for a UDF?

• It assumes the UDF is written in C++

• It assumes the UDF is written in SQL

• It assumes the UDF is written in Python

• It assumes the UDF is written in JavaScript