Configure Snowflake Stored Procedures Collector

in this tutorial, we'll guide you through the essential steps to effectively set up and configure observability for snowflake stored procedures this involves establishing connections to snowflake, configuring the collector for stored procedure data, to ensure you can monitor, collect, and analyze the operations and impacts of these procedures you will need to go through 2 steps 1 set up snowflake connection (estimated task time 3 minutes) 2 configuration of the stored procedures collector (estimated task time 1 minute) prerequisites before you begin configuring the collector for snowflake stored procedures, ensure you have the following a snowflake account with administrator access or specific roles granted the necessary permissions to access system tables (account usage query history, account usage access history) configuration setting up the connection the first step consist in creating a snowflake connection with the account credentials mentioned in the prerequistes you can do this by following this snowflake docid\ ojharjtq6htyg8q24uf9o configure the collector 1\ navigate to the kensu hub panel within the data applications collectors, locate the snowflake stored procedures one and click on configure 2\ navigate to the configuration panel within the kensu hub components collector snowflake historical cell, click on configure 3\ click on the + icon this action will generate a new configuration file 4\ you can now edit the configuration, by adding in the specified section, choose the appropriate kensu and snowflake connections for this configuration you can select the default kensu connection or create your own you can identify the collector by adding a specific identifier in the id field all the other fields can be left blank 5\ click on submit all congratulations! you've successfully set up the collector it will be activated shortly, and you will begin monitoring your stored procedures in snowflake