Integrate the DigitalOcean Spaces API with the Snowflake API

import { S3 } from "@aws-sdk/client-s3";
import { ListBucketsCommand  } from "@aws-sdk/client-s3";

export default defineComponent({
  props: {
    digitalocean_spaces: {
      type: "app",
      app: "digitalocean_spaces"
    }
  },
  async run({ steps, $ }) {
    console.log(this.digitalocean_spaces.$auth)
    const s3Client = new S3({
        forcePathStyle: false, // Configures to use subdomain/virtual calling format.
        endpoint: `https://${this.digitalocean_spaces.$auth.region}.digitaloceanspaces.com`,
        region: "us-east-1",
        credentials: {
          accessKeyId: this.digitalocean_spaces.$auth.key,
          secretAccessKey: this.digitalocean_spaces.$auth.secret
        }
    });

    const data = await s3Client.send(new ListBucketsCommand({}));
    return data.Buckets;
  },
})

import { promisify } from 'util'
import snowflake from 'snowflake-sdk'

export default defineComponent({
  props: {
    snowflake: {
      type: "app",
      app: "snowflake",
    }
  },
  async run({steps, $}) {
    const connection = snowflake.createConnection({
      ...this.snowflake.$auth,
      application: "PIPEDREAM_PIPEDREAM",
    })
    const connectAsync = promisify(connection.connect)
    await connectAsync()
    
    async function connExecuteAsync(options) {
      return new Promise((resolve, reject) => {
        connection.execute({
          ...options,
          complete: function(err, stmt, rows) {
            if (err) {
              reject(err)
            } else {
              resolve({stmt, rows})
            }
          }
        })
      })
    }
    
    // See https://docs.snowflake.com/en/user-guide/nodejs-driver-use.html#executing-statements
    const { rows } = await connExecuteAsync({
      sqlText: `SELECT CURRENT_TIMESTAMP()`,
    })
    return rows
  },
})