Snowflake
The Snowflake Agents allow you to include data from a Snowflake database in your stream. For more information on Snowflake, please see the Snowflake Documentation site.
The Listener allows you to return new rows added to a Snowflake table. It operates on a timed interval and returns all new rows added to the table since the last interval. The following features are supported:
Username and password authentication
Reading from a table
The Context Provider allows you to read and output the entire contents of a Snowflake table to the Data Stream for contextual data. The following features are supported:
Username and password authentication
Reading from a table or custom query
Filtering and sorting of returned rows
Limiting returned rows by count or duration
Single-line comments (--) are supported from v2.01. On earlier versions, use block comments (/* ... */) instead.
The Reader is similar to the Context Provider but has the added capability to filter using dynamic input from the Data Stream. The following features are supported:
Username and password authentication
Reading from a table
Filtering and sorting of returned rows
Limiting returned rows by count or duration
The Action Agent allows you to execute a stored procedure or write Data Stream events to a Snowflake table. Bulk insert is not yet supported, so performance may be affected if many rows are inserted at once. The following features are supported:
Username and password authentication
Insert directly into a table, one row at a time
Execute a stored procedure to perform enhanced CRUD operations
Run a dynamic SELECT query
The Connector wraps the Snowflake Connector functionality, allowing you to process data on a Snowflake database as requested by an Application in App Designer via the XMPro Stream Connector.
Pre-requisites
Depending on how the Action Agent is configured, the Snowflake account credentials used must either have insert permission for the relevant table or execute permission for the stored procedure.
Current Version
Request the Snowflake Listener v2.00 (Last Update: 11 May 2026)
Request the Snowflake Context Provider v2.01 (Last Update: 27 Apr 2026)
Request the Snowflake Reader v2.10 (Last Update: 28 May 2026)
Request the Snowflake Action Agent v2.00 (Last Update: 11 May 2026)
Request the Snowflake Connector v1.21 (Last Update: 17 Mar 2026)
Listener Release Notes
2.00
11 May 2026
Support Event-Level Streaming (when using XMPro Platform v4.6+) for reduced memory usage and earlier downstream processing.
1.02
02 Sep 2025
Support variables for the database and schema names to remove changes on import to a new environment.
Support key-pair authentication for improved security and usability.
1.01
27 Dec 2024
Repackaged to translate the Agent's properties.
1.00
17 May 2022
Initial Release.
Context Provider Release Notes
2.01
27 Apr 2026
Fix single-line comments (--) in SQL queries being commented out at runtime, due to the agent replacing newlines with spaces.
Fix SQL queries failing when moved between Windows and Linux Stream Hosts, due to inconsistent newline handling across operating systems.
2.00
16 Apr 2026
Support Event-Level Streaming (when using XMPro Platform v4.6+) for reduced memory usage and earlier downstream processing.
1.04
05 Feb 2026
Fix downstream agents having an empty input payload when Columns To Return is blank.
1.03
25 Sep 2025
Fix 'missing required setting' error when variables are used even when the Organization is entered.
1.02
02 Sep 2025
Support variables for the database and schema names to remove changes on import to a new environment.
Support key-pair authentication for improved security and usability.
1.01
27 Dec 2024
Repackaged to translate the Agent's properties.
1.00
17 May 2022
Initial Release.
Reader (Action Agent) Release Notes
2.10
28 May 2026
Support executing a query supplied at runtime via the input payload so that query logic can be driven by upstream data rather than fixed at design time, returning results as a single JSON string.
2.00
11 May 2026
Support Event-Level Streaming (when using XMPro Platform v4.6+) for reduced memory usage and earlier downstream processing.
1.01
17 Apr 2026
Support OR filtering. Breaking change - configure the filter that replaced the grid.
1.00
26 Feb 2026
Initial Release.
Action Agent Release Notes
2.00
11 May 2026
Support Event-Level Streaming (when using XMPro Platform v4.6+) for reduced memory usage and earlier downstream processing.
1.05
02 Sep 2025
Support variables for the database and schema names to remove changes on import to a new environment.
Support key-pair authentication for improved security and usability.
1.04
27 Dec 2024
Repackaged to translate the Agent's properties.
1.00
13 Jul 2022
Initial Release.
Connector Release Notes
Last updated
Was this helpful?