This topic describes how to query data in a single backup set that is generated by Database Backup (DBS).

Prerequisites

A database of the MySQL, SQL Server, Oracle, PostgreSQL, or Postgres Plus Advanced Server (PPAS) type is used.

Billing

DBS can call the Data Lake Analytics (DLA) API to query data in backup sets. You are not charged for using DBS to query data in backup sets. However, DLA charges you based on the volume of scanned data. For more information, see Billing methods.

Procedure

  1. Log on to the DBS console.
  2. In the left-side navigation pane, click Backup Schedules. On the Backup Schedules page, select a region in the upper-left corner.
    Select a region
  3. On the Backup Schedules page, find the backup schedule where the backup set that you want to query is generated. Then, click Manage in the Actions column.
  4. In the left-side navigation pane, choose Backup Tasks > Full Data.
  5. On the page that appears, find the backup set that you want to query and click Query Backup Set in the Actions column.
    Query Backup Set
  6. In the Query Backup Set dialog box, click OK.
    Query Backup Set message
  7. Log on to the DLA console. In the left-side navigation pane, choose Serverless SQL > Execute. DLA creates a database based on the schema of the selected backup sets and displays the database in the navigation tree of the Execute page. Double-click the database name, enter an SQL statement in the code editor, and then click Sync Execute.
    Note The SQL syntax of DLA is based on Presto. For more information, click Syntax Manuals in the upper-right corner of the Execute page or see Common SQL statements.