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.
Overview
Goliath features a Browser panel that displays dataset and table metadata and jobs history
- Project Browser displays datasets associated to the currently selected project along with dataset metadata in a sortable, filterable table
- Dataset Browser displays tables associated to the selected dataset along with table metadata in a sortable, filterable table
- 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
- 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
- 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
|
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