Domain management#

The Domain management page allows you to create, edit, and delete data domains that define your business. You can assign and reassign data products to domains. To access the Domain management page, click the Domain management option in the navigation menu.

You can sort the Domain name or the # of 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.

Domain management of data products page

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. 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.

Edit domain dialog

  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. 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 Reassign 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 Reassign link in the Reassign 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 Reassign data products.

  2. Click Reassign all.

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

  4. Click Reassign data products.

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 domain.

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