Query PostgreSQL on a schedule
@dylburger
code:
data:privatelast updated:4 years ago
today
Build integrations remarkably fast!
You're viewing a public workflow template.
Sign up to customize, add steps, modify code and more.
Join 800,000+ developers using the Pipedream platform
steps.
trigger
Cron Scheduler
Deploy to configure a custom schedule
This workflow runs on Pipedream's servers and is triggered on a custom schedule.
steps.
run_sql_query
auth
to use OAuth tokens and API keys in code via theauths object
code
Write any Node.jscodeand use anynpm package. You can alsoexport datafor use in later steps via return or this.key = 'value', pass input data to your code viaparams, and maintain state across executions with$checkpoint.
async (event, steps) => {
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
}
21
  const { Client } = require('pg')

  // The client will use environment variables to connect.
  // See https://node-postgres.com/features/connecting.
  // 
  // You'll need to add Pipedream environment variables
  // for PGUSER, PGHOST, and PGPASSWORD at the very least.
  // See https://docs.pipedream.com/environment-variables/
  const client = new Client()
  await client.connect()

  // I run a mock query below, but you can replace that
  // with any query you'd like
  const { rows } = await client.query('SELECT NOW()')
  for (row of rows) {
    console.log(row)
  }

  await client.end()