Is there any efficient way to export data from remote DolphinDB server to local?

damie 0
Viewed 12

My DolphinDB GUI is connecting to a remote server and I want to export the data to local. The function saveText can only save the file to the remote machine where the server is located. I have to transfer the file using scp command. Is there any efficient way to export data to local?

dolphindb export save user-interface
1 Answers

In the menu bar of DolphinDB GUI, select Run, then click Export table

enter image description here

Fill in the Save Path and SQL statement.

enter image description here

For example,

Fill “D:/test.csv” in the Save Path:

For a DFS table, the SQL statement can be:

select * from loadTable("dfs://test",`pt)

For an in-memory table, you should share the table first.

share t as st

Then export the table with the following SQL statement

select * from st
dontyousee0
Related