Skip to navigation
ExtensibilityMediationManage connections in metersCreate Snowflake connections in meters

Validate and activate the Snowflake connection

View as Markdown

Validate the Snowflake connection and activate it for use in meters

This step verifies your Snowflake connection and the source and sink S3 paths used by Mediation. The validation checks whether Mediation can connect to Snowflake and access the configured S3 location.

You can optionally provide a test query to confirm that Mediation can access your Snowflake data.

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.

The Snowflake account will be locked after multiple invalid validation attempts.

3

Click Activate Connection to activate the Snowflake connection

The connection is now active and available for selection in Mediation meters.

If validation fails, verify the following items:

  • The Snowflake user has the required privileges on the warehouse, database, schema, and tables.
  • The storage integration allowlist contains the exact sourceRootDir and sinkRootDir values displayed in the connection wizard.
  • The source and sink stages, if used, point to those exact paths.
  • The Snowflake configuration allows the load or unload operation required by the selected setup option.

Do not replace the tenant-specific paths with a shared exports/ path.