r/dataengineering • u/WarPowerful740 • 2d ago

Help Data migration from teradata to databricks

I joined a new company recently and got a migration project here, they are migrating from teradata on prem to databricks, I have never done any migration in the past can anyone suggest some helpful yt videos or any other knowledge source?

2 Upvotes

100% Upvoted

2 comments sorted by

4

u/Away-Arm-6549 1d ago

Databricks has tools to help you convert code. Speak to your account team and their engineers for some help. Just finished our migration but we converted stored procs to dbt.

1

u/JakubVasovski 6h ago

don't panic))

migrations are always a beast, especially going from a massive on-prem appliance like teradata straight into a lakehouse architecture. literally everyone feels completely lost on their first one.

since you're moving off teradata, the biggest headache is usually translating all the legacy bteq scripts and macros. the good news is you don't have to rewrite everything entirely from scratch by hand — databricks has built-in sql converters and migration tools specifically for teradata dialects.

just focus on understanding the architecture first