Bigquery migration metadata extractor vs Bigquery migration validator
Bigquery migration metadata extractor is an open-source agent skill for databases. Bigquery migration validator is an open-source agent skill for databases.
- Bigquery migration metadata extractor is best for extract snowflake metadata into a cloud storage bucket for migration assessment.
- Bigquery migration validator is best for validate that an oracle table migrated to bigquery has matching row counts and values.
- What it is
- Bigquery migration metadata extractor is an open-source agent skill for databases.Bigquery migration validator is an open-source agent skill for databases.
- Best for
- Extract Snowflake metadata into a Cloud Storage bucket for migration assessmentValidate that an Oracle table migrated to BigQuery has matching row counts and values
- Kind
- SkillSkill
- Pricing
- Open sourceOpen source
- Platforms
- Claude Code, Codex, Cursor, Gemini CLI, GitHub Copilot, Windsurf, GooseClaude Code, Codex, Cursor, Gemini CLI, GitHub Copilot, Windsurf, Goose
- GitHub stars
- 24.4K24.4K
- Last commit
- Nov 2026Nov 2026
- License
- Apache-2.0Apache-2.0
- Open source
- Good for
- Extract Snowflake metadata into a Cloud Storage bucket for migration assessment; Decide whether a Teradata source needs a local run with a vendor JDBC driver; Pull bounded query logs from Redshift to study workload lineageValidate that an Oracle table migrated to BigQuery has matching row counts and values; Generate a validation config for a batch of tables from extractor metadata; Compare schema and aggregates for a Snowflake migration before running row-level checks
What Bigquery migration metadata extractor does
Local or cloud extraction
Chooses between running the extractor on this machine or on a temporary Compute Engine VM based on driver and network needs.
Metadata and query log extraction
Covers catalog metadata and query history connectors for many warehouses such as Snowflake, Redshift, Teradata, and Oracle.
Secure credential handling
Passes database passwords through response files or password files, and removes the Secret Manager secret after cloud runs.
Archive statistics script
Validates extracted ZIP archives and reports object counts, row and byte totals, and column type distribution.
Run result checks
Explains how to read exit codes, task summaries, and exception files to tell partial from failed extractions.
Downstream handoff guidance
Describes how extracted archives feed BigQuery Migration Assessment and batch SQL translation.
What Bigquery migration validator does
Schema compatibility checks
Compares column presence, mapping and data type compatibility between source and target tables.
Aggregate comparison
Computes column statistics such as counts, sums and min/max across all rows, per partition.
Row-level data comparison
Joins rows on comparison keys and reports mismatched cell values with distances.
Config generation and editing
Generates per-table validation configs from extractor metadata and edits connection and table settings.
Workflow and results investigation
Polls BigQuery Migration workflows and drills into results by table, partition, column and row.
Credential and driver setup
Guides connection setup, Secret Manager passwords and JDBC driver placement for source databases.
Bigquery migration metadata extractor vs Bigquery migration validator: questions
Is Bigquery migration metadata extractor or Bigquery migration validator cheaper?
Both are open source. Compare current plans on each official site.
What is the difference between Bigquery migration metadata extractor and Bigquery migration validator?
Bigquery migration metadata extractor is an open-source agent skill for databases. Bigquery migration validator is an open-source agent skill for databases.
