Pre-General Availability: 2024-10-04
When you execute SQL queries from a notebook or script editor, the resulting records are shown in the output area. The notebook editor's output area is part of the code block where the query was issued. The script editor opens a separate output area below the script. In both cases, tabs are used to separate the result sets if more than one is generated.
To expand or reduce the output area, use your pointer device to hover over the separation zone above or below a code block (notebook editor) or the zone between the script and output area. The separation zone displays a thick line when it becomes active.
When a query generates and shows records in the output area, with or without tabs, the editor also includes a result toolbar for quick actions. If tabs are present, the actions apply to the result set within the tab.
Result tools from left to right:
Query result status, such as
OK
or an error message, and the number of records retrieved by page (1000 records on each page).Previous page and next page (active for large result sets only)
Maximize result set view
Result-set format (tabular by default)
Show Action Menu: Export result set, Import result set
Several copy actions are available at the field, row, and rows level. After your query result set is shown in the output area, you can right-click the data to copy the output using one or more of the copy actions.
For example, the following query of the
world database
sample returns several rows. If you right-click the
NLD
value in the
CountryCode column, you can select various
copy actions based on the selected field.
SELECT * FROM countrylanguage where Language like 'Dutch'
Copy actions are:
-
'NLD', 'Dutch', 'T', '95.6'
-
# CountryCode, Language, IsOfficial, Percentage
'NLD', 'Dutch', 'T', '95.6' -
NLD, Dutch, T, 95.6
-
# CountryCode, Language, IsOfficial, Percentage
NLD, Dutch, T, 95.6 -
# CountryCode, Language, IsOfficial, Percentage
'NLD', 'Dutch', 'T', '95.6' -
'NLD',
'Dutch',
'T',
'95.6'
-
'NLD'
-
NLD