Send data to Snowflake
•@dylburger•
•code:
•data:private•last 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 API
Deploy to generate unique URL
This workflow runs on Pipedream's servers and is triggered by HTTP / Webhook requests.
steps.
snowflake
auth
to use OAuth tokens and API keys in code via the
auths object(auths.snowflake)
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, auths) => {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
const {
user,
private_key,
database,
schema,
stage_name,
pipe_name,
account,
host,
} = auths.snowflake
// Send a test record to Snowflake. You can modify the payload
// field to send any data you'd like. For example, if you're using
// an HTTP trigger and want to send the request payload, use event.body
// See https://docs.pipedream.com/workflows/events/#event-format
$send.snowflake({
user,
private_key,
database,
schema,
stage_name,
pipe_name,
account,
host: `${account}.snowflakecomputing.com`,
payload: { test: "This is from Pipedream" }
})