From the course: Data Warehousing on Google Cloud Platform
Join today to access over 25,500 courses taught by industry experts.
BigQuery SQL functions - Google Cloud Platform Tutorial
From the course: Data Warehousing on Google Cloud Platform
BigQuery SQL functions
- [Instructor] The BigQuery documentation will always be your go-to for functions available. But, I'd like to highlight a few that I think you'll find helpful in your data warehouse design. The aggregate functions are important for summarizing or de-identifying data. BigQuery includes most common aggregate functions like Count min/max, distinct, top count, and quantiles. Array functions allow you to manipulate array data types. An example is the array function that produces an array with one element for each row in the result. Additional array functions include ARRAY_CONCAT, and ARRAY_Length. Conversion functions allow you to cast data types as different data types when you need to compare columns of different types. The original data type remains the same and is only converted for use within the query. Example, conversion functions include CAST, PARSE_NUMERIC, and SAFE_CAST. BigQuery also has a unique data type called geography in which we can use geography functions. These functions…
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.