Load CSV's and other text data into kdb+

To load your data from a local csv/data file to a remote kdb+ server:

Menu option to Import CSV
  1. Goto Tools Menu -> Load Csv Data.
  2. Click browse and select your file in the file explorer.
  3. Configure the options.
  4. Check the preview pane looks correct and press Load.

Data is loaded into memory. The column types are automatically detected from the data. This includes strings vs syms, where the csv loader will decide on which depending on the amount of repetition. If you wanted to append this data to an existing hdb you would then need to do that step yourself.

Loading CSV Data onto a kdb+ Server.

See Also