Enhance efficiency by utilizing keyboard faster ways in Amazon Athena question editor

Amazon Athena is a serverless, interactive analytics service constructed on open-source structures, supporting open-table and file formats. Athena supplies a streamlined, versatile method to examine petabytes of information where it lives. You can examine information or develop applications from an Amazon Simple Storage Service (Amazon S3) information lake and over 25 information sources, consisting of on-premises information sources or other cloud systems utilizing SQL or Python. Athena is constructed on open-source Trino and Presto engines and Apache Glow structures, without any provisioning or setup effort needed.

Various kinds of users count on Athena, consisting of service experts, information researchers, security, and operations engineers. Athena supplies a question editor to go into and run questions on information utilizing structured question language (SQL). The question editor supplies functions like run, cancel, and conserve questions or declarations. In addition, it supplies keyboard faster ways for easy to use operation.

This post goes over the keyboard shortcuts readily available and how you can utilize them.

Accessing the Athena console

If you’re brand-new to Athena and do not understand how to access the Athena console and run questions and declarations, describe the following getting going tutorial This guide strolls you through utilizing Athena to query information. You’ll develop a table based upon sample information saved in Amazon S3, query the table, and inspect the outcomes of the question.

Keyboard faster ways

The question editor supplies keyboard faster ways for various action types like running a question, formatting a question, line operations, choice, multi-cursor, go to, find/replace, and folding. Compared to grabbing the mouse or browsing a menu, a single keyboard faster way conserves a minute of your time.

With keyboard faster ways, you can utilize crucial mixes to modify your SQL declaration without utilizing a mouse. For instance, you can utilize several cursors in your modifying window for choosing all circumstances of text you want to modify, and modify your text, fold or unfold chosen text, discover and change text, and carry out line operations like eliminate line, relocation lines, and more.

You can likewise discover these keyboard shortcuts on the question editor on the bottom best corner, as highlighted in the following screenshot.

The following table reveals the keyboards faster ways for Window/Linux and Mac.

Action Type Action Windows/Linux Mac
Other Perform question Ctrl-Enter Cmd-Enter, Ctrl-Enter
Other Format question Ctrl-Alt-L Opt-Cmd-L
Other Previous question Ctrl-Up Ctrl-Shift-Up
Other Next question Ctrl-Down Ctrl-Shift-Down
Other Close tab Alt-X Opt-X
Other Previous tab Ctrl-, Ctrl-,
Other Next tab Ctrl-. Ctrl-.
Other Indent Tab Tab
Other Outdent Shift-Tab Shift-Tab
Other Conserve Ctrl-S Cmd-S
Other Reverse Ctrl-Z Cmd-Z
Other Redo Ctrl-Shift-Z, Ctrl-Y Cmd-Shift-Z, Cmd-Y
Other Toggle remark Ctrl-/ Cmd-/
Other Transpose letters Ctrl-T Ctrl-T
Other Modification to decrease case Ctrl-Shift-U Ctrl-Shift-U
Other Modification to upper case Ctrl-U Ctrl-U
Other Overwrite Insert Insert
Other Erase Erase
Line Operations Eliminate line Ctrl-D Cmd-D
Line Operations Copy lines down Alt-Shift-Down Cmd-Opt-Down
Line Operations Copy lines up Alt-Shift-Up Cmd-Opt-Up
Line Operations Move lines down Alt-Down Opt-Down
Line Operations Move lines up Alt-Up Opt-Up
Line Operations Eliminate to line end Alt-Delete Ctrl-K
Line Operations Eliminate to line start Alt-Backspace Cmd-Backspace
Line Operations Eliminate word left Ctrl-Backspace Opt-Backspace, Ctrl-Opt-Backspace
Line Operations Eliminate word right Ctrl-Delete Opt-Delete
Line Operations Split line Ctrl-O
Choice Select all Ctrl-A Cmd-A
Choice Select left Shift-Left Shift-Left
Choice Select right Shift-Right Shift-Right
Choice Select word left Ctrl-Shift-Left Opt-Shift-Left
Choice Select word right Ctrl-Shift-Right Opt-Shift-Right
Choice Select line start Shift-Home Shift-Home
Choice Select line end Shift-End Shift-End
Choice Select to line end Alt-Shift-Right Cmd-Shift-Right
Choice Select to line start Alt-Shift-Left Cmd-Shift-Left
Choice Select up Shift-Up Shift-Up
Choice Select down Shift-Down Shift-Down
Choice Select page up Shift-PageUp Shift-PageUp
Choice Select page down Shift-PageDown Shift-PageDown
Choice Select to begin Ctrl-Shift-Home Cmd-Shift-Up
Choice Select to end Ctrl-Shift-End Cmd-Shift-Down
Choice Replicate choice Ctrl-Shift-D Cmd-Shift-D
Choice Select to matching bracket Ctrl-Shift-P
Multicursor Include multi-cursor above Ctrl-Alt-Up Ctrl-Opt-Up
Multicursor Include multi-cursor listed below Ctrl-Alt-Down Ctrl-Opt-Down
Multicursor Include next event to multi-selection Ctrl-Alt-Right Ctrl-Opt-Right
Multicursor Include previous event to multi-selection Ctrl-Alt-Left Ctrl-Opt-Left
Multicursor Move multi-cursor from present line to the line above Ctrl-Alt-Shift-Up Ctrl-Opt-Shift-Up
Multicursor Move multi-cursor from present line to the line listed below Ctrl-Alt-Shift-Down Ctrl-Opt-Shift-Down
Multicursor Eliminate present event from multi-selection and transfer to next Ctrl-Alt-Shift-Right Ctrl-Opt-Shift-Right
Multicursor Eliminate present event from multi-selection and transfer to previous Ctrl-Alt-Shift-Left Ctrl-Opt-Shift-Left
Multicursor Select all from multi-selection Ctrl-Shift-L Ctrl-Shift-L
Go to Go to left Left Left, Ctrl-B
Go to Go to best Right Right, Ctrl-F
Go to Go to word left Ctrl-Left Opt-Left
Go to Go to word right Ctrl-Right Opt-Right
Go to Go line up Up Up, Ctrl-P
Go to Go line down Down Down, Ctrl-N
Go to Go to line start Alt-Left, House Cmd-Left, House, Ctrl-A
Go to Go to line end Alt-Right, End Cmd-Right, End, Ctrl-E
Go to Go to page up PageUp Opt-PageUp
Go to Go to page down PageDown Opt-PageDown, Ctrl-V
Go to Go to begin Ctrl-Home Cmd-Home, Cmd-Up
Go to Go to end Ctrl-End Cmd-End, Cmd-Down
Go to Scroll line down Ctrl-Down Cmd-Down
Go to Scroll line up Ctrl-Up
Go to Go to matching bracket Ctrl-P
Go to Scroll page down Opt-PageDown
Go to Scroll page up Opt-PageUp
Find/Replace Discover Ctrl-F Cmd-F
Find/Replace Replace Ctrl-H Cmd-Opt-F
Find/Replace Discover next Ctrl-K Cmd-G
Find/Replace Discover previous Ctrl-Shift-K Cmd-Shift-G
Folding Fold choice Alt-L, Ctrl-F1 Cmd-Opt-L, Cmd-F1
Folding Unfold Alt-Shift-L, Ctrl-Shift-F1 Cmd-Opt-Shift-L, Cmd-Shift-F1
Folding Unfold all Alt-Shift-0 Cmd-Opt-Shift-0
Other Autocomplete Ctrl-Space Ctrl-Space
Other Focus out Esc Esc

For illustration, you can carry out the Format question action by utilizing the keyboard faster way ( Ctrl-Alt-L for Windows/Linux, Opt-Cmd-L for Mac). It transforms unformatted SQL to a well-formatted SQL, as displayed in the following screenshots.

Likewise, you can try the Toggle remark command ( Ctrl-/ for Windows/Linux, Cmd-/ for Mac) to comment or uncomment lines of SQL in the Athena question editor. This can be found in really helpful when you wish to rapidly comment out particular lines in your question, as displayed in the following screenshots.

You can do line operations like Eliminate line, Copy lines down, Copy lines up, and more. The following screenshots reveal an example of the Eliminate line action ( Ctrl-D for Windows/Linux, Cmd-D for Mac).

You can do a line choice like Select all, Select left, Select line start, and more. The following screenshots reveal an example the Select all action ( Ctrl-A for Windows/Linux, Cmd-A for Mac).

You can do multi-cursor actions like Include multi-cursor above, Include multi-cursor listed below, Include next event to multi-selection, Include previous event to multi-selection, Move multi-cursor from present line to the line above, and more. The copying is of the Include multi-cursor above action ( Ctrl-Alt-Up for Windows/Linux, Ctrl-Opt-Up for Mac).

You can do go to actions like Go to left, Go to best, Go to word left, and more. The following is an example of the Go to left action ( Ctrl-B).

You can do discover and change actions like Discover, Change, Discover next, and more. The following is an example of the Change action ( Ctrl-H for Windows/Linux, Cmd-Opt-F for Mac).

You can likewise do folding actions like Fold choice, Unfold, and Unfold all The copying is of the Unfold action ( Alt-Shift-L or Ctrl-Shift-F1 for Windows/Linux, Cmd-Opt-Shift-L or Cmd-Shift-F1 for Mac).


In this post, we saw how Athena supplies a range of native choices to assist you enhance efficiency when examining your information. You can go to the Athena console and begin running SQL declarations or querying information utilizing the integrated question editor. The question editor supplies crucial faster ways to enhance your efficiency by utilizing crucial mixes to modify SQL declarations, rather of utilizing a mouse.

If you have any concerns or recommendations, please leave a remark.

About the Authors

Naresh Gautam is an Information Analytics and AI/ML leader at AWS with twenty years of experience, who takes pleasure in assisting clients designer extremely readily available, high-performance, and economical information analytics and AI/ML options to empower clients with data-driven decision-making. In his downtime, he takes pleasure in meditation and cooking.

Srikanth Sopirala is a Principal Analytics Expert Solutions Designer at AWS. He is a skilled leader with over twenty years of experience, who is enthusiastic about assisting clients develop scalable information and analytics options to acquire prompt insights and make crucial service choices. In his extra time, he takes pleasure in reading, spending quality time with his household, and roadway cycling.

Extreme Vardhan is an AWS Solutions Designer, concentrating on analytics. He has more than 5 years of experience working in the field of huge information and information science. He is enthusiastic about assisting clients embrace finest practices and find insights from their information.

Like this post? Please share to your friends:
Leave a Reply

;-) :| :x :twisted: :smile: :shock: :sad: :roll: :razz: :oops: :o :mrgreen: :lol: :idea: :grin: :evil: :cry: :cool: :arrow: :???: :?: :!: