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
-
Log in to the CDP web interface and navigate to the Data Warehouse service.
-
In the Data Warehouse service, click Database Catalogs in
the left navigation panel.
-
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.
-
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.
-
Click Create to create the new Database Catalog.