Insert Single Row - Pipedream

import snowflake from "../../snowflake.app.mjs"; export default { type: "action", key: "snowflake-insert-row", name: "Insert Single Row", description: "Insert a row into a table", version: "1.1.2", props: { snowflake, database: { propDefinition: [ snowflake, "database", ], }, schema: { propDefinition: [ snowflake, "schema", (c) => ({ database: c.database, }), ], }, tableName: { propDefinition: [ snowflake, "tableName", (c) => ({ database: c.database, schema: c.schema, }), ], description: "The table where you want to add a new row", reloadProps: true, }, }, async additionalProps() { const props = {}; // Once a user selects the table, display the columns as additional props if (this.tableName) { const fields = await this.snowflake.listFieldsForTable(this.tableName); const defaultValue = {}; for (const field of fields) { defaultValue[field.name] = ""; } props["values"] = { type: "object", label: "Values", description: "Enter the values for each column", default: defaultValue, }; } return props; }, async run({ $ }) { const response = await this.snowflake.insertRow(this.tableName, this.values); $.export("$summary", `Successfully inserted row in ${this.tableName}`); return response; }, };

Label	Prop	Type	Description
Snowflake	`snowflake`	`app`	This component uses the Snowflake app.
Database	`database`	`string`	Select a value from the drop down menu.
Schema	`schema`	`string`	Select a value from the drop down menu.
Table Name	`tableName`	`string`	Select a value from the drop down menu.

Label

Prop

Type

Description

Snowflake

snowflake

app

This component uses the Snowflake app.

Database

database

string

Select a value from the drop down menu.

Schema

schema

string

Select a value from the drop down menu.

Table Name

tableName

string

Select a value from the drop down menu.

Snowflake uses API keys for authentication. When you connect your Snowflake account, Pipedream securely stores the keys so you can easily authenticate to Snowflake APIs in both code and no-code steps.

Snowflake recommends you create a new user, role, and warehouse when you integrate a third-party tool like Pipedream. This way, you can control permissions via the user / role, and separate Pipedream compute and costs with the warehouse. You can do this directly in the Snowflake UI.

We recommend you create a read-only account if you only need to query Snowflake. If you need to insert data into Snowflake, add permissions on the appropriate objects after you create your user.

Insert Single Row with Snowflake API

Pipedream makes it easy to connect APIs for Snowflake and 2,400+ other apps remarkably fast.

Trusted by 1,000,000+ developers from startups to Fortune 500 companies

Developers ♥ Pipedream

Getting Started#

Integrations#

Details#

Code#

Configuration#

Authentication#

About Snowflake#

More Ways to Use Snowflake#

Triggers#

Actions#

Explore Other Apps#

1
-
24
of
2,400+
apps by most popular

Insert Single Row with Snowflake API

Pipedream makes it easy to connect APIs for Snowflake and 2,400+ other apps remarkably fast.

Trusted by 1,000,000+ developers from startups to Fortune 500 companies

Developers ♥ Pipedream

1-24of2,400+apps by most popular

1
-
24
of
2,400+
apps by most popular