BigQuery Sessions

Goliath supports BigQuery Sessions. With sessions, temporary tables, functions, and variables can be used throughout the session with multiple queries.

Create a Session

Sessions are initiated from query options

1. From Editor playground, click Show Options.
2. In Options, check Use Session Mode
   1. For Session Options, either create a new session or join an existing one.
   2. To join an existing session, supply the Session ID or select from existing sessions.
3. To indicate that the tab is in Session Mode, a color is applied to the tab. The color can be selected by entering Session Tab Color.
   1. You can have multiple sessions identified by different colored tabs.
      
      
   2. You can have the same session opened in multiple tabs and identified by a single color.
   3. The color is assigned defaults which can be changed by clicking on the dropdown and selecting from available colors.
   4. The color can be changed by selecting a different color.
      

Session Mode Identifiers

In addition to coloring of the tab, the Editor playground will display Session Mode to indicate that the mode is active.

When a query is run in Session Mode, the last query stats will include Session Id. This Id can be used to join a session.

Saving Session Options

Session options can be saved as part of workspaces. When saving a workspace, check Include Options.

Sessions options can also be saved as Favorite. When Mark as Favorite, check Include Options.