Rebuilding a Database Catalog

You can clean up resources and redeploy your Database Catalog while preserving the image version. Rebuild your Database Catalog to perform housekeeping or troubleshooting a problem.

Rebuilding the Database Catalog redeploys resources in the cluster while keeping the configurations and other settings you made using either the CDW UI or CDP CLI.

You can rebuild the Database Catalog in the following ways:
Limitations
  • Rebuilding deprecated versions of the Database Catalog is not supported and will fail.
  • Rebuilding does not preserve the changes you made directly, using kubectl for example, to cluster resources in the affected namespaces.
  • You must obtain the DWAdmin role.
  • You must be running the version 2022.0.6-b92 or later of the Database Catalog to rebuild it.
  • To preserve Hue documents, such as saved queries, you need to save a backup of the documents as described in Backing up and restoring Hue documents.
  1. Log in to the Data Warehouse service as DWAdmin.
  2. Go to the Database Catalogs tab.
  3. Locate the Database Catalog you want to rebuild and click > Rebuild.
    The Rebuild Database Catalog modal is displayed.
  4. Click Rebuild Database Catalog.
  5. Restore Hue documents as described Backing up and restoring Hue documents.
The Database Catalog is rebuilt with the same image version as it had before.
If you do not want to change JDBC/ODBC URLs, for example env-xdd4x6.dw, when rebuilding the Database Catalog, open a Support case to have the CDW_CUSTOM_CLUSTER_ID entitlement enabled.