Shopify

Shopify

Generally AvailableETL Sources

Extract data from this source and load it into your data warehouse.

Features

Feature Name	Supported	Notes
OAuth	✓	OAuth 2.0 authentication
Access Token	✓	API key or access token
Full Refresh	✓	Complete data reload
Incremental Sync	✓	Only new/updated records
Distribution Stage	✓	Generally Available
Dynamic Streams	—
Start Date	✓	Streams support threshold date
Column Hashing	—

Sync Overview

• Total Streams: 151
• Parent Streams: 47
• Sub-Streams: 104
• Supported Sync Modes: Full Refresh, Incremental

Available Streams

• abandoned_checkout (Full Refresh, Incremental)
  • abandoned_checkout_discount_code
  • abandoned_checkout_line
  • abandoned_checkout_line_custom_attribute
  • abandoned_checkout_tax_line
• balance_transaction (Full Refresh, Incremental)
  • adjustment_order
• catalog (Full Refresh)
  • app
• collection (Full Refresh, Incremental)
  • collection_product
  • collection_rule
• company (Full Refresh, Incremental)
  • company_contact
• country (Full Refresh)
  • country_language
• customer (Full Refresh, Incremental)
  • customer_address
  • customer_tag
  • customer_tax_exemption
• customer_segment (Full Refresh)
• discount_automatic_app (Full Refresh, Incremental)
• discount_automatic_basic (Full Refresh, Incremental)
  • discount_customer_gets_collection
  • discount_customer_gets_product
  • discount_customer_gets_product_variant
• discount_automatic_bxgy (Full Refresh, Incremental)
  • discount_customer_buys_collection
  • discount_customer_buys_product
  • discount_customer_buys_product_variant
  • discount_customer_gets_collection
  • discount_customer_gets_product
  • discount_customer_gets_product_variant
• discount_automatic_free_shipping (Full Refresh, Incremental)
  • discount_destination_selection_country
• discount_code_app (Full Refresh, Incremental)
  • discount_customer_segment_selection
  • discount_customer_selection
  • discount_redeem_code
  • discount_shareable_url
• discount_code_basic (Full Refresh, Incremental)
  • discount_customer_gets_collection
  • discount_customer_gets_product
  • discount_customer_gets_product_variant
  • discount_customer_segment_selection
  • discount_customer_selection
  • discount_redeem_code
  • discount_shareable_url
• discount_code_bxgy (Full Refresh, Incremental)
  • discount_customer_buys_collection
  • discount_customer_buys_product
  • discount_customer_buys_product_variant
  • discount_customer_gets_collection
  • discount_customer_gets_product
  • discount_customer_gets_product_variant
  • discount_customer_segment_selection
  • discount_customer_selection
  • discount_redeem_code
  • discount_shareable_url
• discount_code_free_shipping (Full Refresh, Incremental)
  • discount_customer_segment_selection
  • discount_customer_selection
  • discount_destination_selection_country
  • discount_redeem_code
  • discount_shareable_url
• discount_customer_buys_collection (Incremental)
• discount_customer_buys_product (Incremental)
• discount_customer_buys_product_variant (Incremental)
• discount_customer_gets_collection (Incremental)
• discount_customer_gets_product (Incremental)
• discount_customer_gets_product_variant (Incremental)
• discount_customer_segment_selection (Incremental)
• discount_customer_selection (Incremental)
• discount_destination_selection_country (Incremental)
• discount_redeem_code (Incremental)
• discount_shareable_url (Incremental)
• dispute (Full Refresh, Incremental)
• draft_order (Full Refresh, Incremental)
  • draft_order_custom_attribute
  • draft_order_line
  • draft_order_line_custom_attribute
  • draft_order_line_tax_line
  • draft_order_tag
  • draft_order_tax_line
• fulfillment (Full Refresh, Incremental)
  • fulfillment_event
  • fulfillment_line
  • fulfillment_tracking_info
• fulfillment_order (Full Refresh, Incremental)
  • fulfillment_order_fulfillment_hold
  • fulfillment_order_line
  • fulfillment_order_supported_action
• gift_card (Full Refresh)
• inventory_item (Full Refresh, Incremental)
  • inventory_level
  • inventory_quantity
• location (Full Refresh)
• metafield (Full Refresh, Incremental)
• order (Full Refresh, Incremental)
  • customer_visit
  • discount_allocation
  • discount_application
  • order_custom_attribute
  • order_discount_code
  • order_line
  • order_line_custom_attribute
  • order_line_tax_line
  • order_merchant_editable_errors
  • order_payment_gateway_name
  • order_risk_assessment
  • order_risk_fact
  • order_risk_summary
  • order_shipping_line
  • order_shipping_line_tax_line
  • order_tag
• payout (Full Refresh, Incremental)
  • payout_balance
• product (Full Refresh, Incremental)
  • external_video
  • media
  • media_error
  • media_file_error
  • media_image
  • media_source
  • media_warning
  • model_3d
  • product_media
  • product_option
  • product_option_value
  • product_tag
  • video
• product_variant (Full Refresh, Incremental)
  • product_variant_media
  • product_variant_option_value
• publication (Full Refresh)
  • product_publication
• refund (Full Refresh, Incremental)
  • order_adjustment
  • refund_line
  • refund_shipping_line
• return (Full Refresh, Incremental)
  • return_line
  • return_shipping_fee
• sales_agreement (Full Refresh, Incremental)
  • sale
  • sales_tax
• shop (Full Refresh)
  • fulfillment_service
• staff_member (Full Refresh)
• tender_transaction (Full Refresh, Incremental)
• transaction (Full Refresh, Incremental)

Next Steps

• Setup Guide - Learn how to connect Shopify
• API Configuration - View schema and API details
• Release Notes - See recent changes