Bigquery migration data loader vs Bigquery migration SQL translator
Bigquery migration data loader is an open-source agent skill for databases. Bigquery migration SQL translator is an open-source agent skill for databases.
- Bigquery migration data loader is best for create a bigquery dataset for a warehouse migration in the right region.
- Bigquery migration SQL translator is best for translate an oracle pl/sql procedure into bigquery googlesql.
- What it is
- Bigquery migration data loader is an open-source agent skill for databases.Bigquery migration SQL translator is an open-source agent skill for databases.
- Best for
- Create a BigQuery dataset for a warehouse migration in the right regionTranslate an Oracle PL/SQL procedure into BigQuery GoogleSQL
- 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
- Create a BigQuery dataset for a warehouse migration in the right region; Batch load exported Parquet files from Cloud Storage into BigQuery tables; Deploy views translated by BigQuery Migration Service into a target datasetTranslate an Oracle PL/SQL procedure into BigQuery GoogleSQL; Convert a batch of Teradata query files staged in a Cloud Storage bucket; Generate BigQuery table DDL from a Teradata metadata zip archive
What Bigquery migration data loader does
Dataset provisioning
Creates the target BigQuery dataset at a location matching the staged Cloud Storage bucket.
Parquet batch loading
Loads Parquet files into native tables with decimal type mapping and automatic schema inference.
View deployment
Deploys translated views into the target dataset with source references rewritten to the target.
Row count auditing
Counts loaded rows per table so results can be compared against the source database.
Translation output discovery
Finds tables and views from BigQuery Migration Service metadata, locally or in Cloud Storage.
What Bigquery migration SQL translator does
Interactive query translation
Translates a single query, polls the job and reviews logs and output SQL.
Batch file translation
Runs multi-file translations from Cloud Storage and reads the consolidated report.
Metadata DDL generation
Produces target BigQuery schema definitions from a database metadata zip.
Error effect triage
Groups issues by correctness, completeness and compatibility to fix them in order.
Dialect gotcha checks
Checks output against known pitfalls for Teradata, Oracle and Snowflake.
YAML configuration support
Guides renaming, schema redirection, partitioning and optimizer settings.
Bigquery migration data loader vs Bigquery migration SQL translator: questions
Is Bigquery migration data loader or Bigquery migration SQL translator cheaper?
Both are open source. Compare current plans on each official site.
What is the difference between Bigquery migration data loader and Bigquery migration SQL translator?
Bigquery migration data loader is an open-source agent skill for databases. Bigquery migration SQL translator is an open-source agent skill for databases.
