Adding a new Database Catalog

In addition to the default Database Catalog, created automatically, you can add additional Database Catalogs if you want a standalone data warehouse without any data related to the default Database Catalog.

When you activate an environment from the Data Warehouse, a default Database Catalog is created and named after your environment. This HMS instance associated with the default Database Catalog is the same HMS as the one used by your CDP environment. You can add additional Database Catalogs if you want standalone data warehouses based on a new HMS instance. When you create a new Database Catalog, you specify which environment to use. If you make a change in the default database catalog, then the changes are reflected in the environment where the default Database Catalog resides. However, if you make any change to the non-default database catalogs, then those changes are not reflected in that environment.

You can optionally load demo data in Hue when you create a non-default Database Catalog.

Required role: DWAdmin

  1. Log in to the CDP web interface and navigate to the Data Warehouse service.
  2. In the Data Warehouse service, click Database Catalogs in the left navigation panel.
  3. On the Database Catalogs page, click Add New.
    You can also add a new Database Catalog by clicking the plus sign on the Overview page of the Data Warehouse service.
  4. In the New Database Catalog dialog box, specify a Database Catalog name, which environment it uses, a pre-created custom database name for Hive Metastore (HMS), Data Analytics Studio (DAS), and Hue (if using an external database), and whether you want tables populated with sample data.

    This is the image of the New Database Catalog dialog box containing the following fields: Name, Environments, Pre-created database names, and a Load Demo Data toggle button.

    If you do not see the environment you want in the drop-down list, you might need to activate the environment.

  5. Click CREATE to create the new Database Catalog.