Snowflake Tasks Test

A task can execute a single SQL statement or a call to a stored procedure. Tasks can also be used independently to generate periodic reports by inserting or merging rows into a report table or performing other periodic work. Most of the time tasks are created to perform some critical business function, and if task fails, the corresponding business function will be disrupted. That's the reason, administrators need to have a complete view of task status so that they are sure that all tasks have completed successfully and can also manage the task workload and load on compute resources.

This test monitors each database for tasks and collects the statistics related to the number and status of tasks scheduled on the Snowflake service.

Target of the test : Snowflake Database Server

Agent deploying the test : A remote agent

Outputs of the test : One set of results for each database present in the Snowflake service account being monitored.

Configurable parameters for the test

Parameter	Description
Test period	How often should the test be executed.
Host	The IP address of the Snowflake.
Port	The port number through which the snowflake database server communicates. The default port is 443.
Warehouse Name	In this text box, enter the name of a virtual warehouse that needs to be monitored.
Database Name	In this text box, enter the name of a default database that will connect the snowflake server.
User	Specify the name of the user who has any of the following privileges to the specified.
Password	The password of the specified USER.
Confirm Password	Confirm the password by retyping it here.

Measurements made by the test

Measurement	Description	Measurement Unit	Interpretation
Total tasks	Indicates the total number of tasks scheduled.	Number
Executing tasks	Indicates the total number of tasks in execution state during the last measurement period.	Number	Ideally, the value of this measure should be high.
Skipped tasks	Indicates the total number of tasks that were skipped.	Number
Succeeded tasks	Indicates the total number of tasks that were succeeded during the last measurement period.	Number
Failed tasks	Indicates the total number of tasks that were failed.	Number	Ideally, the value of this measure should be very low.
Canceled tasks	Indicates the total number of tasks that were canceled by the user.	Number
Scheduled tasks	Indicates the total number of scheduled tasks.	Number