Workspaces allow you to export or copy data stored in a table in your workspace database 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. For example, you may choose to use an R library that prefers to operate on file-based data rather than data held in a database.
Exporting a data table to CSV
To export or copy dataset to a CSV file, open or select your dataset in the Datasets 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 dataset. The new file is written to the dataset_exports folder in the Blob storage.