This example Data Stream demonstrates how to use the Context Provider to return contextual data from a Snowflake database.
Drag the Snowflake Context Provider 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.
No limit, filter, or sort is applied in this example. Refer to configuration for further details on these properties.
Apply the changes and save the Data Stream.
Publish it and let's look at the Live Data View. Observe that all rows from the Snowflake table that fit the limit, filter, and sort criteria are printed.
Snowflake CP Example.xuc