Home > Software design >  Is there any efficient way to export data from remote DolphinDB server to local?
Is there any efficient way to export data from remote DolphinDB server to local?

Time:09-28

My DolphinDB GUI is connecting to a remote server and I want to export the data to my local computer. 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 the data to local?

CodePudding user response:

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
  • Related