From the course: Data Science on Google Cloud Platform: Designing Data Warehouses

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

SQL functions

SQL functions

- [Instructor] BigQuery supports an exhaustive list of functions and operators. Here is a reference for all the functions and operators available in BigQuery. It goes to Google cloud.com/bigquery/docs/reference/ standard-sql/functions-and-operators. As seen with this reference, we see there are conversion functions for casting and converting between data types. We have aggregate functions for computing summary statistics. There are statistical functions available. There are also a number of mathematical functions available. String functions provide the ability to analyze and modify strings. JSON functions are available to extract information from raw JSON data. Array functions act upon array data types. Date functions and date-time functions provide date-time related math and formatting capabilities. Let us use some of them in a query. Our goal is to extract the last name of patients whose first name starts with Ben. We write the following query. We use the STRPOS function to find the…

Contents