Introduction

Welcome to Mobilize.Net SnowConvert for Teradata. Let us be your guide on the road to a successful migration.

What is SnowConvert for Teradata?

SnowConvert is a software that understands Teradata SQL, BTEQ, Fastload, and Multiload files, and performs the following conversions:

  • Teradata SQL to Snowflake SQL

  • Teradata Stored Procedures to JavaScript embedded in Snowflake SQL

  • Teradata BTEQ, Fastload, and Multiload to Python

SnowConvert Terminology

Before we get lost in the magic of these code conversions, here a few terms/definitions so you know what we mean when we start dropping them all over the documentation:

  • SQL (Structured Query Language): the standard language for storing, manipulating, and retrieving data in most modern database architectures.

  • BTEQ (Batch Teradata Query): BTEQ was the first utility and query tool for Teradata.

  • SnowConvert: the software that converts securely and automatically your Teradata files to the Snowflake cloud data platform.

  • Conversion rule or transformation rule: rules that allow SnowConvert to convert from a portion of source code to the expected target code.

  • Parse: parse or parsing is an initial process done by SnowConvert to understand the source code and build up an internal data structure to process the conversion rules.

Let's dive into the code conversions that Mobilize.Net SnowConvert can perform in the next sections.