Navigator

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

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

Note: Users with no cloud platform scope will see a list of all their associated projects (both billing and non-billing). Once cloud platform scope has been granted the list will be updated to including those projects that are qualified as billing.

Data Project

The navigation header displays the currently selected project The count of displayed datasets out of total number of datasets Right clicking on project header displays Context Menu Clicking on the project header displays the Project Browser.

Filtering

Filter by Dataset ID

Datasets can be filtered by ID In Filter by ID input box enter any portion of dataset’s name to be filtered.  To remove filter either remove text from the Filter by ID input box or click clear filter datasets icon to remove all text 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

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.  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.  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. The added filter will display under the Filter by Label section.  Datasets with the label will now be displayed. 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.  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. 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

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. 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. 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. Checking Objects displays only those dataset objects that are pinned. Checking Datasets and Objects displays only those datasets and objects that have been pinned.

 

 

Billing Project Context Menu

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

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

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 From project context menu select Switch Data Project Then select desired project         Add Data Project From project context menu select Data Switch Project Select Display project ... Type project ID in Enter Project ID field Click OK Remove Data Project From data project context menu select Switch Data Project Select Remove project display ... In Remove Project Dialog select project from drop down to remove Click Confirm to remove

Recently Run

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. Hovering over a query listing will display a preview of the query

Favorite

	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 Prepare query or script Click on star icon (left of query text area).  Filled star indicates a saved favorite.  Empty star indicates workspace not saved as favorite A Favorite dialogue box will appear Enter the name for the favorite Options (table name, SQL version, and other options under Show Options section can be included (checked) or not (unchecked) Parameters are included if checked and not included when unchecked Click Cancel to exit without favoriting Click Favorite to save as favorite
	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
	Delete Favorite A filled star represents a loaded favorite An empty star indicates workspace is not saved as favorite To delete Favorite: Load a favorite Click on the star icon

GoBQ Examples

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. BigQuery GoBQ examples are templated scripts that interact with BigQuery (projects, datasets, tables, etc) Storage GoBQ examples are templated scripts that interact with Google Cloud Storage

Create Dataset

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

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

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

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

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

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

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

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

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
      
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

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

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
	Table
	External Table
	View
	Materialized View
	Folder for grouped tables
	Model
	Procedure
	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

Expanding datasets (left click) displays a list of tables associated with the dataset.  A count of tables within that dataset is displayed to right of dataset name.  Consolidated tables display a folder icon. Consolidated tables are tables with the same table name followed by a data in the format of YYYYMMDD. An icon representing an External Table. An icon representing a Function. An icon representing a Materialized View. An icon representing a Model. An icon representing a Stored Procedure. An icon representing a Table. An icon representing a View. 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 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

Columns are displayed under the table name.  The name of the column is displayed Along with the data type which is color coded for visual representation 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

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

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

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

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

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

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

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	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	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	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	Modify table description, retention, and labels. A table’s description, retention, and labels can be modified Project where table is located Dataset where table is located Table to be modified Add, edit, or remove text to modify description Date time will be listed here if the table has an expiration date Add a numeric value to modify expiration or enter 0 to remove an existing expiration If expiration value is given then provide unit (Hours, Days) Existing table labels a. Remove existing labels by clicking on the remove icon b. Edit existing values by updating the text 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	To delete a table verify the correct table is selected and then click Confirm
Show Schema	Display table schema, modify, or add new field Table schema is presented in JSON format Click on Modify to edit the schema Click Add Field to  add columns to schema Modifying Schema Modify mode allows editing the schema Click OK to submit changes Adding field A field can be appended to end of the root or a repeated column Enter the name of the field Click drop down to select data type Click drop down to assign NULLABLE or REPEATED Click submit to add field
Share Link	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

Menu Item	Action
Show View	Inserts view query to text area.  Not available in preview mode
Share View	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	Modify view description and retention A view’s description and retention can be modified Project where view is located Dataset where view is located View to be modified Add, edit, or remove text to modify description Date time will be listed here if the view has an expiration date Add a numeric value to modify expiration or enter 0 to remove an existing expiration If expiration value is given then provide unit (Hours, Days) Existing labels Remove existing labels by clicking on the remove icon b. Edit existing values by updating the text 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	To delete a view, verify the correct view is selected and then click Confirm
Show Schema	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.

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	Copy selected model to new destination. To copy a model, confirm source information is correct. Add Project to be copied to. Add Dataset to be copied to. Name the model. Select what happens if model already exists (Fail, Append to it, Overwrite it). Select what happens if model doesn’t exist (Create It, Fail). Processing Location.  Identifies where the job will be processed. Click OK to submit request.
Modify Model Info	Modify model description, retention, and labels. A model’s description, retention, and labels can be modified Project where model is located Dataset where model is located Model to be modified Add, edit, or remove text to modify description Date time will be listed here if the table has an expiration date Add a numeric value to modify expiration or enter 0 to remove an existing expiration If expiration value is given then provide unit (Hours, Days) Existing labels Remove existing labels by clicking on the remove icon Edit existing values by updating the text Associate model with labels by Add input for key Optionally associate key with a value Click add to include label on save
Delete Model	To delete a model, verify the correct view is selected and then click Confirm
Show Schema	Displays the model's schema.
Share Link	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.

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	Modify materialized view description, retention, and labels. A materialized view's description, retention, and labels can be modified Project where materialized view is located Dataset where materialized view is located Materialized view to be modified Add, edit, or remove text to modify description Date time will be listed here if the table has an expiration date Add a numeric value to modify expiration or enter 0 to remove an existing expiration If expiration value is given then provide unit (Hours, Days) Associate model with labels by Add input for key Optionally associate key with a value Click add to include label on save Existing labels (not pictured) Remove existing labels by clicking on the remove icon Edit existing values by updating the text
Delete Model	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.

Menu Item	Action
Modify Routine Info	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	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.

Menu Item	Action
Modify Routine Info	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	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

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.

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.

User Filter by ID to filter buckets

Single left click on bucket to expand object

Hover over bucket to obtain popup with metadata

Right click on a bucket to open Bucket Context Menu

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

Single left click to expand a folder

Right click on a file to open File Context Menu

Hover over file to obtain popup with file metadata

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.

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

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.

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

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.

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

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

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

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.