Skip to main content

Metadata Analysis

RightSight User Guide  ·  Module 12 of 14

Metadata Analysis v7.6 beta

Deep-dive into object-level metadata with filters, time-travel integration, and detailed column inspection.

Overview

Metadata Analysis provides object-level detail for every table and view in a connection. It supports advanced filtering, sorting, and a detail drawer with column-level metadata. It integrates with the Time Travel system for historical analysis.

Target Persona: Data Engineers, Data Stewards, Data Architects.

Prerequisites: At least one connection with completed metadata extraction.

How This Module Helps

This is your deep-dive tool for individual tables and views. While Metadata Observability gives you the dashboard, this module lets you inspect specific objects, review column metadata, and understand table-level detail.

Connects To Relationship
Metadata Observability Drill from dashboard KPIs
Business Terms Columns may be tagged with terms
Review & Confirm (DQ) Objects have associated DQ rules
Metadata Extract & Enrich Extraction populates this view
Method Path
Sidebar Observability → RightSight → Metadata Analysis (under Dashboards)
URL /metadata-analysis
From Metadata Observability /metadata-analysis?connectionId=<id>&type=<tables|views|schemas>
Time Travel drill-through /metadata-analysis?connectionId=<id>&IsTimeTravelMode=true&Date=<date>&Time=<time>

Features & Workflows

1. Selecting a Connection

  1. On the landing page, click a connection card.
Connection Selection Landing
Figure 1: Connection Selection Landing
  1. The analysis view loads with KPIs and the objects table.
Analysis view loaded
Figure 2: Analysis view loaded

2. Browsing Objects

  1. Review the objects table showing all tables and views.
Objects table
Figure 3: Objects table
  1. Use filters to narrow:
Filter Description
Database Filter by database
Schema Multi-select schemas
Type All / Tables / Views
Search Search by object name
  1. Click column headers to sort.

3. Viewing Object Details

  1. Click any row in the objects table.

  2. The Detail Drawer opens with tabs:

Detail Drawer
Figure 4: Detail Drawer

Table Details Tab: - Object name, schema, database - Row count, column count - Created date, last modified - Primary key columns, foreign key relationships

Column Metadata Tab:

Column Metadata
Figure 5: Column Metadata
Column Info Description
Name Column name
Data Type SQL data type
Nullable Yes/No
Default Default value
PK Primary key indicator
FK Foreign key reference
  1. Use Previous/Next buttons in the drawer footer to navigate between objects.

4. Using Time Travel

  1. Click 🕐 Time Travel button.

  2. The Calendar appears — select a day and hour.

  3. All data shows metadata as of the selected snapshot.

  4. Click Exit Time Travel to return.

From Metadata Analysis Navigate To
Back to Observability Metadata Observability
Column → tagged with business term Business Terms
Object → DQ rules Review & Confirm (DQ)

Tips & Best Practices

  • Use the Schema multi-select to narrow analysis to relevant schemas.
  • The Detail Drawer's Column Metadata tab is ideal for business terms cross-referencing.
  • Sort by Row Count to identify the largest tables for targeted DQ attention.
Was this article helpful?