Connect Clickhouse and FTP CSV file in our serverless environment

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

    async fetch(publish, done) {
        // TODO: customize your sql query
        const sql = "SELECT * FROM your_table_name";

        const resultSet = await this.clickhouse.query({
            query: sql,
            format: "CSV",
        });
        const stream = resultSet.stream();
        stream.on("data", (rows) => {
            rows.forEach(publish);
        });
        stream.on("end", done);
    }

    async close() {
        await this.clickhouse.close();
    }
}

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

        // 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);
        }
    }
}