Connect FTP NDJSON file and Clickhouse in our serverless environment

class SftpSourceReadRemoteNdjson {
    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");
    }

    async fetch(publish, done) {
        // TODO: Customize your ndjson file path to download
        const stream = new PassThrough();
        stream
            .pipe(ndjson.parse())
            .on("data", async (line) => {
                await publish(line);
            })
            .on("end", done);

        // TODO: Customize the ndjson file location
        await this.sftp.get("/remoteDirPath/fileName.ndjson", stream);
    }

    async close() {
        await this.sftp.end();
    }
}

class ClickhouseTargetInsert {
    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"
        );
        // TODO: customize your sql query
        // This opens insert stream for your table
        this.stream = new Stream.Readable({
            objectMode: true
        });
        this.ws = client.insert({
            table: "your_table_name",
            values: stream,
            format: "JSONCompactEachRow",
        });
    }

    async consume(item) {
        // TODO: Map your item to row
        this.stream.push(item);
    }

    async close() {
        // wait stream to finish
        this.stream.push(null);
        await this.ws;
        await this.clickhouse.close();
    }
}