> This page is for Docs.

> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://zuora.ferndocs.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://zuora.ferndocs.com/_mcp/server.

# Validate and activate the Snowflake connection

> Validate the Snowflake connection and activate it for use in meters

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.

(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.

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.