0 / 0
Reporting tables

Reporting tables

Reporting data for IBM Knowledge Catalog is stored in SQL tables in PostgreSQL, Db2, or Microsoft SQL Server database. You can use the descriptions of the tables to better understand the reporting data and to generate more meaningful reports.

Each table description contains the list of table columns with short descriptions and the CREATE TABLE SQL statement. In some cases, ALTER TABLE and CREATE INDEX statements are provided.

Each of these tables has a history table that is associated with it. The name of a history table starts with the prefix hist_, followed by the table name.

In PostgreSQL SQL tables, use the f_trig_<table_name> function to populate the tables with appropriate data. The function is defined in the following way:

CREATE OR REPLACE
FUNCTION f_trig_<table_name>() RETURNS TRIGGER AS $$
DECLARE
BEGIN
	IF
			(TG_OP = 'DELETE') THEN OLD.tech_end = CURRENT_TIMESTAMP;

INSERT
	INTO
	hist_<table_name>
VALUES (OLD.*);

RETURN OLD;

ELSIF (TG_OP = 'UPDATE') THEN OLD.tech_end = CURRENT_TIMESTAMP;

NEW.tech_start = CURRENT_TIMESTAMP;

INSERT
	INTO
	hist_<table_name>
VALUES (OLD.*);

RETURN NEW;
END
IF;
END;

$$ LANGUAGE 'plpgsql'

To better understand the replationships between the SQL tables that store the reporting data, see Data model for IBM Knowledge Catalog reporting. The list of tables is as follows:

Subject area Table name Description
Workspaces containers Catalogs and projects that are created.
Workspaces projects A project and its members.
Workspaces container_assets The assets that are defined in a catalog or project.
Workspaces container_data_assets The data assets that are defined in a catalog or project.
Workspaces container_data_asset_columns The columns in a data asset.
Workspaces data_asset_column_tags The tags that are associated with the columns.
Workspaces asset_collaborators A list of all the members of an asset.
Workspaces container_members A list of all the members of a catalog or project.
Workspaces data_asset_column_class_distribution Suggested data classes for a column with confidence.
Workspaces data_asset_column_prop_values Custom attribute column values.
Workspaces data_source_definitions Details about the data source definitions.
Workspaces connection_dsd_assignments Details about the connections assigned to data source definitions.
User Profiles user_profiles A list of all the users of a catalog or project.
Asset relationships asset_artifact_relations The associations between asset and governance artifacts.
Asset relationships container_assets_associations The relationships between the catalog assets.
Asset relationships asset_tags The tags that are associated with an asset.
Asset relationships governance_artifact_container_associations The governance artifact, which is associated with a catalog asset.
Asset relationships data_asset_column_artifact_associations The governance artifacts, which are associated with the column of the data asset.
Asset relationships column_to_asset_relations The associations between data asset column and an asset.
Asset relationships column_to_column_relations The associations between data asset columns.
Asset relationships column_to_artifact_relations The associations between data asset column and artifacts.
Asset relationships data_asset_pk_fk_columns The associations between data asset column and any asset.
Asset relationships data_asset_fk_ref_columns The associations between data asset reference column and any asset.
Tags Tags The tags that are defined.
Rules enforcement_rules The enforcement rules (data protection rules) that are defined.
Categories categories The governance categories that are defined.
Categories category_collaborators A list of all collaborators of a category.
Categories category_tags The tags that are associated with a category.
Categories category_associations The relationships between categories.
Governance artifacts governance_artifacts The governance artifacts that are defined in the system that are in the published state.
Governance artifacts governance_artifact_stewards A list of stewards that are assigned to a published artifact.
Governance artifacts governance_artifact_associations The relationships between the governance artifacts.
Governance artifacts artifact_tags The tags that are associated with an artifact.
Artifact relationships secondary_category_associations A list of secondary categories to which an artifact is assigned.
Artifact relationships business_term_associations The relationships between business terms.
Artifact relationships data_class_associations The relationships between data classes.
Artifact relationships policy_associations The relationships between policies.
Artifact relationships reference_data_set_associations The relationships between reference data sets.
Artifact relationships classification_associations The relationships between classifications.
Artifact relationships governance_rule_associations The relationships between governance rules.
Artifact relationships artifact_enforcement_rule_associations The implicit relationships between a governance artifact and enforcement rules.
Artifact relationships artifact_category_associations The relationships between governance artifact and category.
Metadata imports and enrichments metadata_imports Metadata import information.
Metadata imports and enrichments metadata_import_executions The scheduled time of the metadata import job.
Metadata imports and enrichments metadata_enrichments Metadata enrichments information.
Data quality rules dq_issues_for_asset_columns The data quality issues for a column.
Data quality rules dq_issues_for_assets) The issues observed when assets undergo quality analysis to determine the overall data quality.
Data quality rules dq_checks Information about the data quality checks.
Data quality rules dq_v4_dimensions The quality dimensions for the rule for example wheather there is duplicates.
Data quality rules dq_rule_definitions The data quality rule definition.
Data quality rules dq_rules_defs Data Quality Rule Definitions.
Data quality rules dq_rules The data quality rule information.
Data quality rules dq_rule_bindings The rule bindings for the data quality rule.
Data quality rules dq_rule_execution The scheduled time for the data quality rule job.
Customizations category_custom_roles The custom category roles.
Customizations glossary_custom_relationship_def The custom relationship definitions.
Customizations glossary_ca_attr_artifact_type_assoc The supported artifact types for custom attribute definition.
Customizations glossary_custom_relationship_nodes The source and target artifact type for custom relationship definitions.
Customizations glossary_custom_attr_def The custom attribute definitions.
Customizations glossary_ca_enum_list the custom attribute definitions of ENUM type.
Customizations governance_artifact_custom_attr_values The custom attribute values.
Customizations asset_custom_properties The custom properties group assigned to an asset type and the property under that group.
Customizations asset_type_custom_properties The type of custom property and its associated custom group.
Customizations asset_prop_enum_list The custom property of type enumeration.
Customizations asset_custom_prop_values The the values assigned to the custom properties which are defined against the asset.
Workflow workflow_types The workflow types.
Workflow workflow_templates The workflow templates.
Workflow workflow_configurations The workflow configurations.
Workflow workflows The workflows.
Workflow workflow_tasks The workflow tasks.

Learn more

Parent topic: Setting up reporting for IBM Knowledge Catalog

Generative AI search and answer
These answers are generated by a large language model in watsonx.ai based on content from the product documentation. Learn more