Saving a data table in CSV format

Workspaces allow you to export or copy data tables to a file on the file system. This is especially useful if you are using a data analysis tool that requires data inputs as files rather than a connection to a database.

Saving a data table as a CSV

To save a data table data in CSV format, open or select your data table in the Database tab, then use the the 'Save as CSV' button in the header or menu.

A new dialogue will appear, giving you the following options to customise how the data is written to the new file:

• Name: the name of the file that the data is written to – the extension for this new file must be .csv.
• Delimiter: the character to use as the delimiter in the new file.
• The number of rows: the number of rows to write to the file.
• Include header row: controls whether the column headers are written to the first row of the new file.

Click the 'Save as CSV' button to start exporting or copying the data table. The new file is written to the dataset_exports folder in the Blob storage.

If you want to download the data table to your local machine, use the workspace Airlock.