Auto-complete suggestion and syntax error checking is now available in Amazon Redshift Query Editor V2. This feature empowers you to build queries more efficiently and accurately, as you can quickly access and utilize relevant database object names without the need to remember each detail by providing SQL syntax or database object name suggestions, either within an editor tab or a notebook. The suggestions are sorted by relevance and indicate availability, as well as help with spelling difficult database object names.
Source:: Amazon AWS