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

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

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.

Download

Last updated