Comment on page
Snowflake Action Agent
This example Data Stream demonstrates how to use the Action Agent to write order data to an existing table in a Snowflake database.
Drag the Snowflake Action Agent onto the canvas and rename it. Link the input endpoint to the order data and the output to the printer. Save the Data Stream.
Select the Agent and click Configure. In this case, use the default Collection.
Enter the authentication details of the Snowflake account to which you want to connect: organization, account, user name, and password.
Select the database, schema (optional), and table. In this case, set the database to MYDB, the schema to MYSCHEMA, and the table to Orders. Apply the changes.
You could tick Use Stored Procedure to execute a stored procedure rather than a basic table insert.
Select the Snowflake Action Agent's input arrow and click Configure. Map one of the parent Agent's output attributes to each input attribute, which is fetched from the Snowflake table.
In this case, click Auto Map as the attribute names and data types are the same.
Apply the changes, save the Data Stream and publish it.
Let's look at the Live Data View. Observe the order data is printed.
Next, go into your Snowflake account and select Data Preview for the Orders Table in the MYDB database and MYSCHEMA schema. Observe the order data has also been written to the Orders table in the Snowflake database.