Connect OpenAI prompt and Snowflake in our serverless environment

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

    async fetch(publish, done) {
        // TODO: Configure your prompt
        const funnyPrompts = [
            "What do you think of humans?",
            "Do you prefer tabs or spaces?",
            "What's the meaning of life, the universe, and everything?",
            "What's your favorite programming joke?",
            "What's the worst code you've ever seen?",
        ];
        // More info at: https://platform.openai.com/docs/api-reference/completions/create
        const completion = await this.openai.completions.create({
            model: "gpt-3.5-turbo",
            prompt: funnyPrompts,
            max_tokens: 7,
            temperature: 0,
        });

        for (const choice of completion.choices) {
            await publish(choice);
        }
        done();
    }

    async close() {}
}

class SnowflakeTargetInsert {
    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 consume(item) {
        await new Promise((resolve, reject) => {
            this.snowflake.execute({
                // TODO: Customize your SQL INSERT statement
                sqlText: "insert into YOUR_TABLE(ID, NAME) values(?, ?)",
                // TODO: Map item to any of the ? in insert sentence
                binds: [item.id, item.name],
                complete: (err, stmt, rows) => {
                    if (err) {
                        reject(err);
                        return;
                    }
                    resolve([stmt, rows]);
                },
            });
        });
    }

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