Snowflake

A data warehouse built for the cloud

Integrate the Snowflake API with the Schedule API

Setup the Snowflake API trigger to run a workflow which integrates with the Schedule API. Pipedream's integration platform allows you to integrate Snowflake and Schedule remarkably fast. Free for developers.

Insert Row with Snowflake API on Custom Interval from Schedule API
Schedule + Snowflake
 
Try it
Insert Row with Snowflake API on Daily schedule from Schedule API
Schedule + Snowflake
 
Try it
Insert Row with Snowflake API on Monthly Schedule from Schedule API
Schedule + Snowflake
 
Try it
Insert Row with Snowflake API on Weekly schedule from Schedule API
Schedule + Snowflake
 
Try it
Custom Interval from the Schedule API

Trigger your workflow every N hours, minutes or seconds.

 
Try it
New Query Results from the Snowflake API

Emit new event with the results of an arbitrary query

 
Try it
Daily schedule from the Schedule API

Trigger your workflow every day.

 
Try it
New Row from the Snowflake API

Emit new event when a row is added to a table

 
Try it
Monthly Schedule from the Schedule API

Trigger your workflow on one or more days each month at a specific time (with timezone support).

 
Try it
Insert Row with the Snowflake API

Insert a row into a table

 
Try it

Connect Snowflake

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
module.exports = defineComponent({
  props: {
    snowflake: {
      type: "app",
      app: "snowflake",
    }
  },
  async run({steps, $}) {
    // Example query
    const sqlText = `SELECT CURRENT_TIMESTAMP();`
    
    const { promisify } = require('util')
    const snowflake = require('snowflake-sdk')
    
    const connection = snowflake.createConnection(this.snowflake.$auth)
    
    const connectAsync = promisify(connection.connect)
    
    try {
      await connectAsync()
    } catch (err) {
      console.error('Unable to connect: ' + err.message)
    }
    
    // util.promisify requires the last argument of the function you pass to 
    // it be the callback function, according to Node convention — see the docs at
    // https://nodejs.org/dist/latest-v8.x/docs/api/util.html#util_util_promisify_original .
    // Since Snowflake's connection.execute function accepts a single argument — 
    // options, an object — using promisify won't work. So we wrap the callback 
    // with a Promise and await it below.
    //
    // Pass the same options object (e.g. sqlText, binds), _except_ for the callback
    // parameter. Instead, you'll want to await the result, which contains the 
    // stmt and rows object the callback version of the function passes, using 
    // a catch block to catch any errors, e.g.
    //
    //   try {
    //     const { stmt, rows } = await connExecuteAsync({
    //       sqlText: `insert into your_table select parse_json('{"foo": "bar"}')`,
    //     })
    //   } catch (err) {
    //     console.error(`Failed to execute statement due to the following error: ${err.message}`)
    //   }
    //
    async function connExecuteAsync(options) {
      return new Promise((resolve, reject) => {
        const statement = connection.execute({
          ...options,
          complete: function(err, stmt, rows) {
            if (err) {
              reject(err)
            } else {
              resolve({stmt, rows})
            }
          }
        })
      })
    }
    
    try {
      const { stmt, rows } = await connExecuteAsync({
        sqlText,
        fetchAsString: ['Number', 'Date'],
      })
      console.log(JSON.stringify(rows, null, 2))
    } catch (err) {
      console.error(`Failed to execute statement due to the following error: ${err.message}`)
    }
  },
})