Novuz

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.

SourceTo Google BigQueryTo 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 loopsDatabricks SQL or PySpark, and Workflows
SSIS packagesGoogleSQL load and transform steps, with the orchestration agreed in the assessmentNotebooks and Workflows
Teradata (SQL, BTEQ, macros, load utilities)GoogleSQL and stored procedures, with BTEQ control flow rebuilt as scripted stepsDatabricks SQL, notebooks and Workflows
Hadoop (Hive, Impala, Spark scripts, Oozie)GoogleSQL over BigQuery tablesDatabricks SQL, PySpark and Workflows
Snowflake (SQL, JavaScript procedures, tasks, streams)GoogleSQL and stored procedures, with streams and tasks rebuilt as incremental loadsDatabricks SQL, PySpark and Workflows
IBM Netezza (NZSQL, NZPLSQL, nzload)GoogleSQL and stored procedures, loads from Cloud StorageDatabricks SQL or PySpark, Auto Loader and Workflows
Informatica (IDMC / IICS, Data Quality, Data Engineering Integration)GoogleSQL pipelines and SQL quality checksPySpark notebooks, quality checks and Workflows
Mainframe batch (COBOL, copybooks, JCL, DB2, VSAM)GoogleSQL jobs over tables loaded from the copybook layoutsPySpark 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?

  1. Novuz runs as a Docker container or VM inside your own Google Cloud project, next to BigQuery or your Databricks workspace.
  2. 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.
  3. 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.
  4. 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.
  5. 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. 1 Vendor facts on this page come from each vendor’s own documentation, checked 14 November 2026.

How we measure: Methodology

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.

Take the logic debt scorecard

Not sure which door? The scorecard takes ten minutes and tells you.

Scorecard