Zuora

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.