Logo
  1. Potens.io
  2. Goliath
  3. User Manual

Articles > Browser

  • Navigator
  • Browser
  • Playground
  • Data Explorer
  • Geography Visualization
  • Execution Details
  • Intellisense
  • Sessions
  • UI Redesign
  • Feature Updates

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

  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

0501.3.png

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.

508.png

Context Menu

0502.png

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

0503.png

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.

509.png

Table Context Menu

0504v2.png

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

510.png

Right clicking on a view opens the View Context Menu

Model Context Menu

511.png

Right clicking on a model opens the Model Context Menu

Function Context Menu

512.png

Right clicking on a function opens the Function Context Menu

Procedure Context Menu

513.png

Right clicking on a procedure opens the Procedure Context Menu

Materialized View Context Menu

514.png

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

0505.png

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

506.4.png

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.

0507.png

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.

515.png

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

 

Potens.io
Launch Magnus | Goliath