Validate the Snowflake connection and activate it for use in meters
This step verifies your Snowflake connection and S3 data path. You can optionally provide a test query.
(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;
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.
Click Activate Connection to activate the Snowflake connection
The connection is now active and available for selection in Mediation meters.
