DEFINE JOB IMPORT_TO_TERADATA_SETUP DESCRIPTION 'Import data to Teradata from Amazon S3' ( STEP CLEANUP_CREATE_TABLE_STEP ( APPLY (' DROP TABLE S3W001 '), (' DROP TABLE S3W001_e1 '), (' DROP TABLE S3W001_e2 '), (' DROP TABLE S3W001_log '), ('CT S3W001 ( Associate_Id INTEGER, Associate_Name CHAR(25), Salary FLOAT, DOJ DATE, Designation VARCHAR(25), Loan_Amount DECIMAL(5,2), Martial_Status CHAR(1), No_Of_Dependents BYTEINT ); ') TO OPERATOR ($DDL); ); );