Attributes

Apply attribute values on schemas and their objects

Custom attributes on a schema let you record governance facts where the data lives: a steward on each table, a classification on each column, a review date on the schema itself. You assign groups to the schema once, then fill in values object by object.

In the app: Data Model › Schemas › your schema › Settings tab › Attribute Groups

Before you start

  • The attribute group and its attributes exist. See Create attribute groups.
  • Assigning groups to a schema needs Read/Write access to that schema.
  • Your organization must not be in read-only mode.

Assign a group to the schema

  1. Open the schema and go to its Settings tab.
  2. In Attribute Groups, click Add Group. The button is disabled when every group is already assigned.
  3. Pick the Attribute Group.
  4. Under Entity Types, tick the kinds of object the group applies to: Schema, Table, Column, View, Stored procedure, Function, or Script.
  5. Click Add.

The grid lists each assigned group with its attribute count and entity types. Use the pencil on a row to change its entity types, or the remove icon to unassign the group from this schema.

[screenshot]
The schema Settings tab's Attribute Groups grid, with one group assigned to Table and Column.

Tip: Keep entity types tight. A “Column Classification” group assigned only to Column keeps table and view forms short.

For more on this tab, see Schema settings.

Fill in values

  1. Open the object: the schema itself, or a table, column, view, stored procedure, function, or script.
  2. Go to its Attributes tab. On an object’s Info tab, the ATTRIBUTES card has a pencil that takes you there too.
  3. Each assigned group appears as its own section. Fill in the fields:
    • String: a text box.
    • Integer and Decimal: number boxes.
    • Boolean: a checkbox.
    • Date: a date picker.
    • Choice (Single Select): a dropdown, Select a value....
    • Multi-Choice (Multiple Select): a multi-select dropdown, Select values....
    • Reference: a cascading picker. See Reference attributes.
  4. Click Save.

Required fields are marked with *. If one is empty when you save, the form shows “Name is required” under it and nothing is saved. Fields with a default start filled in with it.

If the tab says “No attributes are configured for this entity type”, no assigned group covers this kind of object. Check the schema’s Settings tab.

[screenshot]
A column's Attributes tab with a Classification choice set to Confidential and a Steward Email filled in.

Read values

Each object’s Info tab shows an ATTRIBUTES card with the values that have been saved, grouped by attribute group. Empty fields are left out, and a card with no saved values says “No custom attributes configured”.

Change many objects

Kenseme sets attribute values one object at a time. There’s no bulk editor for schema objects.