Configuring Snowflake Performance Investigator (PI)

Snowflake PI in Foglight serves the primary function of providing comprehensive monitoring and performance analysis capabilities for Snowflake database environments. It continuously monitors various performance metrics of Snowflake databases in near real-time (every 1 min), but can be configured to collect historic 1 minute segments on longer intervals to reduce warehouse credit usage. It collects data on metrics such as wait statistics, warehouse queue time, disk I/O, query execution times, and more.

Prerequisites for Monitoring Snowflake with the PI Agent

Prerequisites to monitor Snowflake PI:

1. Install a Snowflake agent from the Databases dashboard. For more information, refer to Installing and Configuring Agents
2. In order for the Snowflake PI agent to collect queries and lock information for all users in the account, the Snowflake user must have the ACCOUNTADMIN role.

Enabling Snowflake PI for an Agent

To enable Snowflake PI for an agent:

1. Click Databases in the left navigation pane.
2. On the Databases page, click on the Snowflake tile. The page displays a list of agent names along with their SQL PI activation status under the Monitoring Agent column.
3. Click Enable PI for the agent you want to activate PI. The Administration page for SQL Performance Investigator appears.
4. Click the checkbox against the agent name, and then click Enable.