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

Articles > Navigator

  • 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

Navigator lists accessible datasets for the current project as well as respective objects (tables, views, models, routines) and their schemas(fields).


It also allows to filter datasets by name and labels; group and sort tables.


Hovering over Dataset or Table shows respective Info PopUp.


Right click on Billing/Data Project Title or Dataset /Table/View/Model/Routine shows Contextual Menu with all available actions for that Object or alternatively left click on more options icon.

See quick details below

Billing Project

400.png

  1. The navigation header displays the currently selected billing project.
  2. Right clicking on project header or left clicking on more options icon displays Context Menu.

Note: Free trial Users with no cloud platform scope will see a list of all their associated projects (both billing and non-billing). Users, in an organization, with no cloud platform scope will see the default project assigned to them by their administrator. Once cloud platform scope has been granted the list will be updated to including those projects that are qualified as billing.

Data Project

401.png

  1. The navigation header displays the currently selected project
  2. The count of displayed datasets out of total number of datasets
  3. Right clicking on project header displays Context Menu

Clicking on the project header displays the Project Browser.

Filtering

Filter by Dataset ID

402.png

Datasets can be filtered by ID

  1. In Filter by ID input box enter any portion of dataset’s name to be filtered. 
  2. To remove filter either remove text from the Filter by ID input box or click clear filter datasets icon to remove all text
  3. Dataset List is filtered as text is input into the Filter by ID input box.
  You can use Regular Expression in Filter by ID box

 

Filter by Labels

403.png

404.png

 To help organize projects, arbitrary labels can be added to datasets. After datasets labeled, user can search for datasets based on label values. For example, labels can be used to group datasets by purpose, environment, department, and so on.

Datasets can be filtered by label.  Labels are key value pairs that can be assigned to datasets to help organize and identify datasets. 

  1. To filter by label click the Filter by Label input box.  A drop down of available labels will display.  Typing will filter the drop down list.  Click on a label from the drop down list to select it. 
  2. With a label selected in the input box click the + icon to add the filter.  The + icon will only be active if an existing label is selected.
  3. The added filter will display under the Filter by Label section. 
  4. Datasets with the label will now be displayed.
  5. Label value is optional.  To add value, first add label by clicking in Filter by Label input box and selecting a label from the drop down list.  With a label selected click in the value (optional) input box.  A list of available values associated to selected label is listed.  Click on a value from the drop down list to select it.  With label and value present in their respective input fields click the + icon (2) to filter.  The added filter will display under the Filter by Label section (1).  Datasets with both the selected label and value will be displayed. 
    405.png
    406.png

    Multiple values can be added to a single label filter. To add multiple values, click on the value input box again to see the list of remaining values.  Clicking on another value will add it to the list of values to filter on.

  6. Clear filter by labels.  Added filters will display under the Filter by Label section.  Clicking on Remove label filter will remove the selected

Datasets can be filtered by ID and Labels at the same time

Filter by Pin/Unpin

457.png

Datasets and dataset objects can be filtered by pinning. An item can be flagged to pin/unpin and clicking on Display only pinned will filter by Datasets and/or Objects.

  1. Pins are available to the left of datasets and dataset objects. A bold, colored pin means the item is pinned. A grey colored pin means the item is not pinned. To pin/unpin an item click on the pin icon.
  2. Display only pinned provides options to filter datasets and/or dataset objects. To filter check an option.

Checking Datasets display only those datasets that are pinned.

458.png

Checking Objects displays only those dataset objects that are pinned.

459.png

Checking Datasets and Objects displays only those datasets and objects that have been pinned.

460.png

 

 

Billing Project Context Menu

461.png

 

Right click on the project name or left click more options icon in Nav to display the context menu.

Item Action

Switch Project

Changes project costs are billed to

Jobs History

Displays list of Recent Jobs

Switch Billing Project 

  1. From billing project context menu select Switch Billing Project
  2. Then select desired project

Data Project Context Menu

407.png

 

Right click on the project name or left click more options icon in Nav to display the context menu.

Item Action

Switch Project

Changes project and loads datasets in Nav

Browse

Displays Project Browser

Create Dataset

Opens dialogue to create dataset

Share Link

Opens dialogue to create and copy link to project

Refresh

Refreshes list of datasets

Recently Run

List of queries previous run

Favorite

List of queries selected as favorite

GoBQ Examples

Starter templates for GoBQ scripts

Cloud Storage

Switch to Google Cloud Storage navigator

Switch Data Project

Switch Data Project contains a list of projects user has access to

408.png

Data Project List

Data Project list may contain up to 5 sections. 

a. Pinned projects.

b. List projects user has been granted any project role. A project will not be listed if a user has not been granted any project role. Permissions granted only on dataset or table are not a project role.

c. If a user has not been granted any project role and has only been granted permissions on a dataset or table they will need to manually add the project to Goliath. The project will not automatically appear in section #a. Section #a only lists projects where the user has been granted any project role. See #a above. To add a project, click on Display project. Projects added via Display project will display in this section.

Another section (not pictured) lists temporarily added projects. This section includes projects that are available for session only. This section is normally populated when a shared link was used for a project the user does not have in list b or c.

d. Display only pinned projects toggles displaying only those projects in section a. Add/Remove project options add or remove custom projects for use with Goliath.

 

Switch Data Project

  1. From project context menu select Switch Data Project
  2. Then select desired project        

Add Data Project

  1. From project context menu select Data Switch Project
  2. Select Display project ...
  3. Type project ID in Enter Project ID field
  4. Click OK

Remove Data Project

  1. From data project context menu select Switch Data Project
  2. Select Remove project display ...
  3. In Remove Project Dialog select project from drop down to remove
  4. Click Confirm to remove

Recently Run

 

409.png

 

  1. The 5 most recent queries executed in Goliath are listed in Recently Run.  The first portion of the query is used in the list.  Left clicking on a query in the list inserts the query, options, and parameters into the workspace.
  2. Hovering over a query listing will display a preview of the query

Favorite

410.png

0411.png

 

Any Query or GoBQ Script can be marked as favorite.
The workspace (query, script, options, and parameters) are available to be saved when selecting favorite.

To mark as Favorite

  1. Prepare query or script
  2. Click on star icon (left of query text area).  Filled star indicates a saved favorite.  Empty star indicates workspace not saved as favorite
  3. A Favorite dialogue box will appear
  4. Enter the name for the favorite
  5. Options (table name, SQL version, and other options under Show Options section can be included (checked) or not (unchecked)
  6. Parameters are included if checked and not included when unchecked
  7. Click Cancel to exit without favoriting
  8. Click Favorite to save as favorite

 

412.png

Favorite List

a. Favorites are listed in Favorite context menu.  Left clicking a favorite will load the it into the workspace

b. Hovering over a favorite name will display apreview of the query

413.png

414.png

 

Delete Favorite

  1. A filled star represents a loaded favorite
  2. An empty star indicates workspace is not saved as favorite

To delete Favorite:

  1. Load a favorite
  2. Click on the star icon

GoBQ Examples

415.png

 

 

GoBQ examples are templated scripts that can be used as starting points for developing robust scripts that interact with BigQuery and Cloud Storage.

Additional information can be found in wiki section User Manual > GoBQ.

  1. BigQuery GoBQ examples are templated scripts that interact with BigQuery (projects, datasets, tables, etc)
  2. Storage GoBQ examples are templated scripts that interact with Google Cloud Storage

 

Create Dataset

 

416.png

Create Dataset Dialog prompts for information used to create a new dataset
Click OK to submit information.
A Result Dialog will appear indicating success or failure.

Input Description
Project Name of Project where Dataset is to be created. Required.
Dataset Name of Dataset to create. Required.
Description Brief description of Dataset.  Optional
Choose Data Location Drop down of data center geo location (US/EU/asia-northeast1)
Data Expiration (days) Setting for default table expiration in number of days.  Optional
Partition Expiration (days) Setting for default table partition expiration in number of days.  Optional

Encryption

Data is automatically encrypted using Google-managed key by default.

To set encryption using a Google Cloud key, select Customer-managed key and provide the Cloud KMS key to use.

Datasets

Dataset Info

 

0417.3.png

 

Hover over a dataset to display dataset information

Item Description
ID  
Creation Time  
Last Modified  
Data Location displayed if available
Dataset Size displayed once dataset opened *
Long-term Size displayed once dataset opened *
Total Rows displayed once dataset opened *
Expiration displayed if available
Owner Dataset Owner
* - reset on Project or Dataset refresh

0418.png

When a dataset is open both tables and table metadata are collected.
Popup information such as Last Modified, Dataset Size, Long-term Size, and Total Rows are obtained from table metadata.

While table metadata is gathered a loading icon will display along with a the number of tables processed out of total tables.

Once table metadata is complete the loading icons and number of tables processed out of total tables are removed.


Dataset Context Menu

419.png

Dataset Context Menu is accessed by right-clicking on dataset name  or left clicking on other options menu icon.

Item

Action

Browse

Displays Dataset Browser

Share Dataset

0420.png

 

Modify Access List

1. Project where dataset is located
2. Dataset being shared
3. Current list of entity types and access levels. Access levels for existing entities can be updated and removed using the drop-down menus.
4. Section for adding users

a. Select entity type
b. Based on type add the user’s entity such as email or name
c. Select level of permission
d. Click add
e. Repeat for each entity
f. Click save when ready to submit

Input Description
Entity Type (4a)
  • User by e-mail
  • Group by e-mail
  • Domain
  • All Authenticated Users
  • Authorized View
  • Authorized Routine
Entity (4b) Corresponding name for entity type
Access Level (4c)
  • Can View
  • Can Edit
  • Is Owner

Modify Dataset Info

0421.3_copy.png

Modify description, expiration, labels

1. Project where dataset is located
2. Dataset being modified
3. Modify Description by adding or removing text
4. Add default expiration for dataset tables by adding number
5. Add default partition expiration for dataset tables by adding number
6. Existing dataset labels

a. Remove existing labels by clicking on the remove icon
b. Edit existing values by updating the text

7. Associate dataset with labels by

a. Adding input for key
b. Optionally associate key with a value
c. Click add to include label on save
d. Repeat above to add additional labels

8. Click OK to submit modification

Delete Dataset

0422.png

  1. Project where dataset is located
  2. Dataset to be deleted
  3. Notice of the number of tables that will be deleted along with dataset
  4. To delete dataset enter the name of the dataset and then click OK

Script Tables List

Insert script list into query text area

Load Table Data
423.png

Load data from a local file or cloud storage to GBQ destination

When loading data from a local file the size limit is 100 MB for Latin1 encoded files and 10 MB for non-Latin1 encoded files.
For file sizes greater than these limits first load the file to Google Cloud Storage and from there load to GBQ destination.

1. To load table data begin with the Source File section which contains options for handling the data file

a. Select where you want to load data from (local file or Google Cloud Storage)

b. Select the file you want to upload (either local or Google Cloud Storage location)

c. Specify the format (CSV, JSON, AVRO)

d. Add a numeric value to indicate how many errors are acceptable for the load before the job should fail

e. Check this box to ignore entries in source that do not match data schema in destination.  These values will be ignored and not loaded

f. Select the delimiter of the source file (Comma, Tab, Pipe, Other).  If Other is selected enter the custom delimiter

g. Enter a number of rows to skip, such as headers, that are not to be loaded

h. Check if data contains new lines within quotes

i. Check to ignore missing optional columns

2. Continue by specifying the destination table configuration

a. Project where the table will be created

b. Dataset where the table will be created

c. Enter the name of the table

d. Select from drop down what should happen if the table exists (Fail, Append to it, Overwrite it)

e. Enter a number value to indicate how many days before table expires.

f.  Check to have the system auto-determine the schema based on source file.

g. If auto-detect schema is unchecked manually type the schema of the table to be created.  Format is JSON and must have name and type
Example:
  {
  "name": "myCol1",
  "type": "INTEGER"
  }

h. Select Partition Type which specifies partitioning with None being no partition and Day being partition by day.  See Partitioned Tables.

i.  If a partition type is specified select from drop down to specify partition field 

j. Check to require queries to include a partition filter

k. Add expiration, in days, for partition.  If no partition expiration then leave blank.

l. Enter up to four column names, separated by commas, to indicate clustering of data.

3. Processing Location identifies where the job will be processed.

 a. Location options.

4. Options includes Encryption

a. Encryption options include Google managed-key and Customer managed-key. Data is automatically encrypted using Google-managed key by default. To set encryption using a Google Cloud key, select Customer-managed key and provide the Cloud KMS key to use.

5. Submit by clicking OK.

Create Empty Table

424.png

 

Creates an empty table

To create an empty table, fill out the information.

  1. Project where the table will be created.
  2. Dataset where the table will be created.
  3. Enter the name of the table.
  4. Enter a number value to indicate how many days before table expires.
  5. Type the schema of the table to be created.  Format is JSON and must have name and type.
    Example:
    {
    "name": "myCol1",
    "type": "INTEGER"
    }
  6. Select Partition Field. None is no partition. Default is partitioned by pseudo column _PARTITIONTIME. Options available for Schema top-level TIMESTAMP, DATE, DATETIME, or INTEGER field.
  7. Select Partition Type which specifies partitioning. If Partition Field is time-based, options include Hour, Day, Month, and Year.
    1. If Partition Field is integer-based options include Start and End Range along with
    2. Range Interval
      462.png
  8. Check to set partition filter is required when querying.
  9. Add expiration, in days, for partition.  If no partition expiration, then leave blank.
  10. Enter up to four column names, separated by commas, to indicate clustering of data.
  11. Options includes Encryption
    1. Encryption options include Google managed-key and Customer managed-key. Data is automatically encrypted using Google-managed key by default. To set encryption using a Google Cloud key, select Customer-managed key and provide the Cloud KMS key to use.
  12. Submit by clicking OK.

Create External Table

0424.3.2_copy.png

Creates an external table

To create an external table fill out the information.

  1. Select from drop down specifying data source type.
  2. Enter the source location of data.
  3. Select from drop down to specify data source format type.
  4. Enter a number value to indicate how many errors to encounter before failing.
  5. Check this box to ignore entries in source that do not match data schema in destination.  These values will be ignored and not loaded.
  6. Select the delimiter of the source file (Comma, Tab, Pipe, Other).  If Other is selected enter the custom delimiter.
  7. Enter a number of rows to skip, such as headers, that are not to be loaded.
  8. Check if data contains new lines within quotes.
  9. Check to ignore missing optional columns.
  10. Project where the external table will created.
  11. Dataset where the external table will be created.
  12. Enter the name of the table.
  13. Select from drop down what should happen if the table exists (Fail, Append to it, Overwrite it).
  14. Enter a number value to indicate how many days before table expires.
  15. Check to have the system auto-determine the schema based on source file.
  16. If auto-detect schema is unchecked manually type the schema of the table to be created.  Format is JSON and must have name and type.

    Example:
      {
      "name": "myCol1",
      "type": "INTEGER"
      }
  17. Processing Location identifies where the job will be processed.
  18. Submit by clicking OK

Create Model

Click to insert template into text area to create a model.

Create Function

Click to insert template into text area to create a function.

Create Procedure

Click to insert template into text area to create a procedure.

Create Materialized View

Click to insert template into text area to create a materialized view.

Share Link

0425.png

Shares a direct link to dataset by copying URL to clipboard.

Refresh

Refreshes list of tables.

Table

Grouping & Sorting

Tables are listed under their respective dataset.  

Tables are sorted by case sensitive name.

Table list is paged.  Currently datasets with greater than 2,000 items are paged.
An additional page of 2,000 is loaded by clicking on Show More.

Table names ending in date formats such as YYYYMMDD are consolidated by year and month depending on their quantity.
Currently if only one table meets the format criteria it is not consolidated and will instead display the full name.

 

Tables are prepended with an icon:

Icon Represents

426a.png

Table
426b.png External Table

426c.png

View
426d.png Materialized View

426e.png

Folder for grouped tables

426f.png

Model
426g.png Procedure
426h.png Function

 

Expanding tables

Columns are displayed by left clicking on a table to expand it. 

Folders also have a context menu (right-click)

Menu Item Action
Expand Expands selected node
Collapse Closes selected node

 

 

429.png

Expanding datasets (left click) displays a list of tables associated with the dataset. 

  1. A count of tables within that dataset is displayed to right of dataset name. 
  2. Consolidated tables display a folder icon. Consolidated tables are tables with the same table name followed by a data in the format of YYYYMMDD.
  3. An icon representing an External Table.
  4. An icon representing a Function.
  5. An icon representing a Materialized View.
  6. An icon representing a Model.
  7. An icon representing a Stored Procedure.
  8. An icon representing a Table.
  9. An icon representing a View.
  10. Sorting selections are available.  To sort tables, make a selection from the sort dropdown. Sorting is available once all table metadata is processed

    Sort Option
    Name
    Size
    Rows
    Created
    Modified
    Location
    Expired
    Type

     

     

  11. Click on AZ icon to switch between ascending and descending order.

Note: For Sort Option Name the top level name is sorted only. Children of consolidated tables are not sorted.

Table's Schema

430.png

  1. Columns are displayed under the table name. 
  2. The name of the column is displayed
  3. Along with the data type which is color coded for visual representation
  4. Columns with record data types can be further expanded (indicated with + or – icon before table name)

Insert the column to query text area by double clicking column

Table Info

0431.3.png

Hover over a table to display popup information

Item Description
Type Table
ID  
Table Size  
Number of Rows  
Long-term Size Size considered “long-term storage”
Creation Time  
Last Modified  
Expiration Time displayed if available
Data Location displayed if available
Labels displayed if available
Estimated Size Streaming tables only.  Buffer size
Estimated Rows Streaming tables only.  Buffer row count
Oldest Entry Time Streaming tables only.  Latest entry into buffer
Partition Type Partitioned tables only

View Info

 

431a.png

Hover over a view to display popup information

Item Description
Type View 
ID  
Creation Time  
Last Modified  
Expiration Time displayed if available
Data Location displayed if available
SQL Mode Mode the view was created in

Materialized View Info

 

431c.png

Hover over a materialized view to display popup information

Item Description
Type Materialized View
ID  

Materialized View Size

 

Number of Rows

 

Long-term Size

 

Creation Time

 

Last Modified

 

Expiration Time

displayed if available

Data Location

 

Description

displayed if available

Enable Refresh

 

Last Refresh Time

 

Refresh Interval (ms)

 

Model Info

431d.png

Hover over a model to display popup information

Item Description

Type

Model

ID

 

Creation Time

 

Last Modified

 

Expiration Time

displayed if available

Data Location

 

Description

displayed if available

Labels

displayed if available

Model Type

 

Loss Type

 

Training Runs

 

Training Options

 

Function Info

431e.png

Hover over a view to display popup information

Item Description

Type

function type

ID

 

Creation Time

 

Last Modified

 

Expiration Time

displayed if available

Language

script language

Arguments

 

Return Type

 

Procedure Info

 

431f.png

Hover over a view to display popup information

Item Description

Type

function type

ID

 

Creation Time

 

Last Modified

 

Expiration Time

displayed if available

Language

script language

Arguments

 

Definition Body

 

 

 

Table Context Menu

432v2.png

 

Table Context Menu is accessed by right-clicking on table name

Menu Item

Action

Preview Table

Switches to Preview Mode and displays table's data for user to explore

Query Table

 

Query Table > Insert table

 Inserts table to query area at cursor

Query Table > Insert all fields

 Inserts all table fields to query area at cursor

Query Table > Insert picked fields

Inserts selected fields from list to query area at cursor

Query Table > Insert “select from table”

Inserts select from selected table query. The type of insert depends on the option selected under User Settings > Default Insert. Options include overwrite, insert at cursor, insert at end of page, or insert in a new tab.

Query Table > Insert “select all fields from table”

Inserts selection of all columns from table.  The type of insert depends on the option selected under User Settings > Default Insert. Options include overwrite, insert at cursor, insert at end of page, or insert in a new tab.

Query Table > Insert “select picked fields from table”

Inserts selected columns from table. The type of insert depends on the option selected under User Settings > Default Insert. Options include overwrite, insert at cursor, insert at end of page, or insert in a new tab.

Copy Table

0444.png

Copy selected table to new destination

1. To copy a table confirm source information is correct

a. Project where table is
b. Dataset where table is
c. Table to be copied

2. Fill in information for Destination

a. Add Project where table is to be copied to
b. Add Dataset where table is to be copied to
c. Name the table
d. Select what happens if table already exists (Fail, Append to it, Overwrite it)
e. Select what happens if table doesn’t exist (Create It, Fail)

3. Processing Location

 a. Identifies where the job will be processed. Options include US, EU, and asia-northeast.

4. Click OK to submit request

Export Table

0445.png

Export table to cloud storage

1. To export a table to cloud storage confirm source information is correct

a. Project where table is
b. Dataset where table is
c. Table to be exported

2. Fill in information for Destination

a. Select format to export to (CSV, JSON, AVRO)
b. Select compression of file (None, GZIP)
c. Select delimiter of file (Comma, Tab, Pipe, Other)
d. Check to include headers in output
e. Provide URI to Google Cloud Storage (URI and filename)

3. Processing Location

 a. Identifies where the job will be processed. Options include US, EU, and asia-northeast.

4. Click OK to submit request

Share Table 

483.png

Share table with users.

 

Access List displays those who have access to the table.

Add Access allows members to be added to the share. Type options include User by e-mail, Group by e-mail, Domain, All Authenticated Users, and Service Account. Access Level options include Can View, Can Edit, Is Owner, and Remove Access.

Modify Table Info

0435v2.png

Modify table description, retention, and labels.

A table’s description, retention, and labels can be modified

  1. Project where table is located
  2. Dataset where table is located
  3. Table to be modified
  4. Add, edit, or remove text to modify description
  5. Date time will be listed here if the table has an expiration date
  6. Add a numeric value to modify expiration or enter 0 to remove an existing expiration
  7. If expiration value is given then provide unit (Hours, Days)
  8. Existing table labels
    a. Remove existing labels by clicking on the remove icon
    b. Edit existing values by updating the text
  9. Associate table with labels by
    a. Add input for key
    b. Optionally associate key with a value
    c. Click add to include label on save

Delete Table

0436.png

To delete a table verify the correct table is selected and then click Confirm

Show Schema

0437.png

0438.png

 

Display table schema, modify, or add new field

  1. Table schema is presented in JSON format
  2. Click on Modify to edit the schema
  3. Click Add Field to  add columns to schema


    Modifying Schema
  4. Modify mode allows editing the schema
  5. Click OK to submit changes

    Adding field
  6. A field can be appended to end of the root or a repeated column
  7. Enter the name of the field
  8. Click drop down to select data type
  9. Click drop down to assign NULLABLE or REPEATED
  10. Click submit to add field

0439.png

Share Link

0440.png

 

Click on Copy Link to copy URL to clipboard that links directly to table

View Context Menu

View Context Menu is accessed by right-clicking on view name

484.png

 

Menu Item Action
Show View Inserts view query to text area.  Not available in preview mode

Share View

485.png

Share View with users.

 

Access List displays those who have access to the view.

Add Access allows members to be added to the share. Type options include User by e-mail, Group by e-mail, Domain, All Authenticated Users, and Service Account. Access Level options include Can View, Can Edit, Is Owner, and Remove Access.

Query View > Insert view  Inserts view to query area at cursor
Query View > Insert all fields Inserts all fields to query area at cursor
Query View > Insert picked fields Inserts selected fields from list to query area at cursor
Query View > Insert “select from view”  Inserts select from selected view to query area. The type of insert depends on the option selected under User Settings > Default Insert. Options include overwrite, insert at cursor, insert at end of page, or insert in a new tab.
Query View > Insert “select all fields from view” Inserts all columns from view to query text area. The type of insert depends on the option selected under User Settings > Default Insert. Options include overwrite, insert at cursor, insert at end of page, or insert in a new tab.
Query View > Insert “select picked fields from view” Inserts selected columns from view to query text area. The type of insert depends on the option selected under User Settings > Default Insert. Options include overwrite, insert at cursor, insert at end of page, or insert in a new tab.
Modify View Info
463.png

Modify view description and retention

A view’s description and retention can be modified

  1. Project where view is located
  2. Dataset where view is located
  3. View to be modified
  4. Add, edit, or remove text to modify description
  5. Date time will be listed here if the view has an expiration date
  6. Add a numeric value to modify expiration or enter 0 to remove an existing expiration
  7. If expiration value is given then provide unit (Hours, Days)
  8. Existing labels
    Remove existing labels by clicking on the remove icon
    b. Edit existing values by updating the text
  9. Associate view with labels by
    Add input for key
    b. Optionally associate key with a value
    c. Click add to include label on save
Associate table with labels by adding input for key and optionally associate key with a value. Click add to include label on save.

Delete View
464.png

To delete a view, verify the correct view is selected and then click Confirm

Show Schema

465.png

Displays the view’s schema.
Share Link Click on Copy Link to copy URL to clipboard that links directly to view

 

Model Context Menu

Model Context Menu is accessed by right-clicking on model name or let clicking on other options menu icon.

0448.png

Menu Item Action
Query Model > Retrieve Training Information Inserts starter template to query text area that provides training information on model.
Query Model > Evaluate Metrics (Template) Inserts starter template to query text area that evaluates model metrics.
Query Model > Evaluate Logistic Regression Model (Template) Inserts starter template to query text area that evaluates regression-specific metrics.
Query Model > Produce Confusion Matrix (Template) Inserts starter template to query text area that provides a confusion matrix.
Query Model > Predict Outcome (Template) Inserts starter template to query text area that predicts outcomes.
Query Model > Inspect Input Features Inserts starter template to query text area that provides information on input features used to trail model.
Query Model> Inspect Weights Info Inserts starter template to query text area that provides weights used by model during prediction.
Train Model Inserts starter template to query text area that trains model.
Copy Model
466.png

Copy selected model to new destination.

  1. To copy a model, confirm source information is correct.
  2. Add Project to be copied to.
  3. Add Dataset to be copied to.
  4. Name the model.
  5. Select what happens if model already exists (Fail, Append to it, Overwrite it).
  6. Select what happens if model doesn’t exist (Create It, Fail).
  7. Processing Location.  Identifies where the job will be processed.

Click OK to submit request.

Modify Model Info

467.png

Modify model description, retention, and labels.

A model’s description, retention, and labels can be modified

  1. Project where model is located
  2. Dataset where model is located
  3. Model to be modified
  4. Add, edit, or remove text to modify description
  5. Date time will be listed here if the table has an expiration date
  6. Add a numeric value to modify expiration or enter 0 to remove an existing expiration
  7. If expiration value is given then provide unit (Hours, Days)
  8. Existing labels
    1. Remove existing labels by clicking on the remove icon
    2. Edit existing values by updating the text
  9. Associate model with labels by
    1. Add input for key
    2. Optionally associate key with a value
    3. Click add to include label on save

Delete Model

468.png

To delete a model, verify the correct view is selected and then click Confirm

Show Schema

469.png

Displays the model's schema.

Share Link

470.png

Click on Copy Link to copy URL to clipboard that links directly to model.

Materialized View Context Menu

Materialized View Context Menu is access by right-clicking on model name or left click on other options menu icon.

472.png

Menu Item

Action

Show Materialized View

Inserts materialized view query to text area. 

Query Materialized View > Insert materialized view name

 

Query Materialized View > Insert all fields

 

Query Materialized View > Insert picked fields

Inserts selected fields from list.

Query Materialized View > Insert “select from materialized view”

Inserts select from selected materialized view. The type of insert depends on the option selected under User Settings > Default Insert. Options include overwrite, insert at cursor, insert at end of page, or insert in a new tab.

Query Materialized View > Insert “select all fields from materialized view”

Inserts selection of all columns from materialized view. The type of insert depends on the option selected under User Settings > Default Insert. Options include overwrite, insert at cursor, insert at end of page, or insert in a new tab.

Query Materialized View > Insert “select picked fields from materialized view”

Inserts selected columns from materialized view. The type of insert depends on the option selected under User Settings > Default Insert. Options include overwrite, insert at cursor, insert at end of page, or insert in a new tab.

Modify Materialized View Info

 

479.png

Modify materialized view description, retention, and labels.

A materialized view's description, retention, and labels can be modified

  1. Project where materialized view is located
  2. Dataset where materialized view is located
  3. Materialized view to be modified
  4. Add, edit, or remove text to modify description
  5. Date time will be listed here if the table has an expiration date
  6. Add a numeric value to modify expiration or enter 0 to remove an existing expiration
  7. If expiration value is given then provide unit (Hours, Days)
  8. Associate model with labels by
    1. Add input for key
    2. Optionally associate key with a value
    3. Click add to include label on save
  9. Existing labels (not pictured)
    1. Remove existing labels by clicking on the remove icon
    2. Edit existing values by updating the text

Delete Model

480.png

To delete a materialized view, verify the correct materialized view is selected and then click Confirm

Show Schema

Displays the materialized view’s schema.

Share Link

Click on Copy Link to copy URL to clipboard that links directly to materialized view.

Procedure Context Menu

Procedure Context Menu is access by right-clicking on model name or left click on other options menu icon.

473.png

Menu Item

Action

Modify Routine Info482.png

 

Modify routine's description

Invoke Procedure

Inserts text into query area to template call procedure.

Edit Procedure

Inserts text into query area to template create or replace procedure.

Delete Procedure

474.png

 

To delete a procedure, verify the correct procedure is selected and then click Confirm

Share Link

Click on Copy Link to copy URL to clipboard that links directly to procedure.

 

Function Context Menu

Function Context Menu is access by right-clicking on model name or left click on other options menu icon.

4723.png

Menu Item

Action

Modify Routine Info

481.png

Modify routine's description

Invoke Function

Inserts text into query area to template call function.

Edit Function

Inserts text into query area to template create or replace function.

Delete Function

478.png

To delete a function, verify the correct function is selected and then click Confirm

Share Link

Click on Copy Link to copy URL to clipboard that links directly to procedure.

Storage

Goliath displays Google Cloud Storage buckets and folders in the navigator.  To display Storage items select GCS Storage menu item from the Project Context Menu

1401b.png

Storage Context Menu

When Storage is displayed in the navigator the Project Context Menu will change to handle Storage related tasks.  Menu items that are not relevant to Storage are grayed out.

1130b.png

Switch Project

The project listings remain the same.  However when selecting a project to switch to the navigator will load Storage buckets associated to that project instead of it’s datasets.

Buckets

Bucket menu item is unique to Storage Context Menu.  Similar to functionality for Switch Projects Buckets the menu item lists individual Storage Buckets added to display by the user. 

  • To switch to a Bucket click on the bucket from the Buckets list. 
  • To add a bucket select Display bucket… from the menu and enter the bucket name.  Click on Remember checkbox to save the bucket and have it listed in the Buckets list. 
  • To remove a saved bucket click on Remove bucket display… and select the bucket from the drop down menu.

Browse, Recent Jobs, Create Dataset, and Share Link are disabled and not available when displaying Storage in the navigator 

Refresh will refresh all buckets listed in the navigator 

Recently Run, Favorite, and GoBQ Examples remain the same both Dataset and Storage navigation 

GBQ Datasets option becomes available when in Storage navigation.  Clicking on GBQ Datasets will switch to dataset listing in the navigator.

Buckets

Storage navigator lists buckets associated to the displayed project.

1132.png

User Filter by ID to filter buckets

1133.png

Single left click on bucket to expand object

1134.png

 

Hover over bucket to obtain popup with metadata

1135.png


Right click on a bucket to open Bucket Context Menu

1136.png


Bucket Objects

Buckets contain files.  The file path is broken into folders and files.  For example a file path with folder1/folder2/filename.txt will be displayed in the navigator under a folder named folder1 and a subfolder named folder2 that contains a file titled filename.txt

In the navigator folders have a folder icon and files have a file icon
1137.png

Single left click to expand a folder

1138.png

Right click on a file to open File Context Menu

1139.png

Hover over file to obtain popup with file metadata

1140.png

Pin/Unpin Projects, Datasets and Objects (Beta Feature)

Projects, Datasets and the Objects within Datasets can be pinned for easy access to frequently used items. The Navigator and the Switch Data Projects context menu both contain controls to show only pinned or both pinned and unpinned items.

Pin/Unpin Projects

Projects can be pinned or unpinned by clicking the Pin icon to the left of items in the Switch Data Projects context menu. A rotated pin icon is shown to the left of pinned Projects.

0449.png

 

Pinned Projects are displayed additionally at the top of the Switch Data Projects context menu.

0450.png

 

At the bottom of the Switch Data Projects context menu clicking, “Display only pinned projects” changes the mode of the menu to hide unpinned projects from view.

0451.png

 

Clicking, “Display pinned and available projects” in the Switch Data Projects context menu changes the mode back to displaying both pinned and unpinned items.

0452.png

 

Pin/Unpin Datasets and Objects

Datasets and Objects can be pinned or unpinned by clicking the Pin icon to the left of items in the Navigator. A colored rotated pin icon is shown to the left of pinned items.

0453.png

 

Checking the box labeled, “Display only pinned: Datasets” above the Datasets in the Navigator hides all Datasets which are not pinned.

0454.png

 

Checking the box labeled, “Display only pinned: Objects” above the Datasets in the Navigator hides all Objects which are not pinned.

0455.png

 

Checking the boxes labeled, “Display only pinned: Datasets/Objects” above the Datasets in the Navigator hides all Datasets and Objects which are not pinned.

0456.png

 

Saving Pins

Pinned items are automatically saved across page loads.

Pinned items can also be saved to or backed up from a file by clicking “Save / Load Settings” in the settings menu.

 

 

 

Potens.io
Launch Magnus | Goliath