Help Center/ Data Admin Service/ User Guide/ GeminiDB Cassandra/ Data Import and Export/ Exporting Data
Updated on 2024-09-05 GMT+08:00
View PDF
Share

Exporting Data

DAS allows you to export a large amount of data at a time to facilitate data query or to back up data for migration. This section describes how to export data.

DAS allows you to export an entire keyspace, some data tables, or result sets of CQL statements.

Precautions

If you do not select Generate a file for each table when exporting data, the exported data file is in .zip format. Data files in this format cannot be directly imported. You need to decompress the file before importing it again.

If Generate a file for each table is selected during data export, the exported data file is in .sql or .csv format. In this case, the exported data file can be directly imported again.

Prerequisites

You have created a user keyspace on the DAS console.

Exporting a Keyspace

  1. Log in to the DAS console.
  2. Click in the upper left corner and select a region and project.
  3. Click in the upper left corner, and under Databases, click Data Admin Service.
  4. In the navigation pane on the left, choose Development Tool.

    You can also click Go to Development Tool on the overview page.

  5. Locate the DB instance that you want to log in to and click Log In in the Operation column.
  6. On the top menu bar, choose Import and Export > Export.
  7. In the upper left corner of the page, click Create Task and choose Export Keyspace.

    Figure 1 Creating a task for exporting a keyspace

  8. In the displayed dialog box, configure basic information and advanced settings as required.

    Figure 2 Creating a task for exporting a keyspace
    • If you select Export all tables, data in an entire keyspace or in some tables will be exported.
    • DAS does not store any user data. The exported data files are stored in the OBS bucket that you have created.
    • Creating OBS buckets is free of charge, but saving files will incur certain costs.

  9. After settings are complete, click OK.
  10. In the task list, locate the created task and view the task ID, type, status, and progress.
  11. Click Details in the Operation column to view task details.

Exporting CQL Results

  1. Log in to the DAS console.
  2. Click in the upper left corner and select a region and project.
  3. Click in the upper left corner, and under Databases, click Data Admin Service.
  4. In the navigation pane on the left, choose Development Tool.

    You can also click Go to Development Tool on the overview page.

  5. Locate the DB instance that you want to log in to and click Log In in the Operation column.
  6. On the top menu bar, choose Import and Export > Export.
  7. In the upper left corner of the page, click Create Task and choose Export CQL Result.

    Figure 3 Creating a task for exporting a CQL result

  8. In the displayed dialog box, configure basic information and advanced settings as required.

    Figure 4 Creating an export task
    • DAS does not store any user data. The exported data files are stored in the OBS bucket that you have created.
    • Creating OBS buckets is free of charge, but saving files will incur certain costs.

  9. After settings are complete, click OK.
  10. In the task list, locate the created task and view the task ID, type, status, and progress.
  11. Click Details in the Operation column to view task details.

Download Data File

Data exported using the data export function is stored in the OBS bucket you created. You can download exported data files in any of the following ways:
  • Download on the DAS Console.
  • Download on the OBS management console.

Quick Export (Not Promoted)

  1. Log in to the DAS console.
  2. Click in the upper left corner and select a region and project.
  3. Click in the upper left corner, and under Databases, click Data Admin Service.
  4. In the navigation pane on the left, choose Development Tool.

    You can also click Go to Development Tool on the overview page.

  5. Locate the DB instance that you want to log in to and click Log In in the Operation column.
  6. On the top menu bar, choose Import and Export > Export.
  7. In the upper left corner of the page, click Quick Export and select the keyspace that you want to export data from.

    Figure 5 Quick export

    A maximum of 200,000 rows can be quickly exported from a single table. To export more data, choose Create Task > Export Database.

  8. On the Quick Export page, select a storage path and click OK.

    Figure 6 Quick export

  9. In the task list, view the export task you created.

    In the row that contains the export task, you can click Details in the Operation column to view execution details of the task and information about exported tables.

Parent topic: Data Import and Export