SnowConvert is a software that understands Teradata SQL, BTEQ, Fastload, and Multiload files, and performs the following conversions:
Teradata SQL to Snowflake SQL
Teradata BTEQ, Fastload, and Multiload to Python
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.