Migration
Migrate to Google Cloud: BigQuery and Databricks on Google Cloud
Novuz converts legacy warehouse and ETL logic to Google BigQuery, or to Databricks running on Google Cloud, from SQL Server, SSIS, Teradata, Hadoop, Snowflake, IBM Netezza, Informatica and mainframe batch COBOL and JCL. It runs inside your own Google Cloud project, and every converted object ships with a reconciliation report against the original on the same inputs.
Two targets
BigQuery or Databricks on Google Cloud?
Both are Novuz targets, from one assessment and one inventory. Part of an estate can go to each.
- Google BigQuery: Novuz delivers GoogleSQL, BigQuery stored procedures, and partitioned and clustered tables.
- Databricks on Google Cloud: the same Databricks output Novuz delivers on AWS and Azure, Delta tables in Unity Catalog, notebooks and Workflows, with the data in Cloud Storage.
- BigQuery tends to fit when the analytics and BI estate is already in BigQuery and the logic is mostly SQL.
- Databricks on Google Cloud tends to fit when the workloads are Spark-heavy, or the team already runs Databricks on another cloud.
By source
What converts to Google Cloud, by source?
Every source Novuz covers converts to both Google Cloud targets. Final coverage for your estate is confirmed object by object in the assessment.
| Source | To Google BigQuery | To Databricks on Google Cloud |
|---|---|---|
| SQL Server (T-SQL procedures, views, functions, SQL Agent jobs) | GoogleSQL and BigQuery stored procedures; cursors restructured as set-based SQL or loops | Databricks SQL or PySpark, and Workflows |
| SSIS packages | GoogleSQL load and transform steps, with the orchestration agreed in the assessment | Notebooks and Workflows |
| Teradata (SQL, BTEQ, macros, load utilities) | GoogleSQL and stored procedures, with BTEQ control flow rebuilt as scripted steps | Databricks SQL, notebooks and Workflows |
| Hadoop (Hive, Impala, Spark scripts, Oozie) | GoogleSQL over BigQuery tables | Databricks SQL, PySpark and Workflows |
| Snowflake (SQL, JavaScript procedures, tasks, streams) | GoogleSQL and stored procedures, with streams and tasks rebuilt as incremental loads | Databricks SQL, PySpark and Workflows |
| IBM Netezza (NZSQL, NZPLSQL, nzload) | GoogleSQL and stored procedures, loads from Cloud Storage | Databricks SQL or PySpark, Auto Loader and Workflows |
| Informatica (IDMC / IICS, Data Quality, Data Engineering Integration) | GoogleSQL pipelines and SQL quality checks | PySpark notebooks, quality checks and Workflows |
| Mainframe batch (COBOL, copybooks, JCL, DB2, VSAM) | GoogleSQL jobs over tables loaded from the copybook layouts | PySpark jobs and Workflows |
Risks
What breaks when logic moves to BigQuery?
These are the differences that change results or cost if nobody plans for them.
- No indexes and no enforced keys. BigQuery uses partitioning and clustering instead of indexes, and primary and foreign keys are not enforced, so any de-duplication must stay explicit in the load.
- Procedural code. BigQuery has stored procedures and scripting, but cursor-heavy T-SQL, BTEQ branching and NZPLSQL exception blocks need to be restructured.
- Data types. Numeric precision, timestamp time zones and string comparison differ by source, so each column is mapped explicitly.
- Names are case-sensitive by default. Dataset and table names that a case-insensitive source treated as equal can stop matching.
- Cost follows the bytes. BigQuery bills by data scanned or by reserved capacity, so a query that was cheap on an appliance can cost more until partitioning and clustering are right.
Other tools
What do Google’s own migration tools do, and what do they leave?
- BigQuery Migration Service includes a migration assessment, batch and interactive SQL translators and a translation API. Google states there is no charge to use the BigQuery Migration API; storage for input and output files is billed normally.
- Its translation covers Amazon Redshift, Apache HiveQL, IBM Netezza SQL and NZPLSQL, Snowflake SQL, and Teradata including BTEQ and TPT without a preview label. SQL Server T-SQL, Oracle, Spark SQL, Impala and DB2 are listed in preview.
- Google’s open-source Data Validation Tool compares row counts, grouped counts, column aggregates and schemas between source and target, with row-level hash comparison for BigQuery.
- On Databricks on Google Cloud, Genie Migrate converts T-SQL, Snowflake, Redshift, Oracle, BigQuery and Teradata SQL files, and Informatica PowerCenter in Beta.
- What they leave: SSIS packages, Informatica cloud assets, mainframe batch, schedules and orchestration, and proof tied to the code that produced each table.
How it runs
How does a migration to Google Cloud with Novuz run?
- Novuz runs as a Docker container or VM inside your own Google Cloud project, next to BigQuery or your Databricks workspace.
- The $3,000 assessment counts every object in three business days, bands each one by complexity, lists dead code with the evidence, confirms coverage object by object and fixes the price.
- The First Domain takes one domain of up to 1,500 components and 25 TB to reconciled, cutover-ready output in your environment in 5 to 6 weeks, for $25,000 to $40,000, credited against the full estate.
- Every converted object runs against the original on the same inputs and gets a result: pass, fail or review, with each miss listed by line.
- Further domains follow the same method, and can go to BigQuery, to Databricks on Google Cloud, or to both.
Next question
Where to read next
Still choosing a platform? The target guide compares Databricks, Fabric, Snowflake and BigQuery on your own code.
FAQ
Frequently asked questions
Does Novuz support Google BigQuery as a target?
Yes. Novuz converts SQL Server, SSIS, Teradata, Hadoop, Snowflake, Netezza, Informatica and mainframe batch logic to GoogleSQL, BigQuery stored procedures and partitioned, clustered tables, with a reconciliation report for every object. Coverage for your estate is confirmed in the assessment.
Does Novuz support Databricks on Google Cloud?
Yes. Novuz delivers the same Databricks output on Google Cloud as on AWS and Azure: Delta tables in Unity Catalog, Databricks SQL, PySpark notebooks and Workflows, with the data in Cloud Storage and no Novuz runtime.
Can Novuz migrate Teradata to BigQuery?
Yes. Teradata SQL, BTEQ scripts, macros and load utilities convert to GoogleSQL and BigQuery stored procedures, with BTEQ control flow rebuilt as scripted steps and every object reconciled against Teradata on the same inputs.
Can Novuz migrate SQL Server and SSIS to BigQuery?
Yes. T-SQL procedures, views, functions and SQL Agent jobs convert to GoogleSQL and BigQuery stored procedures, and SSIS packages become load and transform steps with the orchestration agreed in the assessment. Google lists its own SQL Server translation in preview, and it does not convert SSIS packages.
Is the BigQuery Migration Service enough?
It is a good start for SQL. It translates many dialects at no charge for the API and reports what it could not translate. It does not convert SSIS, Informatica or mainframe batch, rebuild schedules, or prove each object on your own inputs. Run it first, and price the remainder.
Does Novuz run inside our Google Cloud project?
Yes. Novuz deploys as a Docker container or VM inside your own Google Cloud project. Your code and data never leave your environment, and no outbound connection is required.
- 1 Vendor facts on this page come from each vendor’s own documentation, checked 14 November 2026.
Sources and further reading
- Google Cloud, Introduction to BigQuery migration
- Google Cloud, Enable SQL translations: supported SQL dialects for BigQuery Migration Service
- Google Open Source Blog, Introducing the Data Validation Tool (10 August 2021)
- Databricks on Google Cloud, Convert SQL scripts and ETL pipelines with Genie Migrate
Written by Ted Ghose, Co-founder and CTO, Novuz
Last reviewed:
Find out what your logic debt is costing you.
Every object counted, lineage, dead code and a fixed price in three business days. $3,000, credited.
Not sure which door? The scorecard takes ten minutes and tells you.