Validate the Snowflake connection and activate it for use in meters

1. (Optional) Under Test Query, you can enter a sample SELECT query to confirm Zuora can access your data.

   SELECT 1;

   SELECT COUNT(*) FROM MY_DB.MY_SCHEMA.MY_TABLE;

2. Click Validate.
   If validation succeeds, a Validation Successful message appears.

   When you click Validate, Zuora establishes a JDBC connection to your Snowflake account and checks that the Account URL is a valid Snowflake hostname (for example, *.snowflakecomputing.com or *.snowflakecomputing.cn) rather than a JDBC URL. If the hostname or authentication details are invalid, validation fails and the connection is not activated.

   Note: The Snowflake account will be locked after multiple invalid validation attempts.
3. Click Activate Connection to activate the Snowflake connection