Configuration

Action Agent Configuration

This section explains each of the properties in the configuration blade.
General
Text
Description
Collection
This associates the Agent to a specific Collection and defaults to that of the current Data Stream.
Polling Interval (seconds)
A timespan to specify how often should the Agent check for new data/changes or update its cache.
Server
Properties
Description
Use Connection Variables
Tick to select saved variables; or enter the text manually for the authentication properties. (Defaults to ticked on first use)
Organization
The organization name of the Snowflake account to which you are connecting.
Account
The account name of the Snowflake account to which you are connecting.
User Name
The user name to use for authenticating the connection.
Password
The password to use for authenticating the connection.
Once all the Server properties are entered, the Agent will attempt to open a connection with the Snowflake account. If successful, the Database property is populated with a list of available databases.
Database
Properties
Description
Database
The name of the database to connect to in Snowflake. 
Schema
The name of the schema to use within the selected database.
Command Timeout
The number of seconds to timeout a non-completing call to Snowflake.
Use Stored Procedure
Tick to execute a stored procedure; or select a table in which to insert.
Table
The name of the table in which to insert (applies when Use Stored Procedure is not ticked).
Stored Procedure
The stored procedure to execute (applies when Use Stored Procedure is ticked).
Return Results As
Choose whether the stored procedure results should be:
appended to the input data (Append To Current) or
replace the input data as a new output payload (As New). 
Applies when Use Stored Procedure is ticked.
Before configuring the  Action Agent, please ensure that its input endpoint is connected to a parent Agent which will be sending data to it.
Input Mapping
The appropriate column or attribute of the input payload is mapped to either the table attributes or stored procedure parameters, which are fetched from the Snowflake database.
Refer to Setup Input Mappings for step-by-step instructions.
Endpoints 
Name
Description
Input
This endpoint is used to receive data from the parent Agent.
Output
Events received from the parent Agent are processed and made available to this endpoint either unchanged for table inserts - or according to the Return Results As property for stored procedure execution.
Error
Errors encountered during the execution of this Agent will be published on this Endpoint.

Text	Description
Collection	This associates the Agent to a specific Collection and defaults to that of the current Data Stream.
Polling Interval (seconds)	A timespan to specify how often should the Agent check for new data/changes or update its cache.

Properties	Description
Use Connection Variables	Tick to select saved variables; or enter the text manually for the authentication properties. (Defaults to ticked on first use)
Organization	The organization name of the Snowflake account to which you are connecting.
Account	The account name of the Snowflake account to which you are connecting.
User Name	The user name to use for authenticating the connection.
Password	The password to use for authenticating the connection.

Properties	Description
Database	The name of the database to connect to in Snowflake.
Schema	The name of the schema to use within the selected database.
Command Timeout	The number of seconds to timeout a non-completing call to Snowflake.
Use Stored Procedure	Tick to execute a stored procedure; or select a table in which to insert.
Table	The name of the table in which to insert (applies when Use Stored Procedure is not ticked).
Stored Procedure	The stored procedure to execute (applies when Use Stored Procedure is ticked).
Return Results As	Choose whether the stored procedure results should be: appended to the input data (Append To Current) or replace the input data as a new output payload (As New). Applies when Use Stored Procedure is ticked.

Name	Description
Input	This endpoint is used to receive data from the parent Agent.
Output	Events received from the parent Agent are processed and made available to this endpoint either unchanged for table inserts - or according to the Return Results As property for stored procedure execution.
Error	Errors encountered during the execution of this Agent will be published on this Endpoint.

Action Agent - Previous

Example

Next - Action Agent

Release Notes

Last modified 1yr ago