Step 5: Use keyboard shortcuts and typeahead suggestions - Amazon Athena
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Step 5: Use keyboard shortcuts and typeahead suggestions

The Athena query editor provides numerous keyboard shortcuts for actions like running a query, formatting a query, line operations, and find and replace. For more information and a complete list of shortcuts, see Improve productivity by using keyboard shortcuts in Amazon Athena query editor in the Amazon Big Data Blog.

The Athena query editor supports typeahead code suggestions for a faster query authoring experience. To help you write SQL queries with enhanced accuracy and increased efficiency, it offers the following features:

  • As you type, suggestions appear in real time for keywords, local variables, snippets, and catalog items.

  • When you type a database name or table name followed by a dot, the editor conveniently displays a list of tables or columns to choose from.

  • When you hover over a snippet suggestion, a synopsis shows a brief overview of the snippet's syntax and usage.

  • To improve code readability, keywords and their highlighting rules have also been updated to align with latest syntax of Trino and Hive.

This feature is enabled by default. To enable or disable the feature, use the Code editor preferences (gear icon) at the bottom right of the query editor window.