Table of Contents

What is Google BigQuery

BigQuery Dashboard

CaliberMind BigQuery Dashboard

CaliberMind BigQuery Navigation menu - The BigQuery navigation menu allows you to select analysis, migration, and administration options.
CaliberMind BigQuery Explorer pane- The Explorer pane is visible when you select SQL workspace in the navigation menu.
CaliberMind BigQuery Details pane - The details pane shows information about your BigQuery resources.

Logging into BigQuery

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

Sign in using your Google mail-approved email.

If you don’t have access please email help@calibermind.com

Why use Google BigQuery?

  • BigQuery is a great tool for analysts and business intelligence professionals to be able to do detailed queries and procedures.
  • Data scientists will find it useful in machine learning with Python, R, or other languages and can utilize the BigQuery API to write applications and connect directly to your data.
  • If you utilize a BI Platform you can use your credentials to directly connect to your BigQuery database.

Work with Project in BigQuery

All of the work that you perform in BigQuery is done within a Cloud project. You can see the project name on the Google Cloud console toolbar:

BigQuery Project selector.

Any costs that you incur for using BigQuery are charged to the billing account that's attached to the project.

Switch to a project

To switch to a Cloud project in the Google Cloud console, follow these steps:

  1. On the Google Cloud console toolbar, click the name of your project.
  2. In the projects dialog, click the name of the project that you want to switch to.
    This selection becomes your active project.

Star a project

You can star a Cloud project to the Explorer pane in the following three ways:

  • You can open a project and then star it:
    1. Switch to the project that you want to star.
    2. In the Explorer pane, hold the pointer over the name of the project that you want to star, and then click the Star.
  • You can select a project from a list and then star the project:
    1. In the Explorer pane, click Add data.
    2. In the Add data dialog, click Search for and star a project:
      Search for and star a project in the Add data subtask
    3. In the dialog, click the name of the project that you want to star.
  • You can enter the name of your project to star it:
    1. In the Explorer pane, click Add data.
    2. In the Add data dialog, click Star a project by name.
    3. In the dialog, enter the name of the project that you want to star.

Remove a project

To remove a project from the Explorer pane, click the name of the project, and then click star Unstar.

Display resources

The Explorer pane lists datasets that you can browse in your current project or any projects that you starred.

  • To display the datasets in a project, click Expand node for that project.
  • To display the tables, views, and functions in a dataset, click the dataset.

To display information about a resource in a project or dataset, click the name of the resource in the Explorer pane and view the details pane. The set of available actions depends on the resource. For example, the following image shows the tab for a table:

Tab in the details pane shows options to share, copy, or delete a table.

Star resources

If you have important or current projects, datasets, or tables, you can star them in the Explorer pane. To star a resource, hold the pointer over the name of the resource that you want to star, and then click Star.

For more information on starring a project, see Star a project.

View starred resources

To view only the starred resources in the Explorer pane, click Show starred resources only in the Explorer pane.

To view all the resources in the Explorer pane, click Show all resources.

Unstar resources

To unstar a resource, click star Unstar next to the resource.

Run a query

  1. In the details pane, click add_box Compose new query.
  2. In the query editor, enter a SQL query.
  3. Click Run.

For more information about how to run queries, see Running interactive queries.

Work with tabs

You can control how you work with tabs in the details pane.

Split two tabs

Whenever you select a resource or click Compose new query in the details pane, a new tab opens. If more than one tab is open, you can split the tabs into two panes and view them side by side.

To split tabs into two panes, follow these steps:

  1. Next to the tab name, click Open menu.
  2. Select one of the following options:
    • To place the selected tab in the left pane, select Split tab to left.
    • To place the selected tab in the right pane, select Split tab to right.

To unsplit the tabs, select Open menu on one of the open tabs, and then select Move tab to left pane or Move tab to right pane.

To split tabs when querying tables, follow these steps:

  1. In the Explorer menu, click the table that you want to query.
  2. Click Query, and then click In new tab or In split tab:
    Options to query a table in a new or split tab.
  3. Click the field name that you want to query:
    Add the field name to the query in a split tab.

The following image shows the details pane with two open tabs. One tab has a SQL query, and the other tab shows details about a table.

Details pane with two open tabs.

Move a tab

To move a tab from one pane to the other pane, follow these steps:

  1. Next to the tab name, click Open menu.
  2. Select Move tab to right pane or Move tab to left pane (whichever option is available).

Close a tab

To close all tabs except for one, follow these steps:

  1. Next to the tab name, click Open menu.
  2. Select cancel Close other tabs.

View personal and project history

You can view job histories in the footer of the details pane:

Tabs for personal history and project history and saved queries.
  • To view details of your own jobs, click Personal history.
  • To view details of recent jobs in your project, click Project history.

To see the details of a job or to open the query in an editor, do the following:

  1. In the Actions column for a job or query, click Actions.
  2. Select Show job details or Open query in editor.

The job histories include all load, export, copy, and query jobs that you submitted in the past six months (up to 1,000 entries). The limit of 1,000 jobs is cumulative across all job types.

Keyboard shortcuts

The following keyboard shortcuts are supported in the Google Cloud console:

Key combination (Windows/Linux)

Key combination (macOS)

Action

Ctrl+Enter

Cmd+Enter

Run current query

Tab

Tab

Autocomplete current word

Ctrl

Cmd

Highlight table names

Ctrl+E

Cmd+E

Run query from selection

Ctrl+/

Cmd+/

Comment current or selected lines

Examples

You can find Google Cloud console examples throughout the how-to guides section of the BigQuery documentation.

To see examples of loading data and querying data using the Google Cloud console, see the Load and query data with the Google Cloud console.

Basic SQL Query using the cm_account table

A basic SQL query of the cm_account table in the editor. The editor will tell you how much processing power it will require. 

Basic SQL query of the CaliberMind cm_account table

Sample Query to get you started:

SELECT company_id
FROM `calibermind-prod-7276.cm.cm_company
`WHERE customer_status like 'Prospect' 
LIMIT 10

NOTE: All BigQuery References above are found on Google Cloud BigQuery Overview Guide

How did we do?

CaliberMind Entity Relations and System Tables

CaliberMind Common Data Sources

Contact