Database Output
When you run a Loome Monitor rule, tables and views are created in your output database (your selected target connection). These differ depending on your Loome Monitor rule type and how you have configured the rule. For example, whether it is a source or manual data rule, or whether you have added communication rules.
To view your tables and views in your target connection database, you can find your rule using the project number and rule number in the URL of your rule.
Tables and views are in the format: LM__Project Number.LM__Rule Number__Table/ViewName, for example, LM__1.LM__1__Results.
Types of Output Tables and Views
There are different purposes for each output table and view.
| Table or View | Description | Output Table/View Name |
|---|---|---|
| Results Table | This will provide all records in the results table, including records that are ignored, deleted, and resolved. | LM__Project Number.LM__Rule Number__Results |
| Results Current View | A view of the results table that matches the current view in Loome Monitor. | LM__Project Number.LM__Rule Number__ResultsCurrent |
| Metadata Table | This is a table of all your Loome Monitor metadata for the rule. Any custom fields created in Loome will be displayed here, including the custom fields of records that are ignored, deleted, and resolved. | LM__Project Number.LM__Rule Number__Metadata |
| Metadata Current View | This will display the current view of the metadata in your results table. Records for custom field metadata currently shown in the results table will be displayed here. | LM__Project Number.LM__Rule Number__MetadataCurrent |
| Communications Table | When enabled, this will display when communications were sent to your selected users. | LM__Project Number.LM__Rule Number__Communications |
| Metrics Table | This table contains the count of records in your results table, and will display the number of records under each status, such as unresolved, resolved, and ignored. These are also displayed in the results table. | LM__Project Number.LM__Rule Number__Metrics |
| Archived Tables | Any tables that have been run with a modified key column will archive the previous results table and create a new results table. | LM__Project Number.LM__Rule Number__ArchivedDate |
Source Data Rules: Alert, Glossary, Reference, Data Quality Rule, and Reconciliation
All rules using source data will create:
- Results Table
- Results Current View
- Metadata Table
- Metadata Current View
- Communications Table (if enabled)
- Metrics Table
Manual Data Only Rules: Glossary and Reference
Rules using a manual only data type will create:
- Metadata Table
- Metadata Current View
- Communications Table (if enabled)
- Metrics Table
Source and Manual Data Rules: Glossary and Reference
Rules using a source and manual data type will create:
- Results Table
- Results Current View
- Metadata Table
- Metadata Current View
- Communications Table (if enabled)
- Metrics Table