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	​
BEGIN MLOAD	Transformed	​​The node is commented out since the transformation occurs in other related statements instead.
BEGIN DELETE MLOAD	Commented	​
DATEFORM	Commented	​
DELETE	Partially transformed	Check known issues.​
DISPLAY	Commented	​
DML LABEL	Transformed	​
END MLOAD	Transformed	​​Commented out since is not necessary for the transformation of the BEGIN MLOAD.
EOC	Commented	​
FIELD	Transformed	​
FILLER	Transformed	This command needs to be with a FIELD and LAYOUT command to be converted.
IF, ELSE, and ENDIF	Commented	​
IMPORT	Transformed	​
INSERT	Transformed	This is taken as a Teradata Statement, so it doesn't appear in this chapter.
LAYOUT	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 [e-mail].