Export Data
Saves the results of running SELECT SQL statements in various forms and options.
Caution
For concurrency efficiency, run the SQL again in a separate session from the editor session to fetch all the data before exporting it. Note that the actual data exported may vary depending on the state of transaction management.
Click the 
icon at the bottom of the result to display a modal window where the users can set the export options. In the Export Modal window, proceed with the export operation by setting the information in two steps.
1. Export Setting
Connection
It shows the information of the editor session that ran SQL. Note that when the actual export operation is performed, the SQL is executed again and the information is the same as the editor session, but the export is performed in a different session.
Format
Set the type of result to be exported. Currently, CSV TXT SQL TABLE is supported.
File Name
Set the name of the file to save.
Directory
Set the directory to save the file.
2. Export Details
Set the details of the file. The detail options are different for each format The users set in step 1, so this section explains the detail options for each format type.
CSV
Batch Size
Sets the number of rows of data to write to the file per unit of work. This allows The users to control memory usage when exporting large amounts of data. It is important to set an appropriate Batch Size because large values can increase the speed but can significantly increase memory usage.
Maximum Column Length
Set the maximum length of the values. If set to 0, the data will be output in full with no maximum length.
Show Nulls
This option specifies whether to display NULL values. If checked, NULL values are displayed as the string 'NULL', and if unchecked, they are displayed as empty values.
Include Row Number(#)
This option specifies whether to include row numbers.
Include Column Header
This option specifies whether to include column headers.
Delimiter
Sets the delimiter of the values.
Click the 
button to set whether to export the column.
TXT
Batch Size
Sets the number of rows of data to write to the file per unit of work. This allows The users to control memory usage when exporting large amounts of data. It is important to set the appropriate Batch Size because large values can increase the speed but can significantly increase memory usage.
Maximum Column Length
Set the maximum length of the values. If set to 0, the data will be output in full with no maximum length.
Show Nulls
This option specifies whether to display NULL values. If checked, NULL values are displayed as the string 'NULL', and if unchecked, they are displayed as empty values.
Include Row Number(#)
This option specifies whether to include row numbers.
Include Column Header
This option specifies whether to include column headers.
Delimiter
Sets the delimiter of the values.
Add a delimiter at the START of the row
Inserts a delimiter at the beginning of the row.
Add a delimiter at the END of the row
Inserts a delimiter at the end of the row.
In-between delimiter
Sets whether delimiter is enabled or disabled.
SQL
Generates an INSERT syntax based on the data in the object and saves it as a .sql file.
Table
Moves the data contents of the current object to another object.
Target Container
Sets the target schema.
Create new table
When creating a table, excludes all constraints and configures only column names, data values, and data types in the resulting grid.
Mapping an existing table
Set an existing object as the Target.
Check export task status
The users can check the status of an export task by clicking the 
button on the top right of the application. Click the list to open the corresponding file.
Last updated