Restoring a Cloudera Data Visualization version in Cloudera AI

Restoring a previous version means reverting your Cloudera Data Visualization application to an earlier version. You can use this process to return your system to a known stable state if an upgrade introduces issues that significantly impact functionality, and you need to return to the previous Cloudera Data Visualization version to maintain system operations.

Cloudera Data Visualization encrypts sensitive configuration data, such as data connection passwords and API keys, using a secret key that is generated and stored at installation time. When restoring or migrating a Cloudera Data Visualization instance, the restored application must have access to the same secret key. Otherwise, existing encrypted settings cannot be decrypted and must be reconfigured.

To restore a previous version, ensure that the following prerequisites are met:

  • You have a backup of the Cloudera Data Visualization metadata database
    • SQLite (arcviz.db), or
    • An external database (MySQL, MariaDB, PostgreSQL, or Oracle)
  • You have access to the secret key used by the original Cloudera Data Visualization deployment. This includes backing up the .keys file that contains the secret key.
  1. Stop the application.
    On the Applications page in Cloudera AI, click Actions > Stop to stop the selected Cloudera Data Visualization application.
  2. Back up the SQLite metadata database.
    1. Navigate to your project's Overview page and click New Session.
    2. When the session is running, click >_ Terminal Access above the session log pane to open a terminal window.
      The default working directory is /home/cdsw, where all your project files reside.
    3. Navigate to /home/cdsw/.arc.
      This directory contains the Cloudera Data Visualization logs, files, settings, the arcviz.db metadata database, and the .keys file.
    4. Run the following command to create a copy of your current Cloudera Data Visualization metadata.
      sqlite3 arcviz.db “.backup arcviz.db-BACKUP-[***version***]
    5. Back up the secret key file.
      cp .keys .keys_backup

      You can use these backups when reverting to a previous Cloudera Data Visualization version.

  3. Create a new Cloudera Data Visualization application in your Cloudera AI project.
  4. Copy the backed-up SQLite database to /home/cdsw/.arc/ in the new project.
  5. Once the backup is restored, start the new Cloudera Data Visualization application.