This example Data Stream demonstrates how to use the Listener to return data readings from a Snowflake database table.
Drag the Snowflake Listener onto the canvas and rename it. Link the output endpoint to the printer and save the Data Stream.
Select the Agent and click Configure. In this case, keep the default Collection and polling interval.
Enter the authentication details of the Snowflake account to which you want to connect: organization, account, username, and password.
Select the database.
Optionally, select a Schema, which will filter the options displayed in the Table dropdown.
Select the table.
Select which columns should be returned.
Select the column that is used to determine which rows are new since the last poll.
Apply the changes and save the Data Stream.
Publish it and let's look at the Live Data View. Observe that new rows are printed every 10 seconds - these are the rows that were added to the Snowflake table since the last poll.
Snowflake Listener Example.xuc