Google Bigquery

At Brandfolder, we are using BigQuery as a data analytics platform for building curated datasets, reports and many more. We recently ran into two BigQuery resource issues for one of our data processes, I would like to talk about the resource issues and how we were able to solve them. …

At loveholidays, we deal with substantial amounts of data. To borrow a phrase from Google, we “favour data not opinion”. With that in mind, many of our applications are recording data that helps us reach data assisted decisions. A lot of that data is stored in BigQuery, from where we…

Perform a query on Google BigQuery using Jupyter with pandas — In the previous article, I wrote about how to configure the python environment to connect to BigQuery via a Python client. Now I’ll show you how to perform the queries. First of all, let’s see the official example query that you can find in Google Cloud documentation.

One of the central values of high-level analytics is to see the general situation with marketing in one report. We use DWH based on Google BigQuery, which helps to make good reports with its logic. …

From the Floor to the Ceiling Rounding arithmetically in BigQuery is a trivial task with simple syntax. But often you need to round up or down rather than by the standard “up for 5+, down for 4-” rule. If you’re accustomed to Google Sheets or Excel, ROUNDUP() and ROUNDDOWN() are…

By B Pravena and Sasha Machine Learning is an application of AI (Artificial Intelligence) that enables systems to learn and improve from experience without being explicitly programmed. Google BigQuery ML is a set of tools and extensions that enables users to create, train and execute Machine Learning models in Google…

Google BigQuery Best Practices — guide to write cost effective BigQuery SQL Before we go deep into best practices let me set the foundation, lets fist understand what are slots and how BQ process the queries Slots — A Slot is defined as a unit of computational capacity required to…

Google Ads data transfer is free (you pay only for using Cloud services), simple and stable way to load Google Ads data to BigQuery. Step 1 is to create a dataset in BigQuery. For example, raw_google_ads Step 2 is to set up the daily transfer. Here we just need to…