Skip to main content

Workbenches Overview

AI assisted Query Workbenches to develop your SQL++ queries.

info

The Worbench is common to all types of connections:

  • AI Assist needs a Capella Login
  • Not all Query Configuration parameters are not applicable for Capella Columnar

The Workbench UI

workbench-main

The UI Panels

info

Notice the Context in the AppBar
Queries will pick up the Active Database and Active Scope from this
Pic also shows the Active Store. Favorites will be picked up from here.
As a reminder, the structure of the Store (for Favorites) is:

~/Documents/MyRepository
├── Backups
├── Datasets
├── Favorites
│ ├── travel-sample
│ │ ├── inventory
│ │ │ ├── Example-of-Inner-Join##1.sql
│ │ │ ├── Example-of-Group-by-and-Order-by##2.sql

Theare are 3 sections and we will be discussing each one in further detail:

  • The SQL++ Editor
  • The Results Panel
  • The Side Panel