Snowflake as a source and target

You can create meters for Snowflake in the following methods:

To create a meter with Snowflake as the source, follow the instructions below:

Create a Custom Meter. For more information, see Create a new meter using custom method.
Select the Snowflake as the source.
The Snowflake settings page is displayed.
Click Select to select an Event Definition on the Snowflake setting page.
You can create or select an existing Event Definition or import an Event Definition.
Under the Snowflake Settings section, perform the following:

Task	Description
Connection	Select Snowflake from the Connection drop-down 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. Partition By - Allows you to specify the partition to read in and store the files in Zuora S3.

Task

Description

Connection

Select Snowflake from the Connection drop-down 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.
Partition By - Allows you to specify the partition to read in and store the files in Zuora S3.

To create a meter with Snowflake as the target, follow the instructions below:

Create a Custom Meter. For more information, see Create a new meter using custom method.
Select the Snowflake as the target.
The Snowflake settings page is displayed.
Under the Snowflake Settings section, perform the following: