Configure Metadata Propagation Rules

This functionality allows an Admin or Power User to propagate metadata changes to Elements in Metric Insights.  There are two propagation methods supported:

  1. Metadata associated with a table or table/column combination are propagated to all Elements that utilize that table in their lineage.  
  2. Metadata associated with an Element Name (Report Name) or External Report Reference (Report ID) (e.g. Tableau URL for the Workbook) are propagated to all Elements that match the name or use the reference ID.
    • NOTE: When matching on the name, it is the name of the object in the BI tool (e.g. Workbook Name in Tableau), and NOT the name of the External Report in Metric Insights.

Metadata can be propagated automatically based on a Dataset, whenever the Dataset is updated, or they can be propagated based on manual settings in the Editor; however, this is only applicable to mappings to table or table/column combination.

For the purpose of this article, mapping is based on a table from a Dataset.

PREREQUISITES:

  • Power Users must be granted the MANAGE_METADATA_PROPAGATION_RULES Privilege.

1. Create Dataset for Mapping

Access +New > Dataset > CSV Dataset

Refer to Create a Dataset from CSV File for more guidance on CSV Datasets.

Create a Dataset with the following columns:

  • Table: name of the table that is used as a source for Elements;
  • Certified: valid values are "Yes" or "No";
  • Certification Level: value must exactly match the name of an established certification level;
  • Certified by: value must match username for existing user;
  • Certified Date: value must be a valid date in format YYYY-MM-DD;
  • Custom Field: value must match an existing custom field value for selected Custom Field.
    • If you want to apply multiple Custom Fields, list them using comma in the CSV file in the Custom Field column.
  • Glossary Term: Glossary Term exactly matching value provided must already exist for the section;
    • If you want to apply multiple Glossary Terms from one section, list them using comma in the CSV file in the Glossary Term column to the CSV file.
    • If you want to apply multiple Glossary Terms form different sections, add multiple Glossary Section columns with their Terms.
  • Tag: new Tag is created if value does not match existing Tags.

NOTE: Name and Description are in the Dataset but won't be used in this configuration because changes to these Fields can be applied only if Map Source -> Target Based On is set to "Reports found in Dataset that map to Elements.

2. Create New Metadata Propagation Rule

Access Admin > Utilities > Metadata Propagation > [+Propagation Rule]

  1. Provide a descriptive Name for the Rule
  2. Define how Source is to be mapped the target system
  3. Choose Metadata Source
  4. Choose Dataset & View you created for mapping
  5. Specify the name of the table associated with the target Elements
  1. [+Add]
  2. Map Dataset column names to the corresponding Metadata properties

3. Save and Run the Rule

  1. [Save]
  2. [Preview Changes] to avoid unwanted changes
  3. [Propagate Changes Now] to apply changes immediately or wait until the Dataset update

4. Verify Result

Access Run History Tab

Here you can review the applied changes and errors.