# Datalineage bigquery asset impact analysis

> Datalineage bigquery asset impact analysis is an open-source agent skill for databases. Analyzes the downstream impact (blast radius) using data lineage on Google Cloud when a BigQuery table or view is broken, stale, or modified. It is available on Claude Code, Codex, Cursor, Gemini CLI, GitHub Copilot, Windsurf and Goose.

- **Kind:** Skill
- **Pricing:** Open source
- **Platforms:** Claude Code, Codex, Cursor, Gemini CLI, GitHub Copilot, Windsurf, Goose
- **Website:** https://github.com/google/skills/tree/main/skills/cloud/datalineage-bigquery-asset-impact-analysis
- **Repository:** https://github.com/google/skills
- **GitHub stars:** 24,379
- **License:** Apache-2.0
- **Skill name:** datalineage-bigquery-asset-impact-analysis
- **Collection:** https://github.com/google/skills
- **Categories:** databases
- **Listing updated:** 2026-11-17

## About

Analyzes the downstream impact (blast radius) using data lineage on Google Cloud when a BigQuery table or view is broken, stale, or modified. Identifies all downstream tables, dashboards, and processes that will be affected. Use when: - Performing a blast radius or impact analysis for a BigQuery table or view. - Assessing the consequences of modifying, deleting, or pausing updates to a BigQuery asset. - Identifying downstream dependencies (tables, dashboards, processes) of a BigQuery asset. Don't use for: - General BigQuery querying or data analysis (use BigQuery-related tools instead). - Non-BigQuery assets (e.g., Cloud Storage files) unless they are part of the BigQuery lineage. - Creating or modifying lineage links directly.

## When your agent uses it

> Analyzes the downstream impact (blast radius) using data lineage on Google Cloud when a BigQuery table or view is broken, stale, or modified. Identifies all downstream tables, dashboards, and processes that will be affected. Use when: - Performing a blast radius or impact analysis for a BigQuery table or view. - Assessing the consequences of modifying, deleting, or pausing updates to a BigQuery asset. - Identifying downstream dependencies (tables, dashboards, processes) of a BigQuery asset. Don't use for: - General BigQuery querying or data analysis (use BigQuery-related tools instead). - Non-BigQuery assets (e.g., Cloud Storage files) unless they are part of the BigQuery lineage. - Creating or modifying lineage links directly.

## What it can access

From a static check of the files on GitHub; nothing was run.

- [Instructions only, no scripts](https://github.com/google/skills/tree/HEAD/skills/cloud/datalineage-bigquery-asset-impact-analysis)
- [License: Apache-2.0](https://github.com/google/skills/tree/HEAD/skills/cloud/datalineage-bigquery-asset-impact-analysis)

## Install

### Claude Code

Copy the skill folder to `~/.claude/skills/datalineage-bigquery-asset-impact-analysis` to use it in all your projects:

```sh
tmp=$(mktemp -d) &&
git clone --depth 1 https://github.com/google/skills.git "$tmp" &&
mkdir -p ~/.claude/skills &&
rm -rf ~/.claude/skills/datalineage-bigquery-asset-impact-analysis &&
cp -R "$tmp/skills/cloud/datalineage-bigquery-asset-impact-analysis" ~/.claude/skills/datalineage-bigquery-asset-impact-analysis &&
rm -rf "$tmp"
```

For one project only, put the folder in `.claude/skills/datalineage-bigquery-asset-impact-analysis` inside it instead.

### Codex

Copy the skill folder to `~/.agents/skills/datalineage-bigquery-asset-impact-analysis` to use it in every repository:

```sh
tmp=$(mktemp -d) &&
git clone --depth 1 https://github.com/google/skills.git "$tmp" &&
mkdir -p ~/.agents/skills &&
rm -rf ~/.agents/skills/datalineage-bigquery-asset-impact-analysis &&
cp -R "$tmp/skills/cloud/datalineage-bigquery-asset-impact-analysis" ~/.agents/skills/datalineage-bigquery-asset-impact-analysis &&
rm -rf "$tmp"
```

For one repository only, put the folder in `.agents/skills/datalineage-bigquery-asset-impact-analysis` inside it instead.

### Cursor

Copy the skill folder to `~/.cursor/skills/datalineage-bigquery-asset-impact-analysis` to use it in every project:

```sh
tmp=$(mktemp -d) &&
git clone --depth 1 https://github.com/google/skills.git "$tmp" &&
mkdir -p ~/.cursor/skills &&
rm -rf ~/.cursor/skills/datalineage-bigquery-asset-impact-analysis &&
cp -R "$tmp/skills/cloud/datalineage-bigquery-asset-impact-analysis" ~/.cursor/skills/datalineage-bigquery-asset-impact-analysis &&
rm -rf "$tmp"
```

For one project only, put the folder in `.cursor/skills/datalineage-bigquery-asset-impact-analysis` inside it instead.

### Gemini CLI

Run in a terminal (add `--scope workspace` to install it for the current workspace only):

```sh
gemini skills install https://github.com/google/skills.git --path skills/cloud/datalineage-bigquery-asset-impact-analysis
```

Or copy the folder to `~/.gemini/skills/datalineage-bigquery-asset-impact-analysis` yourself.

### VS Code

For GitHub Copilot in VS Code, copy the skill folder to `~/.copilot/skills/datalineage-bigquery-asset-impact-analysis`:

```sh
tmp=$(mktemp -d) &&
git clone --depth 1 https://github.com/google/skills.git "$tmp" &&
mkdir -p ~/.copilot/skills &&
rm -rf ~/.copilot/skills/datalineage-bigquery-asset-impact-analysis &&
cp -R "$tmp/skills/cloud/datalineage-bigquery-asset-impact-analysis" ~/.copilot/skills/datalineage-bigquery-asset-impact-analysis &&
rm -rf "$tmp"
```

For one project only, put the folder in `.github/skills/datalineage-bigquery-asset-impact-analysis` inside it instead.

### Other agents

Get the folder:

```sh
git clone --depth 1 https://github.com/google/skills.git
```

Then copy `skills/skills/cloud/datalineage-bigquery-asset-impact-analysis` into your agent's skills folder as `datalineage-bigquery-asset-impact-analysis`. Agents that support SKILL.md read one folder per skill.

## FAQ

### How do I install Datalineage bigquery asset impact analysis in Claude Code?

Copy the skill folder from GitHub to ~/.claude/skills/datalineage-bigquery-asset-impact-analysis to use it in all your projects, or to .claude/skills/datalineage-bigquery-asset-impact-analysis in one project.

### Does Datalineage bigquery asset impact analysis run scripts?

No. It is instructions only, with no scripts. This comes from a static check of the files on GitHub; nothing was run. Read the files before you install it.

### Which AI agents can use Datalineage bigquery asset impact analysis?

Claude Code, Codex, Cursor, Gemini CLI, GitHub Copilot, Windsurf and Goose. Each reads skills in the SKILL.md format from its own folder; the install steps on this page list them.

### What are the best alternatives to Datalineage bigquery asset impact analysis?

The closest alternatives to Datalineage bigquery asset impact analysis are Bigquery pipeline audit, SQL server table reconciliation, Postgresql optimization, Pinecone rag and SQL object impact analysis.

## Alternatives

- [Bigquery pipeline audit](https://ai-powered.com/skills/bigquery-pipeline-audit): Bigquery pipeline audit is an open-source agent skill for databases.
- [SQL server table reconciliation](https://ai-powered.com/skills/sql-server-table-reconciliation): SQL server table reconciliation is an open-source agent skill for databases.
- [Postgresql optimization](https://ai-powered.com/skills/postgresql-optimization): Postgresql optimization is an open-source agent skill for databases.
- [Pinecone rag](https://ai-powered.com/skills/pinecone-rag): Pinecone rag is an open-source agent skill for knowledge and memory.
- [SQL object impact analysis](https://ai-powered.com/skills/sql-object-impact-analysis): SQL object impact analysis is an open-source agent skill for databases.
- [Snowflake semanticview](https://ai-powered.com/skills/snowflake-semanticview): Snowflake semanticview is an open-source agent skill for databases.
- [Creating oracle to postgres migration integration tests](https://ai-powered.com/skills/creating-oracle-to-postgres-migration-integration-tests): Creating oracle to postgres migration integration tests is an open-source agent skill for databases.
- [Migrating oracle to postgres data access code](https://ai-powered.com/skills/migrating-oracle-to-postgres-data-access-code): Migrating oracle to postgres data access code is an open-source agent skill for databases.

---
Source: https://ai-powered.com/skills/datalineage-bigquery-asset-impact-analysis
