Connect Snowflake and Send email in our serverless environment

class SnowflakeSourceSelect {
    async init() {
        // TODO: Create your snowflake credential
        // More info at https://yepcode.io/docs/integrations/snowflake/#credential-configuration
        this.snowflake = yepcode.integration.snowflake(
            "your-snowflake-credential-name"
        );
        await this.snowflake.connect();
    }

    async fetch(publish, done) {
        // TODO: Customize your SQL query
        this.snowflake
            .execute({
                sqlText: "SELECT * FROM YOUR_TABLE LIMIT 30",
            })
            .streamRows()
            .on("data", publish)
            .on("end", done);
    }

    async close() {
        await this.snowflake.destroy();
    }
}

class SmtpTargetSendEmail {
    async init() {
        // TODO: Create your smtp credential
        // More info at https://yepcode.io/docs/integrations/smtp/#credential-configuration
        this.smtp = yepcode.integration.smtp("your-smtp-credential-name");
        this.items = [];
    }

    async consume(item) {
        // we save the items for later
        this.items.push(item);
        // we could send a mail per item here if we want to
    }

    async close() {
        // we want to send a resume mail so we send it at the end
        // TODO: Customize email content
        const text = `Here are the items we got:
    ${this.items.map((item) => ` * ${item.id}: ${item.name}`).join("\n")}`;
        // TODO: Customize email params: from, to and subject
        await this.smtp.sendMail({
            from: "your-email@example.com",
            to: "the-target@example.com",
            subject: `Choose your subject`,
            text,
        });
    }
}