Snowflake Replication Status Test

Snowflake allows the data to be replicated across databases, across regions, and even across accounts. Replication provides high availability of data and protects customer data against site failures and natural disasters.

The replication of data is resource consuming process and does have many points of failure where it can go wrong. It is important for administrators to be fully aware of status of replication process, so that they can ensure that data is replicated in timely manner and the expected level of robustness is maintained.

This test monitors the database replication process and collects statistics related to replication status, region, etc.

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 region 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 Name, Password and Confirm Password	In order to monitor a Snowflake account which hosts the Snowflake instances to be monitored, you need a special user with privileges of an account administrator who can access the Snowflake instances and execute the required commands to pull out the performance metrics. To know how to create such a user and assign a role, refer to Pre-requisites for Monitoring Snowflake. Specify credentials of such user in the User Name and Password text boxes. Confirm the password by retyping it in the Confirm Password text box.

Measurements made by the test

Measurement	Description	Measurement Unit	Interpretation
Is replication enabled?	Indicates for each database and each region, if replication is enabled.	Boolean
Is primary?	Indicates if the replication region is the primary region.	Boolean	If the region is primary, the detailed diagnosis will show the secondary region for the same.
Replication enabled regions	Indicates the number of secondary regions for the primary.	Number
Upload status	Indicates the transformation of bytes upload status.	String	Upload status will be any one of the following completed / canceled /f ailed.
Primary uploaded data	Indicates the total number of bytes copied so far in the primary region.	MB
Secondary downloaded data	Indicates the tables and table columns of the primary database that have been copied over to secondary region.	MB
Data lag	Indicates the maximum acceptable amount of data loss an application can undergo before causing measurable harm to the business.	MB
Data lag duration	Indicates how much downtime an application experiences before there is a measurable business loss.	Seconds	A low value is desired for this measure.