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

# Configure Snowflake as a target

> Create a custom meter using a Snowflake data warehouse as the target by configuring connection, data upload, and advanced settings.

Create a custom meter using a Snowflake data warehouse as the target by configuring connection, data upload, and advanced settings.

Navigate to **Mediation** > **Meters**

Create a **Custom** meter.

Select **Snowflake** as the target. The Snowflake settings page is displayed.

![Snowflake target settings](/_fern-img/7e90c96b55c09d62bb5ff9758baf41b65d1bbcac9ca29644aad351fac202cd4b.webp)

Under the **Snowflake Settings** section, configure the following settings:

<table>
  <tr>
    <th>
      Setting
    </th>

    <th>
      Configuration
    </th>
  </tr>

  <tr>
    <td>
      **Connection**
    </td>

    <td>
      Select **Snowflake** from the **Connection** drop-down list which includes the S3 bucket, credentials, and base path. To set up a connection, see [Create Snowflake connections in meters](/docs/platform/extensibility/mediation/manage-connections-in-meters/create-snowflake-connections-in-meters).
    </td>
  </tr>

  <tr>
    <td>
      **Upload Data From**
    </td>

    <td>
      Select a value from the following options:

      * **Table**: Selecting this option allows you to select a table from the list for data ingestion in Snowflake.
      * **Query**: Selecting this option allows you to add a query script if you want to read multiple tables or have complex data ingestion requirements from Snowflake.
    </td>
  </tr>

  <tr>
    <td>
      **Advanced Settings**
    </td>

    <td>
      Select the values for excluded fields, rolling file size, and partition by fields.

      * **Role** - Allows you to add a user role. To set up usernames and keys, to change the default user role, contact [Zuora Support](https://www.zuora.com/support-center/).
      * **Warehouse** - Allows you to select a warehouse size based on your calculation for the resource requirements.
      * **Database and Schema** - Allows you to specify if the table you selected as data output is under a specific database and schema in Snowflake.
    </td>
  </tr>
</table>

Click **Save** to save the Snowflake target settings.