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.

Procedure

  1. Log on to the DBS console.
  2. In the left-side navigation pane, click Backup Schedules.
  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 button
  6. In the Query Backup Set message, click OK.
    Query Backup Set message
  7. Log on to the Data Lake Analytics (DLA) console. In the left-side navigation pane, choose Serverless SQL > Execute. After you click OK in Step 6, DLA creates a database based on the schema of the backup set 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.