Adding a new Database Catalog

This topic describes how to create a Database Catalog to use with a Virtual Warehouse in Cloudera Data Warehouse (CDW) service.

Database Catalogs are logical collections of metadata definitions for managed data with their associated data context. The data context is comprised of table and view definitions, security permissions, and governance artifacts that support functions such as auditing. This data context is derived from an environment that has been configured for Cloudera Data Platform (CDP) in the Management Console. When you create a new Database Catalog, you specify which environment to use.

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, and whether you want it populated with sample data.

    If you do not see the environment you want in the drop-down list, you might need to activate the environment. See "Activating environments" which is linked to in the "Related information" section at the bottom of this page.

  5. Click Create to create the new Database Catalog.