datalineage-summary

Data Lineage Summary

This skill guides the agent in investigating and summarizing the Data Lineage graph for a specific focal asset (Table-Level Lineage) or specific fields (Column-Level Lineage). It provides an intuitive left-to-right walkthrough of how data enters and leaves the asset, abstracting away complex node and link details into plain English.

Prerequisites

This skill relies on the Google Cloud Data Lineage (Knowledge Catalog) MCP Server for graph traversal. Ensure you can run search_lineage queries in both upstream and downstream directions. For detailed connection configurations and tool schemas, refer to MCP Usage.

Workflow Logic

1. Get Lineage

Fetch the lineage graph in both directions from the focal point (both upstream and downstream) by making two separate calls to the MCP tool: one with "direction": "UPSTREAM" and another with "direction": "DOWNSTREAM".

• Location Strategy: You MUST use the read_url tool to fetch the comprehensive list of locations dynamically from the provided Knowledge Catalog Locations link. To ensure cross-regional lineage is not missed, always verify the current list of GCP regions using this link before populating the locations array. You MUST populate the locations array with all supported physical regions fetched from this link. You may optionally additionally determine the asset's specific active region (using bq show or gcloud storage ls).

• Search Parameters: Use maxDepth = 10, maxResults = 5000 and maxProcessPerLink = 10 as robust defaults when calling search_lineage. For example, a DOWNSTREAM call should be formatted like this (expanding the locations array as needed):

  {
    "parent": "projects/project_id/locations/us",
    "locations": [
      "us",
      "us-central1",
      "us-east1",
      "us-west1",
      "europe-west1",
      "asia-northeast1"
    ],
    "rootCriteria": {
      "entities": {
        "entities": [
          {
            "fullyQualifiedName": "bigquery:project.dataset.table"
          }
        ]
      }
    },
    "direction": "DOWNSTREAM",
    "limits": {
      "maxDepth": 10,
      "maxResults": 5000,
      "maxProcessPerLink": 10
    }
  }