Exporting a data table
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.
Exporting a data table to CSV
To export or copy a data table to a CSV file, open or select your data table in the Database tab, then click the 'Export to CSV' button in the sidebar.
A new dialogue will appear, giving you the following options to customise how the data is written to the new file:
- New CSV 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 'Export' 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.