> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://zuora.ferndocs.com/docs/platform/extensibility/mediation/manage-connections-in-meters/create-snowflake-connections-in-meters/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://zuora.ferndocs.com/_mcp/server.

# Create Snowflake connections in meters

> Use Snowflake connections to let Mediation connect to a Snowflake account that can be used as a source or target in meters.

Use Snowflake connections to let Mediation connect to a Snowflake account that can be used as a source or target in meters.

The connection stores the Snowflake account URL, authentication method, and Zuora-managed S3 setup so it can be reused across multiple meters.

Snowflake connections allow meters to read from and write to your Snowflake data warehouse. Data transfer between Snowflake and the meter pipeline occurs through a Zuora-managed S3 staging area using Snowflake's COPY INTO and UNLOAD commands for load and unload operations.

When you use Snowflake as a source, Zuora unloads data from Snowflake into a Zuora-managed S3 staging area, then reads it into the meter pipeline. When you use Snowflake as a sink, the meter pipeline writes output to Zuora-managed S3 and then loads it into your Snowflake table.

## Prerequisites

Before you create a Snowflake connection:

* Snowflake must be enabled for your tenant.
* You must have a dedicated Snowflake user and role for Mediation, including permissions to use the storage integration, warehouse, database, schema, and target objects that Mediation will access.
* You must be able to create a Snowflake storage integration and, if required, Snowflake stages that point to Zuora-managed S3 locations.
* Zuora-managed connections are not supported for Snowflake. You must provide your own Snowflake account credentials for the connection.

## Procedure

To create a Snowflake connection in Mediation, complete the Create New Connection wizard in this order:

1. Define the Snowflake connection – Open Manage Connections, start a new connection, and enter the basic Snowflake details (connection name, account URL, username).
2. Configure Snowflake authentication – Choose and configure the authentication method (key pair or password), and optionally set advanced query history.
3. Configure Zuora-managed S3 for Snowflake – Choose one of the following S3 setup options, based on how your Snowflake team manages external access:

   * Credentials – Simplest path; rely on Zuora-managed S3 without a dedicated storage integration. You can optionally create separate Snowflake stages for the source and sink paths shown in the setup instructions.
   * Storage Integration, Inline – Use a Snowflake storage integration with inline S3 URLs, without separate stages for each flow.
   * Storage Integration, Stage – Use a storage integration plus named source and sink stages for all data load/unload.
4. Validate and activate the Snowflake connection – Run a validation test and then activate the connection so it can be selected in meters.

> Use Snowflake connections to let Mediation connect to a Snowflake account that can be used as a source or target in meters.

## Docs

- [Prepare a Snowflake user and role for Mediation](https://zuora.ferndocs.com/docs/platform/extensibility/mediation/manage-connections-in-meters/create-snowflake-connections-in-meters/prepare-a-snowflake-user-and-role-for-mediation.md): Before using Snowflake with Mediation, create a dedicated Snowflake user and assign a default role with the required privileges.
- [Define the Snowflake connection](https://zuora.ferndocs.com/docs/platform/extensibility/mediation/manage-connections-in-meters/create-snowflake-connections-in-meters/snowflake-define-connection.md): Define a Snowflake connection in Mediation to enable Zuora-managed access to your Snowflake account.
- [Configure Snowflake authentication](https://zuora.ferndocs.com/docs/platform/extensibility/mediation/manage-connections-in-meters/create-snowflake-connections-in-meters/configure-snowflake-authentication.md): Snowflake connections support password-based authentication and key-pair authentication. On the Authentication step of the wizard, configure one of the authentication options.
- [Configure Zuora-managed S3 for Snowflake (Credentials)](https://zuora.ferndocs.com/docs/platform/extensibility/mediation/manage-connections-in-meters/create-snowflake-connections-in-meters/config-snowflake-creds.md): Use the Zuora Managed S3 setup using the Credentials option when you want the simplest Snowflake setup.
- [Configure Zuora-managed S3 for Snowflake (Storage Integration, Inline)](https://zuora.ferndocs.com/docs/platform/extensibility/mediation/manage-connections-in-meters/create-snowflake-connections-in-meters/config-snowflake-storage-int-inline.md): Use these steps when your Snowflake environment uses a storage integration to control access to external S3 locations, but you do not need separate stages for every data flow.
- [Configure Zuora-managed S3 for Snowflake (Storage Integration, Stage)](https://zuora.ferndocs.com/docs/platform/extensibility/mediation/manage-connections-in-meters/create-snowflake-connections-in-meters/config-snowflake-storage-int-stage.md): Use these steps your Snowflake standards require all external data access to go through named stages.
- [Validate and activate the Snowflake connection](https://zuora.ferndocs.com/docs/platform/extensibility/mediation/manage-connections-in-meters/create-snowflake-connections-in-meters/validate-snowflake-connection.md): Validate the Snowflake connection and activate it for use in meters