Features

This article provides users with a general guide to the features listed.

These features may have been updated or superseded by additions found in the release notes.

Read the content below to become familiar with the feature and review the release notes to get the latest iteration.

Goliath is a Self-Serve Tool for Exploring and Navigating BigQuery as well as Performing all possible jobs including running queries 

Goliath is a powerful web application that enables users to perform a variety of actions with BigQuery.  It features a rich visual interface for querying data, navigating objects, and running jobs.  Goliath also allows use of parameters, enabling seamless integration with Magnus. 

Features

• Navigator – Lists datasets, tables, and their schemas(fields). Allows to filter datasets by name and labels;  group and sort tables. 
• Browser –View details of projects, datasets, parameters, and recent jobs (query, extract, load, copy). 
• Playground
  • Toolbar – Query options, visual tools, and saving options for results
  • Query Editor – Text area with editor features such as syntax highlighting, auto indentation, and auto completion
  • GoBQ Editor – playground to create Golang script with GBQ data
  • Action Bar (Buttons) – Options to load and save files, add parameters, and run queries
  • UDF – Use of user defined functions both via inline and URI
  • Parameters – Use of built-in and custom parameters in query and query options
  • Workspace – Saving and loading of Query, query Options, GoBQ Script and Parameters
• Data Explorer – Display of query results in table form
• Interactive Visualization  - Drag and drop feature that transforms data into interactive charts and graphs 

User Interface

Navigation Bar

The top part of navigation bar contains current project as a title and filtering controls.
The rest of the navigation bar is a list of datasets in the current project (presented as a dynamic tree)

• Click a dataset to expand it and show the folders/tables within that dataset. Click again to collapse it.
• Click a table to expand it and see its columns. Click again to collapse it.
• Click respective + / - icons to expand/collapse individual record type column
• Or click + / - to the right of Root (Columns) to expand / collapse all record type columns
• Hover over Dataset or Table to see more details about it
• Right Click on Project Title, Dataset, Table or Folder to get respective Action Menu
• Double-click on table or column paste respective item on cursor position in Playground Editor

Goliath Playground

Goliath Playground - Top of the page
The top part of this section contains Project and Dataset Selectors as well as context sensitive Toolbar with main actions / options to choose from

• Use the Project Selector to switch the Project in Navigation Bar or to add a Project not currently in the list (note: this does not switch billing project which is defined in Goliath configuration)
• Use the Dataset Selector as s shortcut to select and expand dataset in the Navigation Bar. Use the Toolbar to choose different modes / actions performed in Playground

The middle part of this section is the Playground Editor

• BigQuery SQL Mode
• GoBQ Mode (Golang with BigQuery, Cloud Storage Packages seamlessly supported)

The  lower part consists of action buttons and options panel

Results and Data Explorer

This section shows result as per Playground actions

• BigQuery Result (in Grid Mode – default)
• Interactive Visualization Tool (in Pivot / Chart Mode)
• Go Return value and standard output (in GoBQ Mode)

Results can be paged using page navigation above grid
For complex hierarchical output – each cell in the grid can be further viewed with popup JSON Viewer by double-clicking

Goliath Browser

This section contains information relevant to the selected action in the navigation bar or playground:

• Project Browser
• Dataset Browser
• Recent Jobs Browser
• Parameters Panel

Those presented in grids with sortable columns and the ability to filter / search content as well as choose relevant actions from the context sensitive menu (right-click)
In the Parameters Panel, double-click a parameter inserts it at the cursor position in the Playground Edit  

Main Components

 

Actions & Dialogs

Contextual Menus (on Right Click) & Info Popup (on Hover) 

More

Playground and Data Explorer 

Visualization