SQL editor preferences

In SQL editor preferences under account settings, you can customize how the SQL code editor behaves. For customizing keyboard shortcuts, see Keyboard shortcuts.

These settings are scoped to your account and shared across every workspace you belong to. Changes are saved immediately, and you can restore the defaults with Reset all.

Basic

Item	Description
Convert Tab to half-width space	When on, converts tab input into half-width spaces. The number of characters is 2 characters or 4 characters
Tab display size	The tab display width when Convert Tab to half-width space is off (2 characters or 4 characters)
Prefer lowercase for reserved words and functions	Uses lowercase as much as possible when applying formatters and autocomplete
Add alias to Table / SQL Block reference by default	Automatically adds an alias when you insert a reference
Disable AI code suggestion	Lets you disable AI code suggestions for yourself, even if AI Suggestion is enabled for the workspace
Disable Enter key for applying autocomplete	The Enter key inserts a line break instead of applying autocomplete

Input completion

Item	Description
Enable input completion	The overall on/off switch for autocomplete while writing SQL
Enable function completion	Autocomplete for functions like COUNT, SUM, and MAX
Enable reserved words and data types completion	Autocomplete for things like SELECT and LEFT JOIN
Enable code snippets completion	Autocomplete for code snippets. On by default
Enable columns completion	Suggests columns from tables referenced in the SQL block, and from other SQL blocks

Disabling input completion also disables the completion items under it.

Tooltip

Item	Description
Enable tooltip for function reference	Shows the function reference when the cursor is right after a function's ( or )