Example

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.

Refer to configuration to understand all configuration options of this Agent.

Step 1: Add the Agent

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.

Step 2: Configure General

Select the Agent and click Configure. In this case, use the default Collection.

Step 3: Configure Server

Enter the authentication details of the Snowflake account to which you want to connect: organization, account, user name, and password.

Step 4: Configure Database

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.

Step 5: Input Mapping

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.

Step 6: Results

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.

Files

File	Link	Security Key
Data Stream	Snowflake Action Agent Example.xuc	C0mp|ex123
Sample Data	Orders1K.csv
Table Script	SnowflakeOrdersTable.txt

See the Import, Export, and Clone - XMPro article for steps to import a Data Stream.