Constantin Lungudatawise.dev·14 hours agoUsing LOGICAL_AND and LOGICAL_OR in BigQueryToday I wanted to share another BigQuery feature - maybe not the breathtaking - but definitely something to have in your toolbox. The occasion to use it might be around the corner. So, have you ever encountered LOGICAL_AND() and LOGICAL_OR()? Think...DiscussPractical BigQuerybigquery
Narayana M V Lblog.macrofiy.com·Dec 6, 2023Unleashing Insights from Data: A Comprehensive Guide to Google BigQueryIn the era of data-driven decision-making, harnessing the power of data has become an essential endeavor for organizations of all sizes. Google BigQuery emerges as a formidable tool in this landscape, offering a serverless data warehouse that empower...Discussbigquery
Constantin Lungudatawise.dev·Dec 5, 2023LIKE ALL and LIKE ANY in BigQueryLet's look at the quantified LIKE operator in BigQuery. Why quantified? , you'll ask. So while the normal LIKE operator can be used to check just for one pattern, the quantified one (still in preview btw) can check the presence of one or all patter...DiscussPractical BigQuerybigquery
Constantin Lungudatawise.dev·Dec 5, 2023SELECT AS STRUCT and SELECT AS VALUEEver heard about value tables in BigQuery? Well, neither have I, until I've seen them mentioned in the docs. So, while in a normal table, a row is made up of columns, in a value table the row is a STRUCT. Say you UNNEST order_lines AS order_line. T...DiscussPractical BigQuerybigquery
Constantin Lungudatawise.dev·Dec 3, 2023Does order of expressions in the WHERE clause matter?Does the order of expressions in a WHERE clause matter for performance? So an interesting point found in a Google Cloud blog post was the fact that this expression order matters, with BigQuery assuming that the user has provided the best order of exp...DiscussPractical BigQuerybigquery
Constantin Lungudatawise.dev·Dec 3, 2023Filling up missing values with LAST_VALUEWindow functions are powerful. But they can also help us fill in missing data in BigQuery. Let's say you have a sensor that records temperature and humidity. Unfortunately, it is quite unreliable, so sometimes it might not send one or both readings. ...DiscussPractical BigQuerybigquery
Constantin Lungudatawise.dev·Nov 30, 2023Using SELECT * with EXCEPT and REPLACESELECT * is not a good practice in production, but I still use it for spot checks, when debugging, analyzing or validating data - especially when working with wide tables. Here are two useful clauses to keep in mind when working with SELECT * in Bi...DiscussPractical BigQuerybigquery
Constantin Lungudatawise.dev·Nov 25, 2023Using STRUCTS for Audit Fields in BigQueryI use STRUCTS in #BigQuery quite a bit. One interesting use case for them is for audit purposes a separate column containing metadata about how the data in that row was sourced. Sure enough, you don't need a STRUCT for that, but you don't want to cro...DiscussPractical BigQuerybigquery
DbVisualizerforThe Tablethetable.hashnode.dev·Nov 23, 2023Google BigQuery: A Beginner’s GuideAs businesses grow, managing and analyzing data becomes challenging. Traditional data warehouses have become expensive to scale and can no longer handle large data sets. Tools used in this tutorial DbVisualizer - top rated database management tool a...Discussbigquery
TechCFOfuturecfo.dk·Nov 20, 2023Implementing Time-Dimensional Price Lookups in BigQuery with Price Difference AnalysisIntroduction In the dynamic world of data analytics, tracking and querying historical product prices with precision is crucial. This blog post delves into setting up a time-dimensional price lookup system in Google BigQuery, enhanced with the capabil...DiscussSQL
