Connect AWS DynamoDB and FTP CSV file in our serverless environment

class AwsDynamodbSourceScan {
    async init() {
        // More info at https://www.npmjs.com/package/@aws-sdk/client-dynamodb
        // TODO: Create team variables. More info at https://yepcode.io/docs/processes/team-variables
        this.awsDynamodb = new DynamoDBClient({
            region: yepcode.env.AWS_REGION,
            credentials: {
                accessKeyId: yepcode.env.AWS_ACCESS_KEY_ID,
                secretAccessKey: yepcode.env.AWS_SECRET_ACCESS_KEY,
            },
        });
    }

    async fetch(publish, done) {
        // TODO: Customize the scan command
        // More info at: https://docs.aws.amazon.com/AWSJavaScriptSDK/v3/latest/clients/client-dynamodb/interfaces/scancommandinput.html
        const scanCommand = new ScanCommand({
            TableName: "table-name"
        });

        const result = await this.awsDynamodb.send(scanCommand);

        for (const item of result.Items) {
            await publish(item);
        }

        done();
    }

    async close() {}
}

class SftpTargetUploadCsv {
    async init() {
        // More info at https://www.npmjs.com/package/ssh2-sftp-client
        // TODO: Create team variables. More info at https://yepcode.io/docs/processes/team-variables
        this.sftp = new Client();
        await this.sftp.connect({
            host: yepcode.env.SFTP_HOST,
            port: yepcode.env.SFTP_PORT,
            username: yepcode.env.SFTP_USERNAME,
            password: yepcode.env.SFTP_PASSWORD,
        });

        // Transform the items into a csv format
        this.stringifier = csv.stringify({
            delimiter: ",",
        });

        // TODO: Customize the remote directory where to load the csv file
        this.upload = this.sftp.put(
            this.stringifier,
            "/remoteDirPath/fileName.csv"
        );
    }

    async consume(item) {
        // TODO: Customize your csv row
        const csvRow = [item.id, item.name];
        this.stringifier.write(csvRow);
    }

    async close() {
        try {
            this.stringifier.end();
        } catch (error) {
            console.error(`Error ending stringifier`, error);
        }
        try {
            await this.upload;
        } catch (error) {
            console.error(`Error ending upload`, error);
        }
        try {
            await this.sftp.end();
        } catch (error) {
            console.error(`Error ending sftp`, error);
        }
    }
}