Troubleshooting

No data appears in the dashboard

Check the following:

1. Confirm PerfScope has the required privileges.
2. Confirm the assigned warehouse exists and can resume.
3. Confirm your selected time range contains query activity.
4. Confirm that Snowflake's relevant system metadata is available to the application.

Snowflake system views can have ingestion latency, so very recent activity may not immediately appear.

Recent queries are missing

Some Snowflake system metadata is not real-time. Allow for the documented latency of the underlying Snowflake views used by the app.

Historical queries are missing

The amount of historical query data available depends on Snowflake's retention for the metadata source used by PerfScope.

If the requested date range exceeds the available history, older queries will not be returned.

PerfScope feels slow

Try the following:

• Narrow the selected time range.
• Filter to one or more relevant warehouses.
• Use a larger virtual warehouse for PerfScope.
• Reduce the number of query records being analyzed simultaneously.

Warehouse error

If PerfScope cannot use the selected warehouse:

1. Confirm the warehouse name.
2. Confirm the warehouse has not been dropped.
3. Verify the application has the required warehouse privilege.
4. Confirm the warehouse can auto-resume or manually resume it.

Permission error

Ask a Snowflake administrator to review the privileges granted to the application and compare them with the privileges requested by PerfScope during installation.