Pular para o conteúdo
Kitbay
SkillOficial

bigquery-migration-sql-translator

Apache-2.0Atualizado em 11 de nov. de 202623.842Estrelas no GitHubInclui scripts

This Google skill helps an agent move SQL from Teradata, Oracle, Redshift, Snowflake, SparkSQL or HiveQL to BigQuery GoogleSQL through the BigQuery Migration Service and its remote MCP server.

O que a skill ensina

This Google skill helps an agent move SQL from Teradata, Oracle, Redshift, Snowflake, SparkSQL or HiveQL to BigQuery GoogleSQL through the BigQuery Migration Service and its remote MCP server. It lists the setup first: a billing-enabled project, the Migration API turned on, roles for MCP tool use, migration editing and Cloud Storage access, and an MCP connection whose setup is described for Claude, Cursor, Gemini CLI and VS Code. It then covers interactive translation of single queries, batch translation of files staged in Cloud Storage, triage of compiler errors, YAML translation settings and dialect-specific pitfalls. It comes with config examples, JSON schemas and a Python template.

O que faz

  • Translate legacy SQL queries to BigQuery GoogleSQL
  • Run batch translation of files staged in Cloud Storage
  • Configure YAML translation settings
  • Resolve translation errors by dialect