Integration Specifications
Last updated
Last updated
SKIO is a subscription management platform that allows you to optimize your Shopify subscription program.
This integration is available for:
Enterprise
Growth
This extractor takes data from a BigQuery database owned by SKIO and replicates the data into your database.
Click here to view full screen
The SKIO extractor creates these tables using a replication process from BigQuery to your database.
Update Method: UPSERT
Table Name: [skio.base_order]
| Source column name | Column name |
|---|---|
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 |
Update Method: UPSERT
Table Name: [skio.order_line_item]
| Source column name | Column name |
|---|---|
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 |
Update Method: UPSERT
Table Name: [skio.product]
| Source column name | Column name |
|---|---|
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 |
Update Method: UPSERT
Table Name: [skio.product_variant]
| Source column name | Column name |
|---|---|
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 |
Update Method: UPSERT
Table Name: [skio.site]
| Source column name | Column name |
|---|---|
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 |
Update Method: UPSERT
Table Name: [skio.storefront_user]
| Source column name | Column name |
|---|---|
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 |
Update Method: UPSERT
Table Name: [skio.subscription]
| Source column name | Column name |
|---|---|
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 |
Update Method: UPSERT
Table Name: [skio.subscription_line]
| Source column name | Column name |
|---|---|
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 |