December 2017
Beginner to intermediate
264 pages
5h 38m
English
Content preview from Learning Google BigQuery
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Some considerations when using UDFs
We will now discuss working with UDFs:
- For standard SQL queries in BigQuery, UDFs can only be applied during the current query or command-line session. They cannot be saved for future queries.
- For standard SQL queries in BigQuery, UDFs are created in the query editor.
- UDFs must be defined prior to the query SELECT statement and must be terminated with a semicolon.
- Just like a standard functions, UDFs take in an input and return an output.