Save sample data to a table in the Pipedream Data Warehouse
@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
HTTP
steps.
send_to_pipedream_data_warehouse
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
// $send.sql() saves any JavaScript object to the Pipedream Data Warehouse.
// We automatically create the table and manage the schema based on the data
// you send. Data is saved for 30 days, and you can query it for free at
// https://pipedream.com/sql. Read more about the SQL service at
// https://docs.pipedream.com/destinations/sql/ .
$send.sql({
  table: "star_wars",
  payload: {
    name: "Leia Organa",
    forcePoints: 1000,
    title: "General",
    parents: {
      mother: "Padmé Amidala",
      father: "Anakin Skywalker",
    }
  },
})