Learn how to navigate and use the develop space to work with your Firebolt database.
;
).
Select your database and enginetab
key to add the first suggestion in the list to your script, or use arrow keys to select a different item from the list and then press the tab
key.
Results
tab displays the data returned from your SQL query. Each executed query populates this tab with a result table showing returned values for each column defined in your query.
Statistics tabStatistics
tab provides detailed statistics for each query you run. Information includes:
Query Profile
tab provides a visual query plan, illustrating how Firebolt executes your query. Each step is shown in a flowchart format, enabling you to inspect query operations and data flow visually.
Engine monitoring tabEngine Monitoring
tab provides real-time metrics on the resource utilization of your query execution engine, such as CPU and memory usage.
If the selected engine does not support engine monitoring (for example, the System engine), a message will indicate this, prompting you to select another engine for monitoring.
Query history tabQuery History
tab displays past queries along with their status and run details. This helps in reviewing historical queries for debugging or optimization purposes.
If the selected engine does not provide query history (such as the System engine), a message will indicate that you should select another engine to view the query history.
Exporting results to a local hard drive;
) or an error occurs.
Running a snippet of SQL as a statementCtrl + Shift + ?
) to quickly view available shortcuts directly within the Develop Space.Function | Windows & Linux Shortcut | Mac Shortcut |
---|---|---|
Run the currently selected query. | Ctrl + Enter | ⌘ + Enter |
Run all queries in the current script. | Ctrl + Shift + Enter | ⌘ + Shift + Enter |
Toggle expanding or collapsing query results. | Ctrl + Alt + E | ⌘ + Option + E |
Function | Windows & Linux Shortcut | Mac Shortcut |
---|---|---|
Create a new script. | Ctrl + Alt + N | ⌘ + Option + N |
Jump to a previous script. | Ctrl + Alt + [ | ⌘ + Option + [ |
Jump to the next script. | Ctrl + Alt + ] | ⌘ + Option + ] |
Close the current script. | Ctrl + Alt + X | ⌘ + Option + X |
Close all scripts. | Ctrl + Alt + G | ⌘ + Option + G |
Close all but the current script. | Ctrl + Alt + O | ⌘ + Option + O |
Function | Windows & Linux Shortcut | Mac Shortcut |
---|---|---|
Open a search panel. | Ctrl + F | ⌘ + F |
Find the next search result. | F3 | F3 |
Find the previous search result. | Shift + F3 | Shift + F3 |
Function | Windows & Linux Shortcut | Mac Shortcut |
---|---|---|
Toggle adding or removing a comment marker for the current line. | Ctrl + / | Cmd + / |
Toggle adding or removing a block comment marker around a block of code or text. | Shift + Alt + A | Shift + Option + A |
Automatically organize and indent code for readability. | Ctrl + Alt + F | ⌘ + Option + F |
Copy the selected lines and paste them directly above the original. | Alt + Shift + Up arrow | Shift + Option + Up arrow |
Move the selected lines and paste them directly above the original without creating a duplicate. | Alt + Up arrow | Option + Up arrow |
Copy the selected lines and paste them directly below the original. | Alt + Shift + Down arrow | Shift + Option + Down arrow |
Move the selected lines and paste them directly below the original without creating a duplicate. | Alt + Down arrow | Option + Down arrow |
Select text to the left of the cursor. | Alt + Shift + Left arrow | Ctrl + Shift + Left arrow |
Select text to the right of the cursor. | Alt + Shift + Right arrow | Ctrl + Shift + Right arrow |
Select the entire line. | Alt + L | Ctrl + L |
Decrease the indentation level of the current or selected lines. | Ctrl + [ | Cmd + [ |
Increase the indentation level of the current or selected lines. | Ctrl + ] | Cmd + ] |
Delete the current or selected lines. | Shift + Ctrl + K | Shift + Cmd + K |