ReferenceSource Models
Skio Models
Copy-paste SQL model definitions for Skio subscription reporting.
Copy and Paste these Skio Models into your Data Layer to quickly go from raw data souces —> business ready reporting. Please note:
- Models must be added chronological order from top to bottom (so that they can reference each other).
- When adding your own models you must update the reference to include your source names.
Base
skio_products_base
select
id
, description
, created_at
, status
, can_upsell
, is_buildable
, hide_on_1_time_upsells
, is_swappable
, deleted_at
from {{sources.skio.product}}skio_subscriptions_base
select
id
, created_at
, origin_order_id
, next_billing_date
, last_billing_attempt_at
, cancelled_at
, cycles_completed
, delivery_policy_id
, storefront_user_id
, status
, dunning_story_id
, payment_method_id
, billing_policy_id
, shipping_address_id
from {{sources.skio.subscription}}skio_subscription_lines_base
select
id
, created_at
, product_variant_id
, selling_plan_id
, removed_at
, quantity
, subscription_id
from {{sources.skio.subscription_line}}