What are the lesser known but practical Functions in BigQuery SQL? — BigQuery is the flagship analytics service in its Google Cloud. It is a SaaS Data Warehouse, or can also be referred to as a Data Lakehouse, that offers data analysis via SQL, data integration services, BI integration and even machine learning via SQL. In addition to the very well-known functions…