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. You can also assign or reassign data products to a domain while editing a domain. The Delete domain link becomes available in the Edit pane when all data products have been reassigned to other domains.

Note

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

Edit domain pane

  1. Click the Edit domain option in the context menu, or the pencil icon in the domains table for the domain you want to edit. The Edit pane 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 reassign a data product to a domain either in its edit workflow, or by editing the domain. The Edit pane for a domain contains a list of all currently assigned data products. The Data products assigned to this domain column in the domain management table also lists all data products assigned to a domain.

You can reassign a data product to a different domain by clicking its Reassign link in the Edit pane and selecting another domain.

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

  1. Click Edit domain from the context menu.

  2. Click Reassign all.

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

  4. Click Reassign domain.

Delete a domain#

Note

If your organization uses SEP’s built-in access control, 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, a Delete domain link appears in the domain’s Edit pane, and the Delete domain option is also available directly in the context menu.

  1. Click Delete domain to delete the domain.

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