Connect Google BigTable and Airtable in our serverless environment

class GoogleBigtableSourceGetRows {
    async init() {
        // More info at https://www.npmjs.com/package/@google-cloud/bigtable
        // TODO: Create team variables. More info at https://yepcode.io/docs/processes/team-variables
        this.googleBigTable = new Bigtable({
            projectId: yepcode.env.GOOGLE_BIGTABLE_PROJECT_ID,
            credentials: JSON.parse(yepcode.env.GOOGLE_BIGTABLE_SERVICE_ACCOUNT_JSON),
        });
        // TODO: Customize your instance and table names
        this.table = await this.googleBigTable
            .instance("your-instance-name")
            .table("your-table-name");
    }

    async fetch(publish, done) {
        // You can customize get options. eg: get matching keys
        // Look at: https://cloud.google.com/nodejs/docs/reference/bigtable/latest/bigtable/getrowsoptions
        const getRowsOptions = {};
        const [rows] = await this.table.getRows(getRowsOptions);

        for (const rowResponse of rows) {
            const [row] = await rowResponse.get();
            const item = this._mapRowToItem(row);
            await publish(item);
        }
        done();
    }

    _mapRowToItem(row) {
        const columnsAndLastValue = Object.entries(row.data).map(
            ([columnName, columnContent]) => [
                columnName,
                this._getLastColumnValue(columnContent),
            ]
        );
        return Object.fromEntries(columnsAndLastValue);
    }

    _getLastColumnValue(columnContent) {
        // The second [0] is to access the last value
        // You can access previous values by accessing the next
        // elements in the list
        return columnContent[0][0].value;
    }

    async close() {}
}

class AirtableTargetCreateRecords {
    async init() {
        // More info at https://www.npmjs.com/package/airtable
        this.airtableClient = new Airtable({
            // TODO: Create a team variable. More info at https://yepcode.io/docs/processes/team-variables
            apiKey: yepcode.env.AIRTABLE_API_KEY,
        });

        // TODO: Customize your base id and table id
        // More info at https://support.airtable.com/docs/understanding-airtable-ids
        this.table = this.airtableClient
            .base("your-base-id")
            .table("your-table-id");
    }
    async consume(item) {
        await this.table.create({
            // TODO: Customize item attributes mapping to record columns
            id: `${item.id}`,
            name: item.name,
        });
    }

    async close() {}
}