Integration Specifications
Integration Overview
SKIO is a subscription management platform that allows you to optimize your Shopify subscription program.
Integration Availability
This integration is available for:
Enterprise
Growth
API Endpoints
This extractor takes data from a BigQuery database owned by SKIO and replicates the data into your database.
Entity Relationship Diagram (ERD)
Click here to view full screen
Unexpected error with integration lucid: Integration is not installed on this space
SKIO Schema
The SKIO extractor creates these tables using a replication process from BigQuery to your database.
Base Order
Update Method: UPSERT
Table Name: [
skio.base_order]
id
ID
createdAt
CREATED_AT
updatedAt
UPDATED_AT
platformId
PLATFORM_ID
deletedAt
DELETED_AT
cancelledAt
CANCELLED_AT
platformNumberBkp
PLATFORM_NUMBER_BKP
storefrontUserId
STOREFRONT_USER_ID
deliveredAt
DELIVERED_AT
fulfillAt
FULFILL_AT
prepaidSubscriptionId
PREPAID_SUBSCRIPTION_ID
firstOrderInPrepaidSequence
FIRST_ORDER_IN_PREPAID_SEQUENCE
fulfillmentOrderCredit
FULFILLMENT_ORDER_CREDIT
note
NOTE
processedAt
PROCESSED_AT
clientIp
CLIENT_IP
totalPrice
TOTAL_PRICE
siteId
SITE_ID
appId
APP_ID
MD5(siteId + id)
__SYNC_KEY
Name of source table in SKIO BigQuery
__SOURCE_TABLE
Name of source dataset in SKIO BigQuery
__DATASET
Daasity app account id
_ACCOUNT_ID
siteId
__SOURCE_ID
UTC timestamp of the last data sync
__SYNCED_AT
platformNumber
PLATFORM_NUMBER
Order Line Item
Update Method: UPSERT
Table Name: [
skio.order_line_item]
id
ID
createdAt
CREATED_AT
updatedAt
UPDATED_AT
productVariantId
PRODUCT_VARIANT_ID
orderId
ORDER_ID
quantity
QUANTITY
platformId
PLATFORM_ID
priceWithoutDiscount
PRICE_WITHOUT_DISCOUNT
groupId
GROUP_ID
subscriptionLineId
SUBSCRIPTION_LINE_ID
attributionGroupId
ATTRIBUTION_GROUP_ID
customAttributes
CUSTOM_ATTRIBUTES
MD5(siteId + id)
__SYNC_KEY
Name of source table in SKIO BigQuery
__SOURCE_TABLE
Name of source dataset in SKIO BigQuery
__DATASET
Daasity app account id
_ACCOUNT_ID
siteId
__SOURCE_ID
UTC timestamp of the last data sync
__SYNCED_AT
Product
Update Method: UPSERT
Table Name: [
skio.product]
id
ID
createdAt
CREATED_AT
updatedAt
UPDATED_AT
siteId
SITE_ID
platformId
PLATFORM_ID
slug
SLUG
imageSrc
IMAGE_SRC
title
TITLE
deletedAt
DELETED_AT
status
STATUS
isSwappable
IS_SWAPPABLE
canUpsell
CAN_UPSELL
smsTitle
SMS_TITLE
smsOrder
SMS_ORDER
swapTitle
SWAP_TITLE
isBuildable
IS_BUILDABLE
hideOnEditProductsPage
HIDE_ON_EDIT_PRODUCTS_PAGE
metafields
METAFIELDS
hideOn1TimeUpsells
HIDE_ON_1_TIME_UPSELLS
oneTimeUpsellPercentageOff
ONE_TIME_UPSELL_PERCENTAGE_OFF
limitOneTimeUpsellQuantity
LIMIT_ONE_TIME_UPSELL_QUANTITY
shopifyTags
SHOPIFY_TAGS
description
DESCRIPTION
images
IMAGES
MD5(siteId + id)
__SYNC_KEY
Name of source table in SKIO BigQuery
__SOURCE_TABLE
Name of source dataset in SKIO BigQuery
__DATASET
Daasity app account id
_ACCOUNT_ID
siteId
__SOURCE_ID
UTC timestamp of the last data sync
__SYNCED_AT
Product Variant
Update Method: UPSERT
Table Name: [
skio.product_variant]
id
ID
createdAt
CREATED_AT
updatedAt
UPDATED_AT
price
PRICE
title
TITLE
platformId
PLATFORM_ID
productId
PRODUCT_ID
sku
SKU
deletedAt
DELETED_AT
image
IMAGE
compareAtPrice
COMPARE_AT_PRICE
outOfStockAt
OUT_OF_STOCK_AT
marketPrices
MARKET_PRICES
billingPriceOverride
BILLING_PRICE_OVERRIDE
enableOneTimeUpsell
ENABLE_ONE_TIME_UPSELL
MD5(siteId + id)
__SYNC_KEY
Name of source table in SKIO BigQuery
__SOURCE_TABLE
Name of source dataset in SKIO BigQuery
__DATASET
Daasity app account id
_ACCOUNT_ID
siteId
__SOURCE_ID
UTC timestamp of the last data sync
__SYNCED_AT
Site
Update Method: UPSERT
Table Name: [
skio.site]
id
ID
createdAt
CREATED_AT
updatedAt
UPDATED_AT
domain
DOMAIN
url
URL
currencyCode
CURRENCY_CODE
name
NAME
slug
SLUG
hostname
HOSTNAME
syncing
SYNCING
snippetsSyncing
SNIPPETS_SYNCING
notificationEmail
NOTIFICATION_EMAIL
notificationEmailUnderReview
NOTIFICATION_EMAIL_UNDER_REVIEW
urlShortener
URL_SHORTENER
freeTrialEndsAt
FREE_TRIAL_ENDS_AT
awsPhoneNumber
AWS_PHONE_NUMBER
isPaying
IS_PAYING
plivoPhoneNumber
PLIVO_PHONE_NUMBER
contactFirstName
CONTACT_FIRST_NAME
contactLastName
CONTACT_LAST_NAME
klaviyoPublicKey
KLAVIYO_PUBLIC_KEY
klaviyoPrivateKey
KLAVIYO_PRIVATE_KEY
transactionCut
TRANSACTION_CUT
groupRevenueCut
GROUP_REVENUE_CUT
hideGroupSubscriptions
HIDE_GROUP_SUBSCRIPTIONS
backfilling
BACKFILLING
taxIncluded
TAX_INCLUDED
roundUpAnchors
ROUND_UP_ANCHORS
scriptLoadBehavior
SCRIPT_LOAD_BEHAVIOR
transactionFee
TRANSACTION_FEE
stripeSubscriptionItemId
STRIPE_SUBSCRIPTION_ITEM_ID
showSellingPlanId
SHOW_SELLING_PLAN_ID
quarterlyOverride
QUARTERLY_OVERRIDE
betaTesting
BETA_TESTING
transactionFeeAppliesToGroup
TRANSACTION_FEE_APPLIES_TO_GROUP
orderPrefix
ORDER_PREFIX
inventoryPolicy
INVENTORY_POLICY
groupDiscountOffOneTime
GROUP_DISCOUNT_OFF_ONE_TIME
featureSmsRemindersWithActions
FEATURE_SMS_REMINDERS_WITH_ACTIONS
updateShippingOnSubscriptionChanges
UPDATE_SHIPPING_ON_SUBSCRIPTION_CHANGES
vCardUrl
V_CARD_URL
gorgiasAccountName
GORGIAS_ACCOUNT_NAME
gorgiasRefreshToken
GORGIAS_REFRESH_TOKEN
pushWeekendOrders
PUSH_WEEKEND_ORDERS
billMigratedSubs
BILL_MIGRATED_SUBS
billingWindow
BILLING_WINDOW
useRechargeTags
USE_RECHARGE_TAGS
inviteLinkOverride
INVITE_LINK_OVERRIDE
hideChooseSubscription
HIDE_CHOOSE_SUBSCRIPTION
storefrontAccessToken
STOREFRONT_ACCESS_TOKEN
sitewidePortalPercentageOff
SITEWIDE_PORTAL_PERCENTAGE_OFF
hideOrderStatusWidget
HIDE_ORDER_STATUS_WIDGET
giftOnSkip
GIFT_ON_SKIP
multipassSecret
MULTIPASS_SECRET
lastRecurringBillingLock
LAST_RECURRING_BILLING_LOCK
cancelSubscriptionAfterAttempts
CANCEL_SUBSCRIPTION_AFTER_ATTEMPTS
subscriptionBillingRetryInterval
SUBSCRIPTION_BILLING_RETRY_INTERVAL
contactEmail
CONTACT_EMAIL
ianaTimezone
IANA_TIMEZONE
showShippingCalculationButton
SHOW_SHIPPING_CALCULATION_BUTTON
mergeSubscriptions
MERGE_SUBSCRIPTIONS
skioSmsModifyOptionsMapping
SKIO_SMS_MODIFY_OPTIONS_MAPPING
twilioMessagingServiceSid
TWILIO_MESSAGING_SERVICE_SID
lastRecurringBillingNotificationLock
LAST_RECURRING_BILLING_NOTIFICATION_LOCK
migrationId
MIGRATION_ID
impactKey
IMPACT_KEY
impactSid
IMPACT_SID
showNewCustomerPortal
SHOW_NEW_CUSTOMER_PORTAL
zendeskToken
ZENDESK_TOKEN
syncAddressesToShopify
SYNC_ADDRESSES_TO_SHOPIFY
allowCustomerDiscountCodeStacking
ALLOW_CUSTOMER_DISCOUNT_CODE_STACKING
settings
SETTINGS
syncingRules
SYNCING_RULES
showPauseInDashboard
SHOW_PAUSE_IN_DASHBOARD
showPauseInCustomerPortal
SHOW_PAUSE_IN_CUSTOMER_PORTAL
termsOfService
TERMS_OF_SERVICE
runningKlaviyoBackfill
RUNNING_KLAVIYO_BACKFILL
autoMergeBilling
AUTO_MERGE_BILLING
productDiscountFunctionId
PRODUCT_DISCOUNT_FUNCTION_ID
gorgiasDashboardActionToken
GORGIAS_DASHBOARD_ACTION_TOKEN
installedApps
INSTALLED_APPS
smartCarouselSettings
SMART_CAROUSEL_SETTINGS
dunningSettings
DUNNING_SETTINGS
useFlycoDeDunning
USE_FLYCODE_DUNNING
lastMigrationTime
LAST_MIGRATION_TIME
skioUninstalled
SKIO_UNINSTALLED
defaultCopyTranslationId
DEFAULT_COPY_TRANSLATION_ID
stripeSaasFee
STRIPE_SAAS_FEE
previewSettings
PREVIEW_SETTINGS
skioSmsSettings
SKIO_SMS_SETTINGS
showPauseInCutomerPortal
SHOW_PAUSE_IN_CUTOMER_PORTAL
MD5(siteId + id)
__SYNC_KEY
Name of source table in SKIO BigQuery
__SOURCE_TABLE
Name of source dataset in SKIO BigQuery
__DATASET
Daasity app account id
_ACCOUNT_ID
siteId
__SOURCE_ID
UTC timestamp of the last data sync
__SYNCED_AT
Storefront User
Update Method: UPSERT
Table Name: [
skio.storefront_user]
id
ID
createdAt
CREATED_AT
updatedAt
UPDATED_AT
cognitoUsername
COGNITO_USERNAME
phoneNumber
PHONE_NUMBER
siteId
SITE_ID
platformId
PLATFORM_ID
firstName
FIRST_NAME
lastName
LAST_NAME
userId
USER_ID
storefrontUserGroupId
STOREFRONT_USER_GROUP_ID
cognitoUserId
COGNITO_USER_ID
storefrontUserGroupStatus
STOREFRONT_USER_GROUP_STATUS
groupDiscountCode
GROUP_DISCOUNT_CODE
redactedAt
REDACTED_AT
shopifyTags
SHOPIFY_TAGS
qaToken
QA_TOKEN
qaTokenUpdatedAt
QA_TOKEN_UPDATED_AT
removedAt
REMOVED_AT
backupPaymentMethodId
BACKUP_PAYMENT_METHOD_ID
platformCreatedAt
PLATFORM_CREATED_AT
amountSpent
AMOUNT_SPENT
numberOfOrders
NUMBER_OF_ORDERS
amountSpentCurrencyCode
AMOUNT_SPENT_CURRENCY_CODE
numberOrOrders
NUMBER_OR_ORDERS
MD5(siteId + id)
__SYNC_KEY
Name of source table in SKIO BigQuery
__SOURCE_TABLE
Name of source dataset in SKIO BigQuery
__DATASET
Daasity app account id
_ACCOUNT_ID
siteId
__SOURCE_ID
UTC timestamp of the last data sync
__SYNCED_AT
Subscription
Update Method: UPSERT
Table Name: [
skio.subscription]
id
ID
createdAt
CREATED_AT
updatedAt
UPDATED_AT
billingPolicyId
BILLING_POLICY_ID
deliveryPolicyId
DELIVERY_POLICY_ID
shippingAddressId
SHIPPING_ADDRESS_ID
paymentMethodId
PAYMENT_METHOD_ID
deliveryPrice
DELIVERY_PRICE
status
STATUS
currencyCode
CURRENCY_CODE
nextBillingDate
NEXT_BILLING_DATE
storefrontUserId
STOREFRONT_USER_ID
idempotencyKey
IDEMPOTENCY_KEY
platformId
PLATFORM_ID
cancelledAt
CANCELLED_AT
statusContext
STATUS_CONTEXT
lastBillingAttemptAt
LAST_BILLING_ATTEMPT_AT
migrationIndex
MIGRATION_INDEX
customAttributes
CUSTOM_ATTRIBUTES
prepaidDeliveryPolicyId
PREPAID_DELIVERY_POLICY_ID
prepaidProductPricesPerDelivery
PREPAID_PRODUCT_PRICES_PER_DELIVERY
cyclesCompleted
CYCLES_COMPLETED
deliveryPriceOverride
DELIVERY_PRICE_OVERRIDE
creditPerOrder
CREDIT_PER_ORDER
metadata
METADATA
pausedAt
PAUSED_AT
siteId
SITE_ID
prepaidGiftRecipientId
PREPAID_GIFT_RECIPIENT_ID
originOrderId
ORIGIN_ORDER_ID
dunningStoryId
DUNNING_STORY_ID
note
NOTE
isPickup
IS_PICKUP
MD5(siteId + id)
__SYNC_KEY
Name of source table in SKIO BigQuery
__SOURCE_TABLE
Name of source dataset in SKIO BigQuery
__DATASET
Daasity app account id
_ACCOUNT_ID
siteId
__SOURCE_ID
UTC timestamp of the last data sync
__SYNCED_AT
Subscription Line
Update Method: UPSERT
Table Name: [
skio.subscription_line]
id
ID
createdAt
CREATED_AT
updatedAt
UPDATED_AT
subscriptionId
SUBSCRIPTION_ID
priceWithoutDiscount
PRICE_WITHOUT_DISCOUNT
quantity
QUANTITY
sellingPlanId
SELLING_PLAN_ID
productVariantId
PRODUCT_VARIANT_ID
platformId
PLATFORM_ID
taxable
TAXABLE
groupId
GROUP_ID
reChargeId
RE_CHARGE_ID
boldId
BOLD_ID
removedAt
REMOVED_AT
ordersRemaining
ORDERS_REMAINING
isPrepaid
IS_PREPAID
prepaidSubscriptionId
PREPAID_SUBSCRIPTION_ID
customAttributes
CUSTOM_ATTRIBUTES
titleOverride
TITLE_OVERRIDE
legacySubscriptionId
LEGACY_SUBSCRIPTION_ID
MD5(siteId + id)
__SYNC_KEY
Name of source table in SKIO BigQuery
__SOURCE_TABLE
Name of source dataset in SKIO BigQuery
__DATASET
Daasity app account id
_ACCOUNT_ID
siteId
__SOURCE_ID
UTC timestamp of the last data sync
__SYNCED_AT
Was this helpful?