Snowflake Data Load Test
Snowflake provides various options to the users to load data in cloud service. Users can opt for any of these mechanisms. The most important consideration would be safe and successful load without any data loss. Any issue during the load process can lead to loss of important data, the administrators might come to know about the same only when users report unavailability of data. The load process need to be monitored so that any lost data can be recovered in timely manner and users of the data get full dataset when required.
This test monitors the data loads and collects the statistics related to status of various data load streams into the cloud. Using these insights administrators can fix any issues and ensure load process is completed seamlessly.
Target of the test : Snowflake Database server
Agent deploying the test : A remote agent
Outputs of the test : One set of results for each Snowflake service account being monitored.
|
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. |
|
Measurement |
Description |
Measurement Unit |
Interpretation |
|---|---|---|---|
|
Total loads |
Indicates the total number of data loads initiated by using copy statement. |
Number |
|
|
Failed loads |
Indicates the total number of data loads by initiated by using copy statement, and have failed. |
Number |
A high value of this measure is the cause for concern. Detailed diagnosis of this measure will indicate error details. |
|
Partially loaded |
Indicates the total number of data loads by initiated by using copy statement, and have only partially loaded. |
Number |
|
|
Load in progress |
Indicates the total number of data loads by using snowpipes which are in progress. |
Number |
|
|
Total loads |
Indicates the total number of data loads by using snowpipes. |
Number |
|
|
Failed data loads |
Indicates the total number of failed loads using snowpipes. |
Number |
A high value of this measure is the cause for concern. Detailed diagnosis of this measure will indicate error details. |
|
Partially loaded |
Indicates the number of partial loads by using snowpipes. |
Number |
|
|
Skipped loads |
Indicates the number of skipped loads by using snowpipes. |
Number |
|
