Welcome to Zuora Product Documentation

Explore our rich library of product information

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.

  1. Navigate to Mediation > Meters
  2. Create a Custom meter.
  3. Select Snowflake as the target. The Snowflake settings page is displayed. Snowflake target settings
  4. Under the Snowflake Settings section, configure the following settings:
    Setting Configuration
    Connection Select Snowflake from the Connection drop-down list which includes the S3 bucket, credentials, and base path. To set up a connection, contact Zuora Support.
    Upload Data From 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.
    Advanced Settings 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.
    • 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.
  5. Click Save to save the Snowflake target settings.