© 2023 Hashnode
#bigquery
Machine learning is a rapidly growing field that has seen a lot of interest from businesses and organizations. With the growing amount of data that businesses collect, it has become essential to use m…
As a web/software application developer, you might encounter a situation where a data analyst approaches you and says, "Hey, we need some extra data in Google Analytics (or Looker Studio). We noticed that we can display charts with data fro…
AdTech products’ success rates are predicated on the efficient collection and use of big data — but more importantly, on how it is stored, processed, and analyzed. Advertising platforms must deliver multi-dimensional insights on real-time a…
You need a CSV or Parquet file to load into Rill (https://docs.rilldata.com/using-rill/import-data). Here are steps and caveats you can follow to get a dataset in Bigquery into that format and process…
In this practical BigQuery exercise, we’re going to look at what are recursive CTEs and how can they be useful in our tool set. What is a CTE? First of all, what is a CTE? Well, it stands for Common T…
In this practical BigQuery exercise, we’re going to look at BigQuery Time Travel and see how it can help us when working with data. It’s not as powerful as Marty McFly’s DeLorean in Back to the Future…
Introduction As businesses increasingly adopt multi-cloud strategies, it's becoming more important for cloud providers to work together seamlessly. In this context, BigQuery Omni, a multi-cloud analyt…
Have you ever encountered a situation where you would need to round a timestamp to the nearest second, 5 seconds or minute? While rounding a number is trivial, it's a little bit less straightforward w…
In one of my previous posts, we discussed what temporal tables are and how to join multiple such tables into a single one. In this short practical exercise, we’re going to look at how we can generate …
BigQuery is taking the analytics industry by storm. One of the most important use cases is to extract and transform parts of a string. Below are some of the powerful constructs provided by BigQuery. B…