Domain management

Access the Domains pane in the data product dashboard.

To view a full list of domains, click View all.

This pane allows you to create, edit, and delete data domains that define your business. You can assign and reassign data products to domains.

You can sort the Domain name, Connection, and Total data products columns in ascending or descending order by clicking the sort arrows for the column headers. Sorted domain names are presented in a table view in alphabetical order based on case-sensitivity. The total number of domains is also displayed.

Create a domain

Create a domain to which you can assign data products.

Note

If built-in access control is enabled, you can only create a domain if you have been granted create privileges.

1. Click Create new domain.

2. Enter a Domain name.

3. (Optional) Enter a Domain description.

4. (Recommended) Enter a Schema location URI. Define the object storage location URI for the schema created as the domain. Set this property to ensure that each domain uses a unique and separate schema. Each data product in a domain is then created as a nested schema inside the domain schema. By default, this value is not set and all domains share the default location from the catalog. Views, materialized views, and storage tables for the materialized views are created in the specific schema for the data product, and can be accessed in that schema.

5. Optionally, select the Is shared domain checkbox.

   Note

   You must create a shared domain in order to share data products between clusters.

6. Click Create domain.

Edit a domain

Edit domain information such as its description or schema location URI.

Note

If your organization uses access control such as SEP’s built-in access control or Apache Ranger, you can only edit a domain if you have been granted Alter privileges.

1. Click the Edit icon in the domain management table for the domain that you want to edit. The Edit domain dialog appears.

2. Add or change the description in the Domain description field.

3. Add or change the Schema location URI.

   Warning

   It is possible to change the value in the Schema location URI field of an existing domain. However, schemas for existing data products remain in the previously defined location. Only new data products appear in the updated location.

4. Optionally, select the Is shared domain checkbox.

   Note

   You must create a shared domain in order to share data products between clusters.

5. Click Save changes.

Assign and reassign data products to a domain

All data products must be assigned to a domain. You can view all data products assigned to a domain, or reassign a data product, from the Move data products dialog. This dialog is accessible from the Options menu. The Data products assigned to this domain column in the domain management table also lists all data products assigned to a domain.

To reassign a data product to a different domain, click its Move link in the Move data products dialog and select another domain.

To reassign all data products from the current domain to a different domain:

1. From the Options menu, click Move data products.

2. Click Move all.

3. Select a new domain to apply to all currently assigned data products.

4. Click Move.

Delete a domain

Note

If your organization uses access control such as SEP’s built-in access control or Apache Ranger, you can only delete a domain if you have been granted Drop privileges.

Before you can delete a domain, you must first reassign all of its data products to a different domain.

When no data products are assigned to a domain, the Delete domain option is available in the options menu.

1. From the options menu, click Delete.

2. Type DELETE to confirm and click Yes, delete.