Browser

Overview

Goliath features a Browser panel that displays dataset and table metadata and jobs history

1. Project Browser displays datasets associated to the currently selected project along with dataset metadata in a sortable, filterable table
2. Dataset Browser displays tables associated to the selected dataset along with table metadata in a sortable, filterable table
3. Jobs History Browser displays recent query and job history in a sortable, filterable table

Below is a detailed description of each Browser panel

Project Browser

Project Browser is accessed by clicking on Project header in navigator or selecting Browser from the Project context menu. 

Grid Data-points

Datasets are listed in the browser along with metadata including

• Creation Time
• Expiration
• Partition Expiration
• Location
• Size
• Total Rows
• Owner
• Description

Actions

Filtering

Datasets can be filtered by typing in the filter datasets box.  The x icon clears the filter. Regular Expressions can be used here

Sorting

Columns are sorted by clicking on respective table header

Column Resizing

Columns can be resized by clicking between the column headers and dragging left or right.

Context Menu

Right clicking on a dataset opens the Dataset Context Menu  Left double-clicking on a dataset opens the Dataset Browser Close the browser window by clicking the Close Browser (x) icon on the right

 

Dataset Browser

Dataset Browser is accessed by double clicking on a dataset in navigator, selecting Browser from the Dataset context menu, or clicking on a dataset from the Project Browser.

Dataset’s tables are listed and paged if the count exceeds count of displayable rows.

Grid Data-points

The dataset’s tables are listed in the browser along with metadata including

• Size
• Rows
• Creation Time
• Last Modified
• Expiration
• Location 

Actions

Filtering

Tables can be filtered by typing in the filter tables box.  The entire list (not just the displayable list) is filtered

The x icon clears the filter. Regular Expressions can be used here

Sorting

Columns are sorted by clicking on respective table header

The entire list (not just the displayable list) is sorted

Column Resizing

Columns can be resized by clicking between the column headers and dragging left or right.

Table Context Menu

Right clicking on a table opens the Table Context Menu Close the browser window by clicking the Close Browser (x) icon on the right

View Context Menu

Right clicking on a view opens the View Context Menu

Model Context Menu

Right clicking on a model opens the Model Context Menu

Function Context Menu

Right clicking on a function opens the Function Context Menu

Procedure Context Menu

Right clicking on a procedure opens the Procedure Context Menu

Materialized View Context Menu

Right clicking on a materialized view opens the Materialized View Context Menu

Jobs History Browser

Jobs History is accessed from the Billing Project Context Menu. 

Jobs History will initially list jobs from the project that meets the criteria below

1. If the project displayed in the navigator is available to user as a billing project then the jobs list opens the project in the navigator
2. If the project displayed in the navigator is not available to the user as a billing project then the jobs list opens the project that is specified as the default billing project

Grid Data-points

Recent jobs are listed in the browser along with data points including

• Create Time
• End Time
• Type
• Status
• Duration
• Cost
• Tier
• Job Info
• Query 
• Execution Details

Context Menu

Right clicking on the Jobs History Browser header opens theJobs History Browser Context Menu Switch Billing Project displays a list of available billing projects.  Selecting a project will load the recent jobs list for that project Refresh reloads job list for the currently displayed billing project

Details and Navigation

Job Info is presented in JSON format

JSON viewer is available by double clicking anywhere in the table.  Along with displaying results the viewer contains action items depending on the type of job.

The arrow icons as well as arrow keys on your keyboard can be used to move through rows and columns of the recent jobs table.

These action items are also available from the Job Info context menu accessed by right-clicking anywhere in the table

Job Info action items include below

Context Menu	Availability Type	Action
Refresh	Query	Updates a running query with the latest job information
Edit Query	Query	Inserts the query into text area
Cancel Job	Query	Cancels job.  Available only for jobs with status of pending or running
Show Results	Query	Displays results.  Available only for jobs with results not yet expired
Template Job	Copy/Load	Opens dialogue menu and populates entries with values used in job
Show All Jobs In Script	Script	Displays jobs that comprise multiple statements of the script

Actions

Filtering

Query can be filtered by typing into the Filter on query input box.  Clicking on X clears the filter text.           

Sorting

Columns Create Time, End Time, Type, Status, Duration, Cost, and Tier can be sorted by clicking on the table header

Column Resizing

Columns can be resized by clicking between the column headers and dragging left or right.

Paging

Page navigation is available to page through Recent Jobs.  First navigates to the most recent history, Prev displays the previous page of history, and Next moves to the next page of rows.  The current page number being viewed is displayed