Cloudera Docs

Enabling the option to create additional Database Catalogs in CDW Private Cloud

Starting with the Private Cloud 1.5.0 release, you cannot create additional non-default Database Catalogs without enabling the “Create multiple Database Catalogs” option on the Advanced Settings page.

In Cloudera Data Warehouse (CDW) Private Cloud, a default Database Catalog is created when you activate an environment and is specific to that environment. The default Database Catalog uses a CDW-managed database. If you create additional Database Catalogs, then non-default Database Catalogs are created which require a separate, external database that CDW does not manage.

Cloudera encourages you to use the default Database Catalogs because the ability to create and use non-default Database Catalogs will be removed in future releases. To enable creating non-default Database Catalogs:

  1. Log in to the Data Warehouse service as DWAdmin.
  2. Go to the Advanced Configuration > Advanced Settings page.
  3. Select the Create multiple Database Catalogs option.
  4. Click Update.