Tablestore allows you to download data to a local file by using the CLI or DataX. You can also use DataWorks to synchronize data from Tablestore to Object Storage Service (OSS), and then download the data from OSS to a local file.
Download methods
You can select a method to download Tablestore data to a local file based on the format in which you want to download the data. The following table describes the download methods.
| Format | Method |
|---|---|
| JSON | Use the CLI to download data |
| CSV | |
| TEXT | Use DataWorks to synchronize data to OSS and download the data from OSS |
Use the CLI to download data
You can use the CLI to export data in tables to a local JSON file.
- Download the CLI. For more information, see Download the Tablestore CLI.
- Start the CLI and configure access information. For more information, see Start the Tablestore CLI and configure access information.
- Use the table from which you want to export data. For more information, see Use a data table.
- Run the scan command to export data. For more information, see Export data.
Use DataX to download data
You can use DataX to export data to a local CSV file. For more information, see Getting started with DataX.
Use DataWorks to synchronize data to OSS and download the data from OSS
You can synchronize data from Tablestore to OSS in the DataWorks console and download the data from OSS to a local file.
- You can use DataWorks to synchronize full or incremental data from Tablestore to OSS. For more information, see Export full data in script mode and Synchronize incremental data in script mode.
- Download data from OSS to a local file. For more information, see Simple download.