Query Window

You can change the size of each part by dragging around.

The Query window is where you work your TONalytica 🪄 by inputting SQL code and running it. You can enable/disable the autocomplete function of the Query editor. The autocomplete feature will bring up PostgreSQL keywords, as well as tables and aliases you've already included in your Query.

To save yourself time while testing and debugging your Queries, you can run just a part of your Query. You'll need to highlight a syntactically complete and correct piece of SQL otherwise you'll get an error.

Shortcuts

Here are a handful of shortcuts to make crafting Queries a 💨

Shortcut	Action
ctrl + enter	execute the Query
ctrl + # or /	comments out the selected code
ctrl + space	brings up a list of keywords
crtl + z	undoes your last changes
ctrl + y	redoes your last changes
ctrl + f	search for keywords
ctrl + h	search and replace keywords