Data Share in Snowflake

2Checkout Snowflake Data Share gives you direct, SQL-based access to your real-time transactional, subscription, and customer data from the 2Checkout platform.

This feature allows you to:

• Query 2Checkout data using standard SQL

• Process your data using any BI tool that supports Snowflake (including popular platforms like Power BI, Tableau, Sigma, or Looker Studio), thanks to Snowflake's broad compatibility and wide industry adoption

• Build custom dashboards and reports with near real-time data

• Blend 2Checkout data with internal datasets to unlock deep business insights

Your organization must have an active Snowflake account to use this feature.

Availability

It's available exclusively for organizations with their own Snowflake instance.

2Checkout Data Share with Snowflake is available on request starting January 2025. Contact our Sales team to request integration with Snowflake.

Benefits

• Faster, more flexible reporting - generate reports more easily and efficiently compared to out-of-the-box tools

• Higher accuracy & richer datasets - access to detailed, near real-time transactional data allows for more granular insights

• Seamless integration with your BI stack - use Snowflake data alongside other tools and sources to build comprehensive business views

Snowflake datasets

The below datasets are offered by default. For custom datasets, contact your account manager.

Subscriptions events

• Purpose: These fields can be used for calculating subscription-specific metrics, such as renewal and disable rates.

• Key Information:

  • The dataset stores events (meaning that there will be more than 1 entry for the same LICENSE_CODE)

  • The row containing the most recent event (EVENT_DATE) for a subscription (LICENCE_CODE) reflects its last state.

  • Contains: license code, purchase date, expiration date, order reference number, etc.

• Available fields:

Field Name	Type	Description
EVENT_DATE	TIMESTAMP_TZ	A snapshot of the subscription at EVENT_DATE.
LICENCE_CODE	VARCHAR	Unique subscription identifier.
PREVIOUS_EXPIRATION_DATE	TIMESTAMP_TZ	Expiration date of the subscription in case the current snapshot is taken after a renewal. Can be NULL if snapshot is taken after an acquisition and before any renewal.
EXPIRATION_DATE	TIMESTAMP_TZ	Expiration date of the subscription at EVENT_DATE.
IS_AUTORENEWING	BOOLEAN	True if the subscription's next renewal is automated, false if it’s manual.
STATUS	VARCHAR	The status of the subscription at EVENT_DATE. Possible values: ACTIVE PAST_DUEPAUSED DISABLED PENDING_ACTIVATION EXPIRED
AUTORENEWAL_DISABLE_REASONS	VARIANT	Reasons for disabling auto-renewal.
AUTORENEWAL_DISABLE_DATE	TIMESTAMP_TZ	Date auto-renewal was disabled.
AUTORENEWAL_DISABLE_SOURCE	VARCHAR	The origin of the action that disabled the automatic renewal of a subscription.
DISABLE_REASONS	VARIANT	The reason for which the subscription is disabled.
DISABLE_DATE	TIMESTAMP_TZ	The date when the subscription is disabled.
DISABLE_SOURCE	VARCHAR	The origin of the action that led to the deactivation or disabling of the subscription. It identifies the system or user interface responsible for terminating the subscription lifecycle. Possible values: null SYSTEM API MYACCOUNT-COD CPANEL CHURN_SOURCE_UNSPECIFIED
INITIAL_PURCHASE_DATE	TIMESTAMP_TZ	Date of the first purchase of the subscription.
PRODUCT_CODE	VARCHAR	Catalog product code.
PAYMENT_METHOD_ON_FILE	VARCHAR	The active stored payment method (e.g., credit card, PayPal, SEPA, digital wallet) that is securely tokenized and used to charge the customer for current or future transactions under a subscription or account.
IS_TRIAL	BOOLEAN	True for trial subscriptions, false otherwise.
IS_LIFETIME	BOOLEAN	True if the subscription is evergreen, or false if the subscription has a recurring billing cycle less than or equal to three years.
PARTNER_ID	NUMBER	Vendor’s partner/reseller ID.
IS_TEST	BOOLEAN	True for test subscriptions, false otherwise.
ACCOUNT_ID	NUMBER	Vendor ID.
CURRENT_REFNO	NUMBER	ID of the order which initiated current/most recent billing cycle of the subscription.
CURRENT_PRODUCT_ID	NUMBER	Product ID of the product pertaining to the billing cycle of the subscription active at EVENT_DATE.
PREVIOUS_REFNO	NUMBER	ID of the order before the most recent before EVENT_DATE. Can be null in case of a new acquisition.
PREVIOUS_PRODUCT_ID	NUMBER	Product ID of the product purchased in the order identified as PREVIOUS_REFNO. Can be different from CURRENT_PRODUCT_ID if an upgrade occurred on the subscription in the order identified with the CURRENT_REFNO.
SUBSCRIPTION_PRODUCT_ID	NUMBER	Unique identifier of the product association between product and the license code. Identifies uniquely the product with its product options and quantity selected for that subscription.
CUSTOMER_ID	NUMBER	2Checkout internal customer identifier.
NEXT_RENEWAL_PRICE	FLOAT	Renewal price for the billing cycle starting after EVENT_DATE.
NEXT_RENEWAL_PRICE_CURRENCY	VARCHAR	Renewal currency for the billing cycle starting after EVENT_DATE.
RENEWAL_COUNTER	NUMBER	The number of renewals completed before EVENT_DATE.

Customer events

• Purpose: Analyze customer-specific metrics such as CLV (Customer Lifetime Value).

• Key Information:

  • This dataset stores events (meaning that there will be more than 1 entry for the same customer).

  • The row containing the most recent event (EVENT_DATE) for a customer (CUSTOMER_ID) reflects its last state.

  • Contains: customer ID, demographics (email, name), lifetime value, etc.

• Available fields:

Field Name	Type	Description
CUSTOMER_ID	NUMBER	2Checkout internal customer identifier.
ACCOUNT_ID	NUMBER	Vendor ID.
ADDRESS_DELIVERY	VARCHAR	Address for codes delivery.
CITY	VARCHAR	Customer city as found in the billing information.
COMPANY	VARCHAR	Company name.
COUNTRY_CODE	VARCHAR	Country code from the billing details.
CREATION_DATE	TIMESTAMP_TZ	Customer creation date.
EMAIL	VARCHAR	Customer’s email address.
EMAIL_DELIVERY	VARCHAR	Email address for delivery.
EVENT_DATE	TIMESTAMP_TZ	Date of the event that generated the current snapshot of the entity.
EXTERNAL_CUSTOMER_ID	VARCHAR	External customer ID.
FIRST_NAME	VARCHAR	First name as found in the billing information.
FIRST_NAME_DELIVERY	VARCHAR	First name as found in the delivery information.
FISCAL_CODE	VARCHAR	Company VAT ID/Tax ID.
LAST_NAME	VARCHAR	Customer last name as found in the billing information.
LAST_NAME_DELIVERY	VARCHAR	Last name as found in the delivery information.
PHONE	VARCHAR	Customer's phone number.
STATE	VARCHAR	Customer's state.
STATUS	VARCHAR	Customer status at EVENT_DATE. Possible values: trial active inactive
TAX_OFFICE	VARCHAR	Tax office code.
ZIP	VARCHAR	Zip code.
CUSTOMER_LIFETIME_VALUE	VARCHAR	The total revenue the customer has generated from the start of their lifecycle up to EVENT_DATE.
CUSTOMER_LIFETIME_VALUE_CURRENCY	VARCHAR	Currency the CUSTOMER_LIFETIME_VALUE is expressed in.

Orders events

• Purpose: Use this dataset to calculate average order value, refund amounts, or chargebacks.

• Key Information:

  • This dataset stores events (meaning that there will be more than 1 entry for the same order).

  • Contains: order reference number, refunds, chargebacks, taxes associated with the whole order, commissions, etc.

• Available fields:

Field Name	Type	Description
ACCOUNT_ID	NUMBER	Vendor ID. Can't be null.
AFFILIATE_ORDER_COMMISSION	VARCHAR	Amount paid to affiliate for enabling the sale (applied to the whole order).
AFFILIATE_ID	VARCHAR	Unique identifier used to track the source of a transaction that was referred to your platform via an affiliate partner. It links revenue to specific affiliates for commission and attribution purposes.
APPROVE_STATUS	VARCHAR	Order status: OK FRAUD INVALIDDATA
COMMISSION	VARCHAR	2Checkout commission for processing the sale.
CARD_EXPIRATION_DATE	VARCHAR	Card expiration month and year.
CARD_LAST_DIGITS	VARCHAR	The last 4 digits of the shopper credit/debit card.
CARD_TYPE	VARCHAR	The card type used by the shopper. Visa Carte_bleue Discover JCB Visaelectron Amex Hipercard Maestro Elo Unionpay Mastercard American Express
CHARGEBACK_CLOSE_REASON	VARCHAR	Possible values: null - no chargeback was initiated for the order OPEN - chargeback is in progress ACCEPTED LOST - chargeback has been won by shopper WON - chargeback has been won by vendor
CHARGEBACK_CLOSED_DATE	VARCHAR	Date when chargeback received a resolution.
CHARGEBACK_OPEN_DATE	VARCHAR	Date when chargeback was opened by shopper.
CHARGEBACK_OPEN_REASON	VARCHAR	Possible values: null New/renewal order not recognized Fraud/Order not recognized Canceled recurring Order not fulfilled/not delivered Unkown reason Product(s) not as described/unfunctional Information request Authorization problem Agreed refund not processed
COMPLETE_DATE	VARCHAR	Date when order was completed.
COUNTRY	VARCHAR	Billing country of the shopper.
CURRENCY	VARCHAR	Sale currency.
ORDER_DISCOUNT	VARCHAR	Discounted amount applied to the order.
ORDER_EXCHANGE_RATE	VARCHAR	Exchange rate between vendor currency and currency the order was paid in at the moment the order was paid.
INVOICE	VARCHAR	Shopper invoice number.
EVENT_DATE	TIMESTAMP_TZ	The date and time when a change happened on the order entity.
ORDER_DATE	VARCHAR	Date when order was placed.
ORDER_DISCOUNT_CODE	VARCHAR	Order promotion code set by vendor in Control Panel.
ORDER_DISCOUNT_NAME	VARCHAR	Order promotion name.
ORDER_DISCOUNT_PRICE	VARCHAR	It should always have a negative value, as it represents the amount deducted from the whole order price calculated in cart at the order placement time.
ORDER_DISCOUNT_TAX	VARCHAR	It should always have a negative value, as it represents the amount deducted from the taxes calculated in cart at the order placement time.
ORDER_FLOW	VARCHAR	Possible values: REGULAR PURCHASE ORDER STORED CREDIT null
ORDER_STATUS	VARCHAR	Current order status. Possible values: COMPLETE AUTHRECEIVED PENDING PENDINGCASH CANCELED REVERSED TEST REFUND CASHED
ORDER_ORIGIN	VARCHAR	Possible values: Automatic billing WEB MOBILE API
PARTNER_CODE	VARCHAR	Set by vendor. If available, it means that the order was placed via a vendor's reseller.
PARTNER_ID	NUMBER	2checkout platform reseller identifier.
PAYABLE_AMOUNT	VARCHAR	Order amount payable to vendor displayed in vendor's accounting currency.
PROFIT_GROSS	VARCHAR	Order amount payable to vendor displayed in vendor's accounting currency.
REFNO	VARCHAR	2Checkout order reference number.
REFUND_COMMENT	VARCHAR	Free text comment placed by shopper when requesting a refund.
REFUND_DATE	VARCHAR	Date when refund order is completed.
REFUND_REASON	VARCHAR	Refund reason if one was specified in the refund request by shopper. Will be classified in one of the following categories when refund is processed: Unwanted auto-renewal Technical issue Duplicate Order Purchased wrong amount (devices) Other No reason Refund – doesn’t want auto-renewal Custom reason Accidental order Tax exemption issue Delayed License Key Multiple subscriptions Price too high Upgrade seat refund Project Tollbooth Uses a different provider Duplicate order Purchased wrong product (iOS) Product not received Update Payment Method Not satisfied with the product Purchased wrong product Unwanted auto-renewal Avoid chargeback Incorrect product ordered Chargeback Purchased/renewed more seats than needed Technical issue with the product Chargebacks
REFUND_TOTAL	VARCHAR	Amount refunded.
REFUND_TYPE	VARCHAR	Possible values: null - if the order is not a refund PARTIAL TOTAL
SHIPPING	VARCHAR	Shipping costs expressed in the same currency as the field CURRENCY.
SRC	VARCHAR	Issued by vendor.
TEST_ORDER	VARCHAR	This order is a test.
ORDER_PRICE	VARCHAR	Order total price.

Subscription orders events

• Purpose: Use this table for product/license prices, discounts, and taxes, or to reach out to customers to ask them to update payment details

• Key Information:

  • This dataset stores events (meaning that there will be more than 1 entry for the same order).

  • If there are more products in one order, then more rows are associated with the same REFNO.

  • Contains: order reference number, product IDs, customer data, payment type, card expiration date

• Available fields:

Field Name	Type	Description
ACCOUNT_ID	NUMBER	Vendor ID. Can't be null.
AFFILIATE_PRODUCT_COMMISSION	VARCHAR	Amount paid to affiliate for enabling the sale of that product.
AFFILIATE_ID	VARCHAR	Unique identifier used to track the source of a transaction that was referred to your platform via an affiliate partner. It links revenue to specific affiliates for commission and attribution purposes.
CARD_EXPIRATION_DATE	VARCHAR	Card expiration month and year.
CARD_LAST_DIGITS	VARCHAR	The last 4 digits of card PAN.
CARD_TYPE	VARCHAR	The card type used by the shopper. Possible values: Visa Carte_bleue Discover JCB Visaelectron Amex Hipercard Maestro Elo Unionpay Mastercard American Express
COUNTRY	VARCHAR	Billing country.
CURRENCY	VARCHAR	Sale currency.
EXPIRATION_DATE	VARCHAR	Subscription expiration date.
CUSTOMER_ID	VARCHAR	2Checkout internal customer identifier.
EXTERNAL_CUSTOMER_ID	VARCHAR	Vendor customer ID.
IMPORTED	VARCHAR	The subscription was imported to the 2Checkout platform.
LAST_ORDER_CURRENCY	VARCHAR	Previous order currency.
LAST_ORDER_PRICE	VARCHAR	Previous order price.
EVENT_DATE	TIMESTAMP_TZ	The date and time when a change happened on the order entity to which the subscription pertains.
ORIGIN	VARCHAR	Possible values: Automatic Billing API Web Mobile
PRODUCT_PRICE	VARCHAR	Unit catalogue price of the product in order (sometimes excluding taxes).
PRODUCT_CODE	VARCHAR	Catalogue product code.
PRODUCT_DISCOUNT	VARCHAR	Discount amount applied to a product in an order. The amount is calculated by applying the discount percentage to each unit price and multiplying by quantity.
PRODUCT_EXTERNAL_REFERENCE	VARCHAR	Product identifier in vendor's system.
PRODUCT_ID	VARCHAR	Product identifier in the 2Checkout system.
PRODUCT_NAME	VARCHAR	The name given to the product.
PRODUCT_PROMOTION_CATEGORY	VARCHAR	Possible values: none UPSELL CROSS_SELLING PROMOTION - coupon
PRODUCT_PROMOTION_CODE	VARCHAR	Promotion code automatically generated when creating a promotion. Example code: XKN53JVEHD
PRODUCT_PROMOTION_COUPON	VARCHAR	Promotion coupon offered to shopper and applied in cart. Example: 10OFF
PRODUCT_PROMOTION_NAME	VARCHAR	Promotion name given by vendor when creating it in Control Panel.
PROMOTION_TYPE	VARCHAR	Possible vales: none SPECIAL_PRICE REGULAR GLOBAL ORDER RENEWAL
PURCHASE_DATE	VARCHAR	Date when license was initially purchased.
QUANTITY	VARCHAR	Number of seats per license in order in eCommerce.
IS_AUTORENEWING	BOOLEAN	True if the subscription next renewal is automated, false if it’s manual.
REFNO	VARCHAR	2Checkout order reference number.
REFUND_REASON	VARCHAR	Refund reason if one was specified in the refund request by shopper. Will be classified in one of the following categories when refund is processed: Unwanted auto-renewal Technical issue Duplicate Order Purchased wrong amount (devices) Other No reason Refund – doesn’t want auto-renewal Custom reason Accidental order Tax exemption issue Delayed License Key Multiple subscriptions Price too high Upgrade seat refund Project Tollbooth Uses a different provider Duplicate order Purchased wrong product (iOS) Product not received Update Payment Method Not satisfied with the product Purchased wrong product Unwanted auto-renewal Avoid chargeback Incorrect product ordered Chargeback Purchased/renewed more seats than needed Technical issue with the product Chargebacks
CURRENCY	VARCHAR	Currency of the order amount.
SHIPPING	VARCHAR	Shipping costs expressed in the same currency as the field CURRENCY.
SHIPPING_TAX	VARCHAR	Product specific.
SRC	VARCHAR	Issued by vendor; examples look like affiliate referral IDs.
LICENSE_CODE	VARCHAR	License code.
SUBSCRIPTION_START_DATE	VARCHAR	The date the subscription became active.
TAX	VARCHAR	Tax associated to each product paid by the shopper.

Exchange rate events

• Purpose: Allows conversion from one currency to another based on historical rates.

• Key Information:

  • Each row contains exchange rates from one currency to another for each day starting on 2002/09/05

• Available fields:

Field Name	Type	Description
EXCHANGE_DATE	TIMESTAMP_TZ	The date when the exchange was made.
FROM_CURRENCY	VARCHAR	The currency from which the exchange was made.
TO_CURRENCY	VARCHAR	The currency to which the exchange was made.
EXCHANGE_RATE	FLOAT	The exchange rate used to convert the amount.