Free warehouse assessment

Snowflake, Databricks and dbt consulting, from migration to the BI layer

Shearwater Data moves warehouses onto Snowflake, Databricks or BigQuery, models them in dbt and finishes the work in the BI layer your team uses. We were founded by early Looker team members, with 100+ implementations and 8,000+ hours behind us. In a free warehouse assessment we look at your current platform and tell you what a move or a build-out takes.

  • Teradata, Oracle, SQL Server, Netezza, Hadoop and Redshift moves, reconciled table by table
  • Stored procedures and ETL jobs rewritten as tested dbt models
  • A semantic model on top, so every dashboard reads the same definitions

Request your free warehouse assessment

With a senior member of our team. You leave with a scope and a timeline. No preparation needed.

Please use your work email so we can prepare for your company.
Enter your name.
Enter your company.
Pick your current BI tool.
Pick a timeline.

A senior member of our team will email you to arrange a time. We use your details to reply to your request. See our privacy policy.

Thanks, we have your request.

A senior member of our team will email you within one business day.

Data teams we have worked with

  • Condé Nast
  • Bloomberg
  • Endeavor
  • Stairwell
  • Zapnito
  • TickPick
  • Laravel
  • Beatstars
  • TRM
  • Thought Industries
  • Central Retail
  • Tread
8,000+hours of Omni delivery
100+Omni implementations
Ex-Lookerfounded by early Looker team members

What the assessment covers

A working session on your current warehouse and where you want it to be. Bring whoever owns the platform.

  1. Your current platform.Source warehouse or ETL tool, data volumes, the number of tables, jobs and stored procedures, and everything that reads from them.
  2. The target.Snowflake, Databricks, BigQuery or Microsoft Fabric. If you have already chosen, we plan for that platform. If you have not, we compare them against your own workloads.
  3. Scope and timeline.What moves as is, what gets rewritten in dbt and what can be retired, as a size band.
  4. Next steps.If it makes sense to go further, we scope the work with you from what we found.

Where the work goes

A warehouse move has four parts, and each one is planned and tested on its own.

Data and schema

Tables, types and history moved with the platform's own loaders or replication, then reconciled on row counts, sums and key metrics before anything downstream switches.

Logic

Stored procedures, BTEQ and PL/SQL scripts, and Informatica, Talend or Alteryx jobs rewritten as dbt models with tests, so the logic sits in one repo your team can read.

Workloads

Warehouse sizing, clustering, partitioning and cost monitoring set for how your team queries, so you can see and control what the new platform costs.

Consumers

BI tools, extracts and downstream jobs repointed and tested. The semantic model is rebuilt in Omni, Looker or the BI tool you already use.

How a migration runs

Five stages, each with an output you keep.

  1. Inventory.Every table, job and report that touches the old platform, with usage over the last 90 days. Unused objects are retired with owner sign-off.
  2. Design.Target layout, dbt project structure, environments and access roles, agreed before we build.
  3. Move and rewrite.Data is loaded and logic is rewritten in dbt in priority order, one workload at a time.
  4. Reconcile.Each table and key metric is compared with the old platform, and every difference is explained or fixed in a log you keep.
  5. Cut over on your date.Both platforms run side by side until owners sign off, then the old one is switched off with a checklist for the jobs and extracts people forget.

Who this is for

  • Teams leaving Teradata, Oracle, SQL Server, Netezza or Hadoop for a cloud warehouse
  • Snowflake or Databricks customers whose models grew without tests or clear ownership
  • Teams adopting dbt, or moving Informatica, Talend or Alteryx logic into it

Who it is not for

  • Teams looking to buy Snowflake, Databricks or dbt licenses. Those come from the vendor.
  • Projects with no reporting or analytics use at the end

The team behind it

Jeff Garcia

CEO

Spent about eight years at Looker, from 2013 to 2021.

Andrew Searson

Chief Data Officer

Early Looker team member who has led data analytics for 17+ years, building self-service data organizations.

Bruna Baungarten

Director of Delivery

Leads the Shearwater team that runs your project.

Questions

What does the assessment cost, and what do we commit to?

The assessment is free and you commit to nothing. If you go ahead, the work is scoped as a project from what we learn in the assessment.

Snowflake or Databricks: which should we pick?

It depends on your workloads. As a rough guide, SQL analytics with many BI users suits Snowflake or BigQuery, and heavy data science or large volumes of raw files suit Databricks. Some teams run both. If you have not decided, the assessment compares them against your own workloads.

How long does a warehouse migration take?

A single warehouse with a few hundred tables and modest stored-procedure logic usually moves in 2 to 4 months. Large Teradata or Hadoop estates with thousands of jobs take longer and move in waves. The assessment gives you a range for your own platform.

What happens to our stored procedures and ETL jobs?

We list every one, retire what nothing reads, and rewrite the rest as dbt models with tests. Steps that have to stay procedural, such as some loads and API calls, move into your orchestration tool.

Do you work with BigQuery, Redshift and Microsoft Fabric?

Yes. The process is the same on any cloud warehouse: inventory, rewrite, reconcile and cut over. Synapse to Fabric moves follow the same steps.

How do you make sure the numbers match?

Every table and key metric is compared with the old platform before anything downstream switches. Each difference is explained or fixed in a log your team keeps, and the old platform stays on until owners sign off.

Who is Shearwater Data?

A data consultancy founded by early Looker team members, and an Omni implementation partner. We migrate and model warehouses, design semantic layers and run BI migrations.

Is the assessment a sales call?

It is a working session on your setup with a senior member of our team, which was founded by early Looker team members. If a move makes sense, we offer to scope it. If it does not, we say so.

What do you need from us, and how long is the call?

Nothing in advance. The call runs up to an hour on Google Meet. Bring whoever owns the model and we look at your setup together.

“It’s quite impressive that we were able to swap platforms with Shearwater and still deliver the same experience while cutting costs, all in 4 weeks.”
Jon Beer, COO, Zapnito

See what your warehouse move involves

Free, with no commitment. You leave with a scope and a timeline.

Request my free assessment

Shearwater Data is an Omni implementation partner.

© 2026 Shearwater Data. All rights reserved.

Privacy Policy

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.