Zuora Snowflake Secure Share

Zuora’s Snowflake Secure Share is a quick start option for Zuora customers desiring a singular place where data from multiple source systems may be examined together and translated into meaningful financial metrics that drive business decisions.

Zuora customers experience a Zero Management data solution with a prepackaged, self-updating Zuora data schema, low latency with high fidelity data streaming, and an ability to BYOBI (Bring Your Own BI). Data Engineers can now spend their time writing more interesting queries on Zuora financial data rather than updating API calls, and business users can go further with their own reports while working in the preferred business intelligence solution with which they are already familiar.

Zuora’s Snowflake Secure Share increases the velocity with which business users get valuable metrics in their hands and decreases the time, effort, and expense of managing manual data integrations to and joined tables within a central database or data lake.

There are several dozen tables included in the share, including the following key Zuora tables:

Account
InvoiceItem
InvoicePayment
JournalEntryItem
OrderAction
Payment
PaymentApplication
PaymentMethodSnapshot
Product
ProductRatePlan
RatePlanCharge
Refund
RefundApplication
RevenueEventItem
RevenueScheduleItem
Subscription
TaxationItem
Usage

The fields available for each object mirror those available in the Zuora Data Query feature. For instance, the fields available for the RatePlanCharge table include:

AccountingCode
ApplyDiscountTo
BillCycleDay
BillCycleType
BillingPeriod
BillingPeriodAlignment
BillingTiming
ChargedThroughDate
ChargeModel
ChargeNumber
ChargeType
Description
DiscountLevel
DMRC
DTCV
EffectiveEndDate
EffectiveStartDate
EndDateCondition
IsLastSegment
IsPrepaid
IsProcessed
ListPriceBase
MRR
Name
NumberOfPeriods
Quantity
TCV
TriggerDate
TriggerEvent
UOM
CreatedById
CreatedDate
UpdatedById
UpdatedDate
AccountReceivableAccountingCodeId
DeferredRevenueAccountingCodeId
RecognizedRevenueAccountingCodeId

Visit Zuora's publicly facing Knowledge Center for full details on included tables.