Configure Zuora-managed S3 for Snowflake (Credentials)

Use the Zuora Managed S3 setup using the Credentials option when you want the simplest Snowflake setup.

With the Credentials option, you rely on Zuora-managed S3 without creating a dedicated Snowflake storage integration, so you only need to whitelist the Zuora S3 path and optionally create a stage. This reduces Snowflake configuration work while still letting Mediation read from and write to Snowflake securely.

A Snowflake stage is a named object that points to an external location (such as an S3 bucket) and is used as a landing zone for load and unload operations. Creating a stage is optional in this flow, but it gives your Snowflake team a single object to grant, audit, and reuse whenever Mediation accesses Zuora-managed S3.

On the Setup step of the wizard, under Choose Setup Option, select Credentials.

Expand the Credentials Setup Instructions and complete the Snowflake-side configuration as described.

Use the exact source and sink paths displayed in the Credentials Setup Instructions to configure Snowflake access. These paths are specific to your environment and tenant. Do not use a shared Zuora S3 path.

(Optional) Create separate Snowflake stages for the source and sink paths. Use the exact values displayed in the Credentials Setup Instructions.

Source path

<sourceRootDir>

Sink path

<sinkRootDir>

CREATE STAGE <source_stage>
  URL = '<sourceRootDir>';
CREATE STAGE <sink_stage>
  URL = '<sinkRootDir>';

The sourceRootDir and sinkRootDir values are tenant- and environment-specific. Copy the values from the wizard instead of constructing them manually. Snowflake network policies control client IP access and do not allowlist S3 locations.

Grant usage on both stages to the Snowflake role:

GRANT USAGE ON STAGE <source_stage> TO ROLE <ROLE_NAME>;
GRANT USAGE ON STAGE <sink_stage> TO ROLE <ROLE_NAME>;

The source stage is used for data that Mediation reads from Snowflake. The sink stage is used for data that Mediation writes to Snowflake.

At the bottom of the Setup page, select the checkbox I have completed the required setup in Snowflake.

Review the Snowflake User & Role Grants section if needed, then click Continue to move to the Validate step.