Tablestore supports multiple methods to download data to a local file, including the Tablestore CLI, DataX, and DataWorks with Object Storage Service (OSS).
Download methods
Select a download method based on your required file format. The following table describes the supported methods and exported file formats.
|
Method |
Supported data storage model |
Exported file format |
|
JSON |
||
|
||
|
Use DataWorks to synchronize Tablestore data to OSS and download the data from OSS |
|
Use the Tablestore CLI to download Tablestore data
Use the Tablestore CLI to export 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 the access information. For more information, see Start the Tablestore CLI and configure access information.
-
Use the source data table. For more information, see Data table operations.
-
Run the scan command to export data. For more information, see Export data.
Use DataX to download Tablestore data
DataX allows you to download data from a data table or time series table in Tablestore to a local CSV file. For more information, see Download Tablestore data to a local CSV file by using DataX.
Use DataWorks to synchronize Tablestore data to OSS and download the data from OSS
Synchronize Tablestore data to OSS in the DataWorks console, and then download the data from OSS to a local file.
-
Synchronize full or incremental data in Tablestore to OSS in the DataWorks console. For more information, see Export full data to OSS and Synchronize incremental data to OSS.
-
Download a file from OSS to your local computer. For more information, see Simple download.