Query Editor interface

Available in VPC

To access the Query Editor interface, navigate to i_menu > Services > Big Data & Analytics > Data Query in the VPC environment of the NAVER Cloud Platform console.

The Query Editor interface includes the following components:
dataquery-screen-vpc_screen_ko

Component	Description
① Menu name	Current menu name.
② Basic features	Query Editor features. [Add data source]: Add data sources. [Manage data source]: View the list of added data sources, and add or delete data sources. [Learn more]: Go to the Data Query overview page. [Refresh]: Reload the current page.
③ Data source component	The component where you can view data sources and queries available in the Data Query service [Data source] tab: You can see the added data sources in the dropdown menu and the tree list of databases and tables. Data sources: Select the data source in the dropdown menu to see its list. Search bar: Enter a search keyword to look it up in the database. : Hover to manage tables [Query] tab: View the lists of template queries and saved queries. [My query]: View the list of saved queries. [Template query]: View the list of template queries provided by the Data Query service. Search bar: Enter a search keyword to look up a query. : Hover to manage queries. : Drag to adjust the data component's size. : Add a table manually.
④ Query writing component	The component where you can write and execute queries Query tab: A query execution unit. You can write and execute a query on each tab. If only 1 tab is open, is not displayed. Click to add a new tab. Up to 30 tabs can be added. When 30 tabs are open, is not displayed. : Hover to save and manage queries. [Run]: Enabled when the query is written correctly, and runs a query when clicked. [Undo]: Enabled after clicking [Run] or [Simulate], and cancels the execution of the running query. [Simulate]: Enabled when the query is written correctly, and runs a simulated query when clicked. Database: Select the database for query execution from the dropdown menu. Reuse results: Select whether to use the previous results when executing queries and configure relevant settings (see Enable query result reuse). Input window: Window where you write queries for data analysis. : Drag to adjust the size of the query writing component. : Displayed when the query writing area is collapsed. Expands the query writing component.
⑤	Click to refresh the data of the tree list.
⑥	Click to change the result storage location or set the bucket life cycle.
⑦ Result component	The component that displays the results of the query execution (see View result).

The shortcuts supported by Query Editor are as follows:

Task	Windows or Linux shortcuts	macOS shortcuts
Run query	Ctrl+Enter	Cmd+Enter or Ctrl+Enter
Query formatting	Ctrl+Enter+L	Cmd+Opt+L
Previously executed query	Ctrl+UP	Ctrl+Shift+UP
Query to be executed next	Ctrl+Down	Ctrl+Shift+Down
Close current tab	Alt+X	Opt+X
Move to previous tab	Ctrl+,	Cmd+,
Move to next tab	Ctrl+.	Cmd+.
Indent	Tab	Tab
Outdent	Shift+Tab	Shift+Tab
Save	Ctrl+S	Cmd+S
Undo	Ctrl+Z	Cmd+Z
Redo	Ctrl+Shift+Z or Ctrl+Y	Cmd+Shift+Z or Cmd+Y
Annotate	Ctrl+/	Cmd+/
Change letters	Alt+shift+X	Ctrl+T
Lowercase	Ctrl+Shift+U	Ctrl+Shift+U
Capitalize	Ctrl+U	Ctrl+U
Overwrite	Insert	Insert
Delete	Delete	Delete or Fn+backspace
Delete line	Ctrl+D	Cmd+D
Copy the selected line and below	Alt+Shift+Down	Cmd+Opt+Down
Copy the selected line and above	Alt+Shift+Up	Cmd+Opt+Up
Move below the line	Alt+Down	Opt+Down
Move above the line	Alt+Up	Opt+Up
Remove until the end of the line	Alt+Delete	Ctrl+K
Remove at the beginning of the line	Alt+Backspace	Cmd+Backspace
Remove the word to the left	Ctrl+Backspace	Opt+Backspace or Ctrl+Opt+Backspace
Remove the word to the right	Ctrl+Delete	Opt+Fn+backspace
Split line	Not supported	Ctrl+O
Select all	Ctrl+A	Cmd+A
Select to the left	Shift+Left	Shift+Left
Select to the right	Shift+Right	Shift+Right
Select the word to the left	Ctrl+Shift+Left	Opt+Shift+Left
Select the word to the right	Ctrl+Shift+Right	Opt+Shift+Right
Select the beginning of the line	Shift+Home	Cmd+Left
Select the end of the line	Shift+End	Cmd+Right
Select until the beginning of the line	Alt+Shift+Left	Cmd+Shift+Left
Select until the end of the line	Alt+Shift+Right	Cmd+Shift+Right
Select until one line above	Shift+Up	Shift+Up
Select until one line below	Shift+Down	Shift+Down
Select the current page and above	Shift+PageUp	Shift+Fn+Up
Select the current page and below	Shift+PageDown	Shift+Fn+Down
Select until the beginning	Ctrl+Shift+Home	Cmd+Shift+Up
Select until the end	Ctrl+Shift+End	Cmd+Shift+Down
Duplicate selection	Ctrl+Shift+D	Cmd+Shift+D
Select the matching bracket	Ctrl+Shift+P	Not supported
Add multiple cursors above	Ctrl+Alt+Up	Ctrl+Opt+Up
Add multiple cursors below	Ctrl+Alt+Down	Ctrl+Opt+Down
Multi-select the occurrences of the selected word that follow it	Ctrl+Alt+Right	Ctrl+Opt+Right
Multi-select the occurrences of the selected word that precede it	Ctrl+Alt+Left	Ctrl+Opt+Left
Move left	Left	Left or Ctrl+B
Move right	Right	Right or Ctrl+F
Move one word to the left	Ctrl+Left	Opt+Left
Move one word to the right	Ctrl+Right	Opt+Right
Move one line up	Up	Up or Ctrl+P
Move one line down	Down	Down or Ctrl+N
Move to the beginning of the line	Alt+Left or Home	Cmd+Left or Fn+Left or Ctrl+A
Move to the end of the line	Alt+Right or End	Cmd+Right or Fn+Right or Ctrl+E
Previous page	PageUp	Opt+Fn+Up
Next page	PageDown	Opt+Fn+Down or Ctrl+V
Move to the beginning	Ctrl+Home	Cmd+Up or Cmd+Home
Find	Ctrl+F	Cmd+F
Replace	Ctrl+H	Cmd+Opt+F
Find next	Ctrl+K	Cmd+G
Find previous	Ctrl+Shift+K	Cmd+Shift+G
Fold selected component	Alt+L or Ctrl+F1	Cmd+F1
Expand selected component	Alt+Shift+L or Ctrl+Shift+F1	Cmd+Shift+F1
Expand all	Alt+Shift+0(Number)	Cmd+Opt+Shift+0(Number)
Focus out	Esc	Esc

Caution

Running DML or DDL queries can delete or modify actual data in connected data sources (e.g., Object Storage or RDB).