MLOAD

Translation references to convert Teradata MLOAD files to Python

Teradata MultiLoad is a command-driven utility for fast, high-volume maintenance on multiple tables and views in Teradata Database.

In order to simulate the MultiLoad functionality for Teradata in Snowflake, MultiLoad files and commands are transformed to Python code, similar to the transformations performed for BTEQ and FastLoad scripts. The generated code uses the Snowflake Python project called snowconvert.helpers which contains the required functions to simulate the MultiLoad statements in Snowflake.

MultiLoad Commands Translation

Most of the MultiLoad Commands are considered not relevant in Snowflake, these commands are commented out. Below is the summary list of MultiLoad commands and their transformation status into Snowflake:

ACCEPT

Commented

​

Transformed

​​The node is commented out since the transformation occurs in other related statements instead.

BEGIN DELETE MLOAD

Commented

​

DATEFORM

Commented

​

DELETE

Partially transformed

DISPLAY

Commented

​

Transformed

​

END MLOAD

Transformed

​​Commented out since is not necessary for the transformation of the BEGIN MLOAD.

EOC

Commented

​

Transformed

​

Transformed

This command needs to be with a FIELD and LAYOUT command to be converted.

IF, ELSE, and ENDIF

Commented

​

Transformed

​

INSERT

Transformed

This is taken as a Teradata Statement, so it doesn't appear in this chapter.

Transformed

This command needs to be with a FIELD and FILLER command to be converted.

LOGDATA

Commented

​

LOGMECH

Commented

​

LOGOFF

Commented

​

LOGON

Commented

​

LOGTABLE

Commented

​

PAUSE ACQUISITION

Commented

​

RELEASE MLOAD

Commented

​

ROUTE MESSAGES

Commented

​

RUN FILE

Commented

​

SET

Commented

​

SYSTEM

Commented

​

TABLE

Commented

​

UPDATE

Transformed

This is taken as a Teradata Statement, so it doesn't appear in this chapter.

VERSION

Commented

​

However, there are some exceptional commands that must be converted into Python-specific code for them to work as intended in Snowflake. See this section.

If you have any additional questions regarding this documentation, you can email us at snowconvert-support@snowflake.com.

Last updated