Workload

SQL / query migration

SQL / query migration

SQL / query migration

Workload scope

SQL query migration covers dialect conversion, semantic preservation, query validation, and target-native rewrites for analytical workloads and downstream reporting logic.

Use this hub to find the source-to-target pages that already include workload-specific conversion risks, supported patterns, validation gates, examples, and cutover criteria. The hub is intentionally tied to the migrated child-page corpus so missing child content remains visible during parity review.

  • Databricks to BigQuery - Convert Databricks SQL to BigQuery with parity for MERGE, windows, NULL/type coercion, and time semantics, with validation gates and pruning-aware rewrites.
  • Databricks to Snowflake - Convert Databricks SQL (Spark SQL) to Snowflake SQL with parity for MERGE, window logic, null/type behavior, and timezone handling, with validation gates.
  • Hadoop legacy cluster to BigQuery - Convert Hive/Impala/Spark SQL from Hadoop to BigQuery Standard SQL with parity for partitions, windows, NULL coercion, and time semantics with KPI gates.
  • Hive to BigQuery - Convert HiveQL to BigQuery with parity for partition pruning, window functions, NULL/type coercion, and time semantics, with golden-query validation.
  • Impala to BigQuery - Convert Impala SQL to BigQuery Standard SQL with parity for partitioning, NULL/type behavior, windows, and Hive idioms, with validation gates and pruning.
  • Impala to Snowflake - Convert Impala SQL to Snowflake SQL with parity for partition filtering, window functions, NULL/type behavior, and golden-query validation without credit spike.
  • Netezza to BigQuery - Convert Netezza SQL to BigQuery with parity for window functions, NULL/type coercion, and time semantics, with golden-query validation and pruning rewrites.
  • Oracle to BigQuery - Convert Oracle SQL to BigQuery Standard SQL with parity for analytics, date/time semantics, NULL behavior, and Oracle constructs with validation gates.
  • Redshift to BigQuery - Convert Redshift SQL to BigQuery Standard SQL with parity for windows, date/time semantics, NULL/type coercion, and UPSERT patterns, validated with drift gates.
  • Redshift to Snowflake - Convert Redshift SQL to Snowflake SQL with parity for window functions, NULL/type coercion, date/time semantics, and MERGE patterns with golden-query checks.
  • Snowflake to BigQuery - Convert Snowflake SQL to BigQuery with semantic parity for QUALIFY, JSON handling, timezones, and MERGE patterns.
  • Spark SQL to BigQuery - Convert Spark SQL to BigQuery Standard SQL with parity for window functions, NULL/type coercion, arrays/structs, and time semantics with validation gates.
  • Teradata to BigQuery - Convert Teradata SQL to BigQuery Standard SQL with parity for QUALIFY, date/time semantics, analytics, and joins, with validation gates and safe rewrites.
  • Teradata to Snowflake - Convert Teradata SQL to Snowflake SQL with parity for QUALIFY, window functions, NULL/type coercion, date/time semantics, and golden-query validation.
  • Vertica to BigQuery - Convert Vertica SQL to BigQuery with parity for windows, NULL/type coercion, and date/time semantics, with golden-query validation and pruning-aware rewrites.

Review points

  • Function, operator, and dialect differences
  • NULL, type coercion, and timestamp semantics
  • Window ordering, dedupe, and top-N stability
  • Golden-query parity and edge-cohort diffs

Acceptance criteria

A sql / query migration page is complete when the migration team can identify source assets, understand conversion assumptions, review unsupported or ambiguous constructs, run validation checks, and decide whether the workload is ready for cutover.

For each related path, confirm that the child page explains what changes, how conversion works, which patterns are supported, what can drift, and which evidence is required before production traffic moves to the target platform.