02. How to explore your data with the BigQuery Console?

Owned by Darius Rybacki (Deactivated)
Last updated: Dec 31, 2021 by Siamak Haschemi (Deactivated)
3 min read

Overview

In this article, we'll explain how you can explore your data using the Google BigQuery console. Therefore we explain step by step how to proceed. Afterwards you can read this article to continue.

Before we get started..

Before we get started, a few conditions must be met.

  • You must have a Google Account.

  • You must have a Google Project. This is usually the project of your company.

  • (If you want to use BigQuery beyond the free contingent, you have to create a billing account.)

  • Your Google Account must be activated by Ingenious Support for the use of customer data. If this is not yet the case, please contact support.

Let's go…

Step 1

Open the BigQuery Console with a supported web browser.

https://console.cloud.google.com/bigquery

A web interface opens which should look something like this.

Step 2

Make sure that the right Google project is selected. This is especially important if you have access to multiple Google projects.

Step 3

If you are already activated by Ingenious Support for the use of BigQuery data and do not see the project "ingenious-169318" on the left side below the menu item Resources, click on "ADD DATA". Then click on "Pin a project". Enter "ingenious-169318" and then click on "Pin". The project should now be visible below the Resources menu item.

Step 4

Below the menu item "ingenious-169318" you will find the dataset "insights_???". (The three question marks stand for your individual network number.) Here you can find all tables that are released for you. If you click on a table, you can see the schema and further details of the table on the right side.

Step 5

A short query to check the access could look like this. Please note the estimated query size on the right side. This provides a good estimation of the cost of the query.

Next Steps