News, Tips, and inspiration to optimize your Bigquery usage
How to implement BigQuery autoscaling reservation in 10 minutes?
A step-by-step guide to implement BigQuery autoscaling reservation in only 10 minutes and save a LOT of money.
This is why you should use BI Engine for your BigQuery
BI Engine in Google BigQuery enhances query speed by using in-memory calculations. Instead of paying per data scan, users reserve memory (1GB-250GB) for a set period. BI Engine intelligently loads frequently used data into memory, ensuring faster, up-to-date queries. Tools like Biq Blue help monitor performance, allowing users to optimize costs and efficiency. Ideal for heavy BigQuery users, BI Engine can boost performance and streamline data processes.
How to Monitor and Reduce Query Lag in BigQuery
In today’s fast-paced data-driven world, monitoring the performance of your queries is essential. One common issue that users of BigQuery encounter is query lag. Understanding how to monitor and mitigate this lag can significantly improve your workflow. In this article, we'll guide you through the steps to effectively manage query lag in BigQuery.
You should pay in dollars on Google BigQuery (and GCP)
Find out how paying in USD for Google BigQuery and GCP enables FinOps to benefit from consistent and predictable pricing.
A step-by-step tutorial to use Biq Blue As A Service
The step-by-step guide on how to setup Biq Blue as-a-service for your Google BigQuery account
How to use BigQuery in Google Sheets and control your costs?
Using Bigquery in Google Sheets is a very productive way of empowering non-tech users. Here is a step-by-step guide on how to use BigQuery in Google Sheets, and keeping cost under control.
How to delete unused storage on Bigquery?
BigQuery is easy to use, but can lead to data bloat & high storage costs. Biq Blue helps clean up the mess.
How prevent your data team from spending too much on Bigquery?
Bigquery is a dream for a data team. The more they use it, the more they use it, and that's when the expensive queries come in. Don't panic, Biq Blue is there.
How to easily monitor Bigquery table usage?
BigQuery can store petabytes of data very easily, but understanding how they are used by queries is much more complicated. Thankfully, there is Biq Blue.
Why labels are essential for managing BigQuery at scale
Labels can be used to track your queries and quickly identify their impact on your BigQuery usage.
How to clean up your BigQuery data warehouse?
Bigquery is a powerful and very simple data warehouse. So simple that the data lake can quickly become a data swamp. Biq Blue helps you keep things clean.
How to wisely choose the storage billing model on Bigquery?
Bigquery lets you choose between two pricing models for storage, and Biq Blue tells you which one to choose for each dataset.