Shortcuts
Shortcuts work while a Strata SQL editor is active. On Mac use Cmd; on Windows and Linux use Ctrl.
Editor#
| Shortcut | Action |
|---|
| Cmd/Ctrl + S | Save the model and its version log |
| Cmd/Ctrl + Z, Shift + Cmd/Ctrl + Z | Undo, redo |
| Cmd/Ctrl + 1 | Auto layout |
| Cmd/Ctrl + Y | Toggle version history |
| Cmd/Ctrl + L | Toggle the navigator |
| Cmd/Ctrl + F | Search the model |
| Cmd/Ctrl + . | Hide all open panels; press again to bring them back |
| Cmd/Ctrl + F1 | The built-in help |
| Esc | Close the open dialog, popup or search |
Levels#
| Mac | Windows / Linux | Switches to |
|---|
| Cmd + Option + G | Ctrl + Alt + G | Governance |
| Cmd + Option + C | Ctrl + Alt + C | Conceptual |
| Cmd + Option + L | Ctrl + Alt + L | Logical |
| Cmd + Option + P | Ctrl + Alt + P | Physical |
| Cmd + Option + S | Ctrl + Alt + S | Semantic |
While the editor has focus, these take the place of two VS Code defaults: Copy Path of Active File and Save All.
Mouse#
| Gesture | Action |
|---|
| Wheel or trackpad | Pan |
| Cmd/Ctrl + wheel, pinch | Zoom |
| Drag the background | Pan |
| Drag a table header | Move the table |
| Drag a column row onto another | Create a relationship |
| Drag from a concept or entity body | Relate two concepts or entities |
| Double-click a card header | Edit the table, concept, entity or metric |
Command Palette#
| Command | Does |
|---|
| Strata SQL: New Project | The project wizard |
| Strata SQL: Open Sample Model | Create the Northwind or FpML sample and open it |
| Strata SQL: Import from dbt… / Re-sync from dbt | dbt import |
| Strata SQL: Import from DDL… / Re-sync from SQL scripts | SQL import |
| Strata SQL: Split into Domains / Open Project View | Domains |
| Strata SQL: Open Live View in Browser | Live view |
| Strata SQL: Export Interactive HTML | HTML export |
| Strata SQL: Export ETL / ELT Code | Pipeline code |
