Snowflake

A data warehouse built for the cloud

Integrate the Snowflake API with the Telegram Bot API

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

Create Chat Invite Link with Telegram Bot API on New Row from Snowflake API
Snowflake + Telegram Bot
 
Try it
Create Chat Invite Link with Telegram Bot API on Query Results from Snowflake API
Snowflake + Telegram Bot
 
Try it
Delete a Message with Telegram Bot API on New Row from Snowflake API
Snowflake + Telegram Bot
 
Try it
Delete a Message with Telegram Bot API on Query Results from Snowflake API
Snowflake + Telegram Bot
 
Try it
Edit a Media Message with Telegram Bot API on New Row from Snowflake API
Snowflake + Telegram Bot
 
Try it
New Query Results from the Snowflake API

Emit new event with the results of an arbitrary query

 
Try it
New Row from the Snowflake API

Emit new event when a row is added to a table

 
Try it
New Channel Updates (Instant) from the Telegram Bot API

Emit new event each time a channel post is created or updated.

 
Try it
New Message Updates (Instant) from the Telegram Bot API

Emit new event each time a Telegram message is created or updated.

 
Try it
New Updates (Instant) from the Telegram Bot API

Emit new event for each new Telegram event.

 
Try it
Insert Row with the Snowflake API

Insert a row into a table

 
Try it
Create Chat Invite Link with the Telegram Bot API

Create an additional invite link for a chat, See the docs for more information

 
Try it
Delete a Message with the Telegram Bot API

Deletes a message. See the docs for more information

 
Try it
Edit a Media Message with the Telegram Bot API

Edits photo or video messages. See the docs for more information

 
Try it
Edit a Text Message with the Telegram Bot API

Edits text or game messages. See the docs for more information

 
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}`)
    }
  },
})

Connect Telegram Bot

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    telegram_bot_api: {
      type: "app",
      app: "telegram_bot_api",
    }
  },
  async run({steps, $}) {
    return await axios($, {
      url: `https://api.telegram.org/bot${this.telegram_bot_api.$auth.token}/getMe`,
    })
  },
})