Skip to main content

Snowflake

Snowflake is a cloud data platform that provides a data warehouse-as-a-service designed for the cloud.

!!! note "Credentials" You can find authentication information for this node here.

Basic Operations​

  • Execute an SQL query.
  • Insert rows in database.
  • Update rows in database.

Example Usage​

1. Start node​

The start node exists by default when you create a new workflow.

2. Snowflake node (Execute Query)​

This node will create a table named docs with id and name columns.

  1. First of all, you'll have to enter credentials for the Snowflake node. You can find out how to do that here.
  2. Select 'Execute Query' from the Operation dropdown list.
  3. Enter the following SQL query in the Query field: CREATE TABLE docs (id INT, name STRING);.
  4. Click on Execute Node to run the node.

3. Set node​

We will use the Set node to set the values for the id and name columns for a new record.

  1. Click on the Add Value button and select 'Number' from the dropdown list.
  2. Enter id in the Name field.
  3. Enter an id in the Value field.
  4. Click on the Add Value button and select 'String' from the dropdown list.
  5. Enter name in the Name field.
  6. Enter the value for the name in the Value field.
  7. Toggle Keep Only Set to true. We set this option to true to ensure that only the data that we have set in this node get passed on to the next nodes in the workflow.
  8. Click on Execute Node to run the node.

4. Snowflake1 node (Insert)​

This node will insert the data that we set in the previous node into the docs table in Snowflake.

  1. Select the credentials that you entered in the previous Snowflake node.
  2. Enter docs in the Table field.
  3. Enter id, name in the Columns field.
  4. Click on Execute Node to run the node.

5. Set1 node​

We will use the Set node to ensure that only the data that we set in this node gets passed on to the next nodes in the workflow. We will set the value of name in this node.

  1. Click on the Add Value button and select 'Number' from the dropdown list.
  2. Enter id in the Name field.
  3. Enter 1 in the Value field.
  4. Click on the Add Value button and select 'String' from the dropdown list.
  5. Enter name in the Name field.
  6. Enter nodemation in the Value field.
  7. Toggle Keep Only Set to true. We set this option to true to ensure that only the data that we have set in this node get passed on to the next nodes in the workflow.
  8. Click on Execute Node to run the node.

6. Snowflake2 node (Update)​

This node will update the value of the name column for the id 1.

  1. Select the credentials that you entered in the previous Snowflake node.
  2. Select 'Update' from the Operation dropdown list.
  3. Click on the gears icon next to the Table field and click on Add Expression.
  4. Select the following in the Variable Selector section: Nodes > Snowflake1 > Parameters > table. You can also add the following expression: {{$node["Snowflake1"].parameter["table"]}}.
  5. Enter name in the Columns field.
  6. Click on Execute Node to run the node.