Connect Snowflake and Algolia in our serverless environment

class SnowflakeSourceSelect {
    async init() {
        // More info at https://www.npmjs.com/package/snowflake-sdk
        // TODO: Create team variables. More info at https://yepcode.io/docs/processes/team-variables
        this.connection = snowflake.createConnection({
            account: yepcode.env.SNOWFLAKE_ACCOUNT,
            username: yepcode.env.SNOWFLAKE_USERNAME,
            password: yepcode.env.SNOWFLAKE_PASSWORD,
            warehouse: yepcode.env.SNOWFLAKE_WAREHOUSE,
            database: yepcode.env.SNOWFLAKE_DATABASE,
            schema: yepcode.env.SNOWFLAKE_SCHEMA,
        });
        await this.connection.connect();
    }

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

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

class AlgoliaTargetSaveObjects {
    async init() {
        // More info at https://www.npmjs.com/package/algoliasearch
        // TODO: Create team variables. More info at https://yepcode.io/docs/processes/team-variables
        this.algoliaClient = algoliasearch(
            yepcode.env.ALGOLIA_APP_ID,
            yepcode.env.ALGOLIA_API_KEY
        );

        // TODO: Customize your index name
        this.algoliaIndex = this.algoliaClient.initIndex("your-algolia-index-name");

        this.objectsToSave = [];
    }
    async consume(item) {
        // TODO: Build your objects to be saved. More info at https://www.algolia.com/doc/api-reference/api-methods/save-objects/
        this.objectsToSave.push(item);
    }

    async close() {
        // We save all the objects in one operation to take advance of performance beneficts that algolia client includes
        // More info at https://www.algolia.com/doc/api-reference/api-methods/save-objects/
        await this.algoliaIndex.saveObjects(this.objectsToSave);
    }
}