home

Zuora Platform

Zuora BillingZuora PaymentsZuora PlatformZuora CPQZephrZuora RevenueAccounts ReceivableRelease NotesBasicsEntitlementsSupport and policies
Zuora BillingZuora PaymentsZuora PlatformZuora CPQZephrZuora RevenueAccounts ReceivableRelease NotesBasicsEntitlementsSupport and policies

Welcome to Zuora Product Documentation

Explore our rich library of product information

Show Contents

thumbnailZuora Platform

Manage connections in meters

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.

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, optionally using a single Snowflake stage.

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

Last updated: April 20, 2026