Easy Query for Historic Data with Google Cloud BigQuery and RBL Net

Introduction

Welcome to our tutorial on RBL Net, BigQuery, and Google Cloud. In this tutorial, we'll take you through the steps to utilize your RBL Net data and explore historic data points, create queries and visualize the results.

Getting started

Let’s start by ensuring our Google Cloud Project is set up with our RBL Net data. If you don’t have one setup, please refer to HOW TO ADD RBL NET DATA TO A ANALYTICS HUB TUTORIAL.

Now let's go to the left side menu, click on BigQuery, and click on Compose a New Query.

Steps to follow

From there type the following Query

SELECT *

FROM `analytics-hub-public-access.my_first_listing.avalanche_blocks`

LIMIT 1000;

This query will retrieve the structure of your table without fetching any actual data.

From there let’s use the following query to filter data for a specific date range:

SELECT *

FROM `analytics-hub-public-access.my_first_listing.avalanche_blocks`

WHERE date_column >= 'start_date' AND date_column <= 'end_date';

Now to visualize your data in a spreadsheet click on “Explore Data” and then on “Explore with Sheet” 

Last but not least, you can also explore with Looker Studio by going to the bottom side again and clicking on “Explore Data” and then on “Explore with Looking Studio”

Thanks for reading through this tutorial and I hope it was helpful. If you have any questions please feel free to reach out to us.