Skip to main content

Using Snowflake Secure Data Sharing to access Zuora data

Zuora

Using Snowflake Secure Data Sharing to access Zuora data

This feature is in the Early Adopter phase. If you want to join the early adopter program, contact your Zuora account representative.

Overview

This feature enables your organization to access your Zuora data in real-time from directly within your organization's own Snowflake account. Secure Data Sharing eliminates the engineering effort traditionally required to manage data extracts, integrations, and data schema changes. Secure Data Sharing also provides your team with instant access to Zuora's comprehensive subscription operational and analytical data to make timely data-driven decisions based on data insights.

Accessing your Zuora data in Snowflake enables you to:

  • Run reports and perform analytics on your Zuora data using your own business intelligence (BI) tool, using Snowflake as the data source. BI tools that offer native connections to Snowflake include:

    • Microsoft Power BI
    • Looker
    • Tableau
    • Qlik
    • Domo

    For a more complete list, see Business Intelligence (BI) in the Snowflake documentation.

  • Combine your Zuora data with other data in Snowflake to perform holistic analysis. For example, in data science applications such as predicting subscriber churn.

  • Use Snowflake's industry-leading data compute infrastructure to run high-speed queries against virtually unlimited volumes of Zuora data. You can run exploratory queries as needed to support your business.

How Secure Data Sharing works

Your Zuora data is stored in a Snowflake account that is managed by Zuora. This data is then shared with your organization's Snowflake account so that you can query the data as if it were stored in your organization's Snowflake account. You have read-only access to the shared database.

In Snowflake terminology, Zuora manages a "provider account" and your organization's account is a "consumer account."

For more information about Secure Data Sharing, see Introduction to Secure Data Sharing in the Snowflake documentation.

Snowflake cost considerations

The following table describes how Snowflake storage and compute costs are handled for the shared database:

Snowflake storage costs Snowflake compute costs
Zuora covers all storage costs associated with the shared database. Your organization will incur no additional storage costs for accepting Zuora's shared database. Zuora does not cover your compute costs associated with querying the shared database. Your organization will pay Snowflake directly for compute costs incurred from querying the shared database.

Setting up Secure Data Sharing

To check your eligibility to use Secure Data Sharing, see Availability.

To set up Secure Data Sharing, contact your Zuora account representative and provide the following information:

  • The tenant ID of the Zuora tenant to share data from. For information about locating the tenant ID, see Managing your tenant profile.
  • The entity to share data from. Only applicable if the Multi-entity feature is enabled in your Zuora tenant.
  • The account identifier of your organization's Snowflake account. You can obtain the account identifier from the URL of your organization's Snowflake account: <account_identifier>.snowflakecomputing.com

Zuora creates a database from your Zuora data and shares the database with your organization's Snowflake account. The name of the database is zuora_<id>, where <id> is the tenant ID of the Zuora tenant that the data is shared from.

You can request to share data from multiple tenants/entities. In this case, Zuora shares a separate database for each tenant/entity.

Data security

When you set up Secure Data Sharing, Zuora only shares data from the tenant that you specify. In addition, the shared database is only accessible via the Snowflake account that you specify.

The shared database is read-only.

The visibility of the shared database depends on how your Snowflake administrator has set up access control. For more information, see Access Control in Snowflake in the Snowflake documentation.

Tables and columns available in Snowflake

The following tables are available in the shared database. To determine the columns available in each table, you can use the SHOW COLUMNS command from Snowflake's SQL syntax. For more information, see SHOW COLUMNS in the Snowflake documentation. Columns containing PCI data will contain null values and excluded from the share.

  • Account
  • AccountingCode
  • AccountingPeriod
  • Amendment
  • BillingRun
  • Contact
  • CreditBalanceAdjustment
  • CreditMemo
  • CreditMemoApplication
  • CreditMemoApplicationItem
  • CreditMemoItem
  • CreditMemoPart
  • CreditMemoPartItem
  • CreditTaxationItem
  • DebitMemo
  • DebitMemoItem
  • DebitTaxationItem
  • Feature
  • FXCustomRate
  • Invoice
  • InvoiceAdjustment
  • InvoiceItem
  • InvoiceItemAdjustment
  • InvoicePayment
  • JournalEntry
  • JournalEntryItem
  • JournalRun
  • NonSubscriptionInvoiceItem
  • OrderAction
  • OrderActionRatePlan
  • OrderContact
  • OrderElp
  • OrderItem
  • OrderLineItem
  • OrderMrr
  • OrderMrrDefault
  • OrderQuantity
  • OrderQuantityDefault
  • Orders
  • OrderTcb
  • OrderTcbDefault
  • OrderTcv
  • OrderTcvDefault
  • Payment
  • PaymentApplication
  • PaymentApplicationItem
  • PaymentMethod
  • PaymentMethodSnapshot
  • PaymentPart
  • PaymentPartItem
  • PaymentRun
  • PaymentTransactionLog
  • ProcessedUsage
  • Product
  • ProductFeature
  • ProductRatePlan
  • ProductRatePlanCharge
  • ProductRatePlanChargeTier
  • Ramp
  • RampInterval
  • RampIntervalDeltaMetrics
  • RampIntervalDeltaMrr
  • RampIntervalDeltaQuantity
  • RampIntervalMetrics
  • RampIntervalMrr
  • RatePlan
  • RatePlanCharge
  • RatePlanChargeTier
  • RealTimeRatingProcessedUsage
  • Refund
  • RefundApplication
  • RefundApplicationItem
  • RefundInvoicePayment
  • RefundItem
  • RefundPart
  • RefundPartItem
  • RevenueChargeSummary
  • RevenueChargeSummaryItem
  • RevenueEvent
  • RevenueEventCreditMemoItem
  • RevenueEventDebitMemoItem
  • RevenueEventInvoiceItem
  • RevenueEventInvoiceItemAdjustment
  • RevenueEventItem
  • RevenueEventItemCreditMemoItem
  • RevenueEventItemDebitMemoItem
  • RevenueEventItemInvoiceItem
  • RevenueEventItemInvoiceItemAdjustment
  • RevenueEventType
  • RevenueSchedule
  • RevenueScheduleCreditMemoItem
  • RevenueScheduleDebitMemoItem
  • RevenueScheduleInvoiceItem
  • RevenueScheduleInvoiceItemAdjustment
  • RevenueScheduleItem
  • RevenueScheduleItemCreditMemoItem
  • RevenueScheduleItemDebitMemoItem
  • RevenueScheduleItemInvoiceItem
  • RevenueScheduleItemInvoiceItemAdjustment
  • Subscription
  • SubscriptionProductFeature
  • TaxationItem
  • Transactions
  • Usage
  • User

FAQs

  • How frequently is the shared database updated with the latest data?

    The shared database is updated in near real-time. In most cases, changes in your Zuora data take less than 10 minutes to appear in the shared database.

  • Is it possible for Zuora to access data in my organization's Snowflake account?

    No

  • Are there limits on how much Zuora data can be stored in Snowflake?

    Zuora hosts your data within Snowflake and uses Snowflake Secure Data Sharing to provide your organization access to ample storage without incurring additional storage costs from Snowflake. Secure Data Sharing does not deplete your organization's contracted storage with Snowflake. Zuora provides storage that scales as your business needs scale. For information, see Managed data entitlement for Snowflake Secure Data Sharing. If you want to adjust your Managed Data Entitlement, contact your Zuora CSM.

  • Are there any limits associated with querying the shared database in Snowflake?

    No. You can query the shared database as if it were stored in your organization's Snowflake account. However, your organization is responsible for the compute costs of querying the shared database.

  • Are there any costs associated with querying the shared database in Snowflake?

    Yes. All queries that you run inside your Snowflake account against the shared database will consume your organization's Snowflake compute credits. Your organization will directly pay Snowflake for those compute credits. However, Zuora covers all data storage costs associated with the shared database. Your organization will not incur any additional storage fees from Snowflake as a result of the share. In other words, your organization pays for all the Snowflake compute, but nothing extra for Snowflake storage.

    In addition, once this feature is out of beta and available to early adopter customers, access to a shared database will involve additional Zuora license fees.

  • Does Snowflake support ZOQL?

    No. You can use Snowflake's SQL syntax to query data. For more information, see SQL Command Reference in the Snowflake documentation.

Availability

To be eligible to use Secure Data Sharing, your Snowflake consumer account must be located in same cloud and region as the Zuora Snowflake Provider Account for your respective Zuora data center.

For information about Zuora data centers, see Zuora data centers.

The following table describes the eligibility requirements of Secure Data Sharing:

Data center of your Zuora tenant Requirements of your Snowflake consumer account
US Cloud Data Center 1

To accept the share, your Snowflake consumer account must be in the following cloud and region:

  • Cloud - AWS
  • Region - US West 2 (Oregon)
US Cloud Data Center 2

To accept the share, your Snowflake consumer account must be in the following cloud and region:

  • Cloud - AWS
  • Region - US West 2 (Oregon)

If your Snowflake account in a different cloud or region from that listed for your Zuora data center, contact your Snowflake account representative for guidance about setting up a Snowflake consumer account in Zuora's cloud and region.

Limitations

  • Secure Data Sharing is available only to Zuora customers for their Production tenants.
  • Secure Data Sharing is not currently available for customers in the EU Cloud Data Center.
  • To be eligible to use Secure Data Sharing, your Snowflake consumer account must be located in same cloud and region as the Zuora Snowflake Provider Account for your respective Zuora data center. For more information, see Availability.
  • The shared database does not include monetary values that are converted into HomeCurrency. All monetary values are in transaction currency.