ElectroNeek + Snowflake

Actions · 14

• Run Query

  Execute a SQL query against your Snowflake database and return the results as rows.

• Run Multiple Queries

  Execute multiple SQL statements in sequence against your Snowflake database. Optionally wrap them in a transaction so all changes are rolled

• Insert Row

  Insert a row into a table.

• Update Row

  Update one or more rows in a Snowflake table that match a WHERE condition.

• Delete Row

  Delete one or more rows from a Snowflake table that match a WHERE condition.

• Upsert Row

  Insert a new row or update an existing one if a row with the same match column value already exists (MERGE INTO).

• Insert Multiple Rows

  Insert multiple rows into a Snowflake table in a single operation.

• Get Row by ID

  Retrieve a single row from a Snowflake table by matching a column value.

• Search Rows

  Search for rows in a Snowflake table using an optional WHERE condition, ordering, and row limit.

• Get Table Schema

  Retrieve the column definitions (name, data type, nullability, default) for a Snowflake table.

• List Tables

  List all tables in a Snowflake schema.

• Execute Stored Procedure

  Call a stored procedure in Snowflake and return its result.

• Create / Refresh Dynamic Table

  Create or replace a Snowflake Dynamic Table that automatically refreshes based on a query. Dynamic Tables are a declarative way to define a

• Load Data from Stage

  Load data into a Snowflake table from a named internal or external stage using COPY INTO.

Triggers · 5

• New Row

  Triggers when a new row is inserted into the selected table. Uses a timestamp column you choose to detect rows added since the last check.

• New or Updated Row

  Triggers when a row is inserted or updated in the selected table. Uses an "updated at" timestamp column you choose — any row whose timestamp

• New Column

  Triggers when a new column is added to the selected table. Checked by polling every few minutes.

• New Table

  Triggers when a new table is created in the selected schema. Checked by polling every few minutes.

• New View

  Triggers when a new view is created in the selected schema. Checked by polling every few minutes.