The features mentioned in this article require a Data Governance license.
Data Governance fields are an extension to SqlDBM's Database Documentation feature. Fields are additional metadata columns that can be created and maintained by users with the Governance role to provide additional attributes (e.g., owner, is validated, source) to objects within the project.
Governance role
To create, edit, or modify fields, a user requires a Governance role to be assigned. Without the Governance role, users, including modelers, are given read-only access to fields and field values in the Database Documentation.
Governance fields
Fields can be found in the Database Documentation screen, where you will find the following features.
Accessing and adding fields
Access the Database Documentation and find the "Data Governance Fields" section in the right-hand properties panel. You can add existing fields to the screen by enabling them from this list or use the plus (+) icon to create new ones).
dbt-related fields
Using fields, users can maintain dbt source and model properties such as tests, freshness, and config, and output them as dbt-compatible YAML (see related articles at the end of this page for more information on how to generate dbt YAML in SqlDBM). There are two kinds of dbt fields that SqlDBM allows users to maintain:
Meta fields - users can include many kinds of metadata (e.g., owner, medallion status, department) under the dbt meta tag. To do so, mark the "Include as dbt meta" checkbox on any Data Governance field. When values are entered, corresponding tables or columns will be included in the meta field in the corresponding YAML.
Standard dbt properties (coming soon) - dbt source and model properties (e.g., tests, freshness, config) will be available as pre-configured fields in the database documentation and will be available to users on all Enterprise plans. Where applicable, these fields will include YAML snippets to allow users to easily set parameters without having to worry about syntax and formatting.
For the complete reference on dbt source and model properties, refer to their documentation:
While dbt meta-enabled fields require a Data Governance license, standard properties (e.g., tests, freshness, config) will be available to all Enterprise plans. Both dbt meta and standard fields will be found on the Database documentation screen.
Field types
Governance fields are available in various types for flexibility in how they are used. These include:
Text - free text entry for descriptive content
Dropdown - a selector with predefined values
Checkbox - for binary/Boolean input choices
Multiselect - a dropdown with multiple possible choices
Creating and editing fields
Users with the Governance role can maintain fields and field settings from the right-hand properties panel. Click the plus (+) icon to create a new field or hover on an existing field to edit or remove a field.
When creating or editing a field, the following properties are available
Name - as it will appear in the Database Documentation header
Include as dbt meta - enabling will include field values in generated dbt YAML
Type - a selector for the four field types mentioned previously
Default value - a pre-selected value for a given field (not applicable to multiselect fields)
Values - list of selectable values (applicable to dropdown and multiselect)
Checked by default - default setting applicable to checkbox fields
Add select-all to header - adds a checkbox to select/unselect all directly from the header (applicable to checkbox fields)
Assigning field values
Once fields have been added and selected for display (by checking the corresponding checkbox next to the field name from the properties panel), they can be edited and assigned by users with the Governance role.
Simply click or enter text directly from the UI as you would with other Database Documentation elements.
See also: