Tablestore allows you to download data to a local file by using the Tablestore 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.
Method | Supported data storage model | Format |
JSON | ||
CSV | ||
Use DataWorks to synchronize data to OSS and download the data from OSS |
|
Use the Tablestore CLI to download data
You can use the Tablestore CLI to export the table data to a local JSON file.
Download the Tablestore CLI. For more information, see Download the Tablestore CLI.
Start the Tablestore 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 the "Use a table" section of the Operations on data tables topic.
Run the scan command to export data. For more information, see the "Export data" section of the Operations on data topic.
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 from Tablestore to OSS and Synchronize incremental data to OSS.
Download data from OSS to a local file. For more information, see Simple download.