0

Teradata Temporal Table migration to Snowflake.

I am doing migration of Teradata database to Snowflake using infoworks. I want to move my Teradata Temporal Tables as well while maintaining the consistency. How can I achieve this?

PseudoAccount
  • 29
  • 5
  • Can you add more information? What kind of consistency are you referring to? What data types are you using? etc – Brock Noland Nov 17 '20 at 16:52
  • By consistent, I mean all the columns(including the special column of type Period) and all historical rows must be same after the migration. I hope that makes it clear. – PseudoAccount Nov 17 '20 at 17:16
  • Snowflake has [time travel](https://docs.snowflake.com/en/user-guide/data-time-travel.html), but there's no direct relationship between Teradata temporal tables and Snowflake time travel. – Andrew Nov 17 '20 at 17:34
  • So, how should I migrate these table keeping the data integrety intact. Can I ingest the table as SCD type 2. Will that work? – PseudoAccount Nov 17 '20 at 17:36
  • There is a ton of Teradata to SF migrations out there and so all historical rows and columns can be mapped. I think you need to start tracking the issues and identifying solutions for each one. For example period is two timestamps. You can map that to a string separated by a comma and then use a UDF for BEGIN/END. SQLMorph (my free tool) is actually releasing that specific translation on Monday: https://www.phdata.io/sqlmorph-signup/ – Brock Noland Nov 17 '20 at 21:13
  • Snowflake does not have PERIOD data types. Using Teradata's BEGIN and END functions to extract the two Dates / Timestamps into separate columns would let you preserve the contents. SCD Type 2 may work for loading, but don't forget to change all the references to the table to take this into account. – Fred Nov 17 '20 at 21:21

0 Answers0