All Products
Search
Document Center

Tablestore:Download Tablestore data to a local file

Last Updated:Apr 02, 2025

You can use the Tablestore CLI or DataX to download Tablestore data to a local file. You can also use DataX to synchronize Tablestore data to Object Storage Service (OSS) and then download the data from OSS to a local file.

Download methods

Select an appropriate method to download Tablestore data based on your required file format. The following table describes the formats of exported files when you use different download methods.

Method

Supported data storage model

Exported file format

Use the Tablestore CLI to download Tablestore data

Wide Column model

JSON

Use DataX to download Tablestore data

  • CSV

  • TEXT

Use DataWorks to synchronize Tablestore data to OSS and download the data from OSS

  • CSV

  • TEXT

Use the Tablestore CLI to download Tablestore data

Use the Tablestore CLI to export table data to a local JSON file.

  1. Download the Tablestore CLI. For more information, see Download the Tablestore CLI.

  2. Start the Tablestore CLI and configure the access information. For more information, see Start the Tablestore CLI and configure access information.

  3. Use the source data table. For more information, see Use a table.

  4. Run the scan command to export data. For more information, see Export data.

Use DataX to download Tablestore data

You can use DataX 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 local a file.

  1. Synchronize full or incremental data in Tablestore to OSS in the DataWorks console. For more information, see Export full data from Tablestore to OSS and Synchronize incremental data to OSS.

  2. Download a file from OSS to your local computer. For more information, see Simple download.