version: 2 models: - name: v_abandoned_checkout description: > One row per abandoned checkout event across all stores. Sourced from CRM_ECOMMERCE_DATA.SHOPIFY_.ABANDONED_CHECKOUT and PROD_SHOPIFY_INTEGRATIONS..ABANDONED_CHECKOUT, unioned via generate_shopify_table_union and enriched with store metadata from shopify_stores_master. PII fields (email, phone, name, addresses, and all credit card fields) are masked to NULL. columns: - name: store_id description: "{{ doc('col__store_id') }}" - name: store_schema description: "{{ doc('col__store_schema') }}" - name: store_name description: "{{ doc('col__store_name') }}" - name: artist description: "{{ doc('col__artist') }}" - name: vendor_name description: "{{ doc('col__vendor_name') }}" - name: vendor_id description: "{{ doc('col__vendor_id') }}" - name: id description: "{{ doc('col__abandoned_checkout__id') }}" - name: token description: "{{ doc('col__abandoned_checkout__token') }}" - name: cart_token description: "{{ doc('col__abandoned_checkout__cart_token') }}" - name: name description: "{{ doc('col__abandoned_checkout__name') }}" - name: abandoned_checkout_url description: "{{ doc('col__abandoned_checkout__abandoned_checkout_url') }}" - name: source_identifier description: "{{ doc('col__abandoned_checkout__source_identifier') }}" - name: source_name description: "{{ doc('col__abandoned_checkout__source_name') }}" - name: source description: "{{ doc('col__abandoned_checkout__source') }}" - name: source_url description: "{{ doc('col__abandoned_checkout__source_url') }}" - name: gateway description: "{{ doc('col__abandoned_checkout__gateway') }}" - name: created_at description: "{{ doc('col__abandoned_checkout__created_at') }}" - name: created_at_date description: "{{ doc('col__created_at_date') }}" - name: updated_at description: "{{ doc('col__abandoned_checkout__updated_at') }}" - name: updated_at_date description: "{{ doc('col__updated_at_date') }}" - name: completed_at description: "{{ doc('col__abandoned_checkout__completed_at') }}" - name: completed_at_date description: "{{ doc('col__completed_at_date') }}" - name: closed_at description: "{{ doc('col__abandoned_checkout__closed_at') }}" - name: closed_at_date description: "{{ doc('col__closed_at_date') }}" - name: subtotal_price description: "{{ doc('col__abandoned_checkout__subtotal_price') }}" - name: total_price description: "{{ doc('col__abandoned_checkout__total_price') }}" - name: total_discounts description: "{{ doc('col__abandoned_checkout__total_discounts') }}" - name: total_line_items_price description: "{{ doc('col__abandoned_checkout__total_line_items_price') }}" - name: total_tax description: "{{ doc('col__abandoned_checkout__total_tax') }}" - name: total_weight description: "{{ doc('col__abandoned_checkout__total_weight') }}" - name: total_duties description: "{{ doc('col__abandoned_checkout__total_duties') }}" - name: taxes_included description: "{{ doc('col__abandoned_checkout__taxes_included') }}" - name: currency description: "{{ doc('col__abandoned_checkout__currency') }}" - name: presentment_currency description: "{{ doc('col__abandoned_checkout__presentment_currency') }}" - name: applied_discount_title description: "{{ doc('col__abandoned_checkout__applied_discount_title') }}" - name: applied_discount_description description: "{{ doc('col__abandoned_checkout__applied_discount_description') }}" - name: applied_discount_value description: "{{ doc('col__abandoned_checkout__applied_discount_value') }}" - name: applied_discount_value_type description: "{{ doc('col__abandoned_checkout__applied_discount_value_type') }}" - name: applied_discount_amount description: "{{ doc('col__abandoned_checkout__applied_discount_amount') }}" - name: applied_discount_applicable description: "{{ doc('col__abandoned_checkout__applied_discount_applicable') }}" - name: applied_discount_non_applicable_reason description: "{{ doc('col__abandoned_checkout__applied_discount_non_applicable_reason') }}" - name: shipping_rate_id description: "{{ doc('col__abandoned_checkout__shipping_rate_id') }}" - name: shipping_rate_title description: "{{ doc('col__abandoned_checkout__shipping_rate_title') }}" - name: shipping_rate_price description: "{{ doc('col__abandoned_checkout__shipping_rate_price') }}" - name: shipping_line description: "{{ doc('col__abandoned_checkout__shipping_line') }}" - name: customer_id description: "{{ doc('col__abandoned_checkout__customer_id') }}" - name: email description: "{{ doc('col__abandoned_checkout__email') }}" - name: phone description: "{{ doc('col__abandoned_checkout__phone') }}" - name: buyer_accepts_marketing description: "{{ doc('col__abandoned_checkout__buyer_accepts_marketing') }}" - name: customer_locale description: "{{ doc('col__abandoned_checkout__customer_locale') }}" - name: user_id description: "{{ doc('col__abandoned_checkout__user_id') }}" - name: device_id description: "{{ doc('col__abandoned_checkout__device_id') }}" - name: shipping_address_id description: "{{ doc('col__abandoned_checkout__shipping_address_id') }}" - name: shipping_address_name description: "{{ doc('col__abandoned_checkout__shipping_address_name') }}" - name: shipping_address_first_name description: "{{ doc('col__abandoned_checkout__shipping_address_first_name') }}" - name: shipping_address_last_name description: "{{ doc('col__abandoned_checkout__shipping_address_last_name') }}" - name: shipping_address_company description: "{{ doc('col__abandoned_checkout__shipping_address_company') }}" - name: shipping_address_phone description: "{{ doc('col__abandoned_checkout__shipping_address_phone') }}" - name: shipping_address_address_1 description: "{{ doc('col__abandoned_checkout__shipping_address_address_1') }}" - name: shipping_address_address_2 description: "{{ doc('col__abandoned_checkout__shipping_address_address_2') }}" - name: shipping_address_city description: "{{ doc('col__abandoned_checkout__shipping_address_city') }}" - name: shipping_address_country description: "{{ doc('col__abandoned_checkout__shipping_address_country') }}" - name: shipping_address_country_code description: "{{ doc('col__abandoned_checkout__shipping_address_country_code') }}" - name: shipping_address_province description: "{{ doc('col__abandoned_checkout__shipping_address_province') }}" - name: shipping_address_province_code description: "{{ doc('col__abandoned_checkout__shipping_address_province_code') }}" - name: shipping_address_zip description: "{{ doc('col__abandoned_checkout__shipping_address_zip') }}" - name: shipping_address_latitude description: "{{ doc('col__abandoned_checkout__shipping_address_latitude') }}" - name: shipping_address_longitude description: "{{ doc('col__abandoned_checkout__shipping_address_longitude') }}" - name: billing_address_id description: "{{ doc('col__abandoned_checkout__billing_address_id') }}" - name: billing_address_name description: "{{ doc('col__abandoned_checkout__billing_address_name') }}" - name: billing_address_first_name description: "{{ doc('col__abandoned_checkout__billing_address_first_name') }}" - name: billing_address_last_name description: "{{ doc('col__abandoned_checkout__billing_address_last_name') }}" - name: billing_address_company description: "{{ doc('col__abandoned_checkout__billing_address_company') }}" - name: billing_address_phone description: "{{ doc('col__abandoned_checkout__billing_address_phone') }}" - name: billing_address_address_1 description: "{{ doc('col__abandoned_checkout__billing_address_address_1') }}" - name: billing_address_address_2 description: "{{ doc('col__abandoned_checkout__billing_address_address_2') }}" - name: billing_address_city description: "{{ doc('col__abandoned_checkout__billing_address_city') }}" - name: billing_address_country description: "{{ doc('col__abandoned_checkout__billing_address_country') }}" - name: billing_address_country_code description: "{{ doc('col__abandoned_checkout__billing_address_country_code') }}" - name: billing_address_province description: "{{ doc('col__abandoned_checkout__billing_address_province') }}" - name: billing_address_province_code description: "{{ doc('col__abandoned_checkout__billing_address_province_code') }}" - name: billing_address_zip description: "{{ doc('col__abandoned_checkout__billing_address_zip') }}" - name: billing_address_latitude description: "{{ doc('col__abandoned_checkout__billing_address_latitude') }}" - name: billing_address_longitude description: "{{ doc('col__abandoned_checkout__billing_address_longitude') }}" - name: credit_card_number description: "{{ doc('col__abandoned_checkout__credit_card_number') }}" - name: credit_card_first_name description: "{{ doc('col__abandoned_checkout__credit_card_first_name') }}" - name: credit_card_last_name description: "{{ doc('col__abandoned_checkout__credit_card_last_name') }}" - name: credit_card_month description: "{{ doc('col__abandoned_checkout__credit_card_month') }}" - name: credit_card_year description: "{{ doc('col__abandoned_checkout__credit_card_year') }}" - name: credit_card_verification_value description: "{{ doc('col__abandoned_checkout__credit_card_verification_value') }}" - name: landing_site_base_url description: "{{ doc('col__abandoned_checkout__landing_site_base_url') }}" - name: referring_site description: "{{ doc('col__abandoned_checkout__referring_site') }}" - name: location_id description: "{{ doc('col__abandoned_checkout__location_id') }}" - name: note description: "{{ doc('col__abandoned_checkout__note') }}" - name: note_attributes description: "{{ doc('col__abandoned_checkout__note_attributes') }}" - name: _fivetran_deleted description: "{{ doc('col__abandoned_checkout___fivetran_deleted') }}" - name: _fivetran_synced description: "{{ doc('col___fivetran_synced') }}" - name: v_collection description: > One row per Shopify collection (custom or smart) across all stores. Sourced from CRM_ECOMMERCE_DATA.SHOPIFY_.COLLECTION and PROD_SHOPIFY_INTEGRATIONS..COLLECTION. No PII fields; no masking applied. columns: - name: store_id description: "{{ doc('col__store_id') }}" - name: store_schema description: "{{ doc('col__store_schema') }}" - name: store_name description: "{{ doc('col__store_name') }}" - name: artist description: "{{ doc('col__artist') }}" - name: vendor_name description: "{{ doc('col__vendor_name') }}" - name: vendor_id description: "{{ doc('col__vendor_id') }}" - name: id description: "{{ doc('col__collection__id') }}" - name: title description: "{{ doc('col__collection__title') }}" - name: handle description: "{{ doc('col__collection__handle') }}" - name: body_html description: "{{ doc('col__collection__body_html') }}" - name: published_at description: "{{ doc('col__collection__published_at') }}" - name: published_at_date description: "{{ doc('col__published_at_date') }}" - name: published_scope description: "{{ doc('col__collection__published_scope') }}" - name: updated_at description: "{{ doc('col__collection__updated_at') }}" - name: updated_at_date description: "{{ doc('col__updated_at_date') }}" - name: sort_order description: "{{ doc('col__collection__sort_order') }}" - name: template_suffix description: "{{ doc('col__collection__template_suffix') }}" - name: disjunctive description: "{{ doc('col__collection__disjunctive') }}" - name: rules description: "{{ doc('col__collection__rules') }}" - name: source_identifier description: "{{ doc('col__collection__source_identifier') }}" - name: _fivetran_deleted description: "{{ doc('col___fivetran_deleted') }}" - name: _fivetran_synced description: "{{ doc('col___fivetran_synced') }}" - name: v_collection_product description: > Junction table mapping products to collections across all stores. One row per product-collection membership. No PII fields; no masking applied. columns: - name: store_id description: "{{ doc('col__store_id') }}" - name: store_schema description: "{{ doc('col__store_schema') }}" - name: store_name description: "{{ doc('col__store_name') }}" - name: artist description: "{{ doc('col__artist') }}" - name: vendor_name description: "{{ doc('col__vendor_name') }}" - name: vendor_id description: "{{ doc('col__vendor_id') }}" - name: collection_id description: "{{ doc('col__collection_product__collection_id') }}" - name: product_id description: "{{ doc('col__collection_product__product_id') }}" - name: source_identifier description: "{{ doc('col__source_identifier') }}" - name: _fivetran_synced description: "{{ doc('col___fivetran_synced') }}" - name: v_customer description: > One row per Shopify customer account across all stores. Sourced from CRM_ECOMMERCE_DATA.SHOPIFY_.CUSTOMER and PROD_SHOPIFY_INTEGRATIONS..CUSTOMER. PII fields (email, first_name, last_name, phone) are masked to NULL. columns: - name: store_id description: "{{ doc('col__store_id') }}" - name: store_schema description: "{{ doc('col__store_schema') }}" - name: store_name description: "{{ doc('col__store_name') }}" - name: artist description: "{{ doc('col__artist') }}" - name: vendor_name description: "{{ doc('col__vendor_name') }}" - name: vendor_id description: "{{ doc('col__vendor_id') }}" - name: customer_id description: "{{ doc('col__customer__customer_id') }}" - name: first_name description: "{{ doc('col__customer__first_name') }}" - name: last_name description: "{{ doc('col__customer__last_name') }}" - name: email description: "{{ doc('col__customer__email') }}" - name: phone description: "{{ doc('col__customer__phone') }}" - name: verified_email description: "{{ doc('col__customer__verified_email') }}" - name: multipass_identifier description: "{{ doc('col__customer__multipass_identifier') }}" - name: state description: "{{ doc('col__customer__state') }}" - name: note description: "{{ doc('col__customer__note') }}" - name: can_delete description: "{{ doc('col__customer__can_delete') }}" - name: created_at description: "{{ doc('col__customer__created_at') }}" - name: created_at_date description: "{{ doc('col__created_at_date') }}" - name: updated_at description: "{{ doc('col__customer__updated_at') }}" - name: updated_at_date description: "{{ doc('col__updated_at_date') }}" - name: orders_count description: "{{ doc('col__customer__orders_count') }}" - name: total_spent description: "{{ doc('col__customer__total_spent') }}" - name: lifetime_duration description: "{{ doc('col__customer__lifetime_duration') }}" - name: currency description: "{{ doc('col__customer__currency') }}" - name: tax_exempt description: "{{ doc('col__customer__tax_exempt') }}" - name: accepts_marketing description: "{{ doc('col__customer__accepts_marketing') }}" - name: accepts_marketing_updated_at description: "{{ doc('col__customer__accepts_marketing_updated_at') }}" - name: accepts_marketing_updated_at_date description: "{{ doc('col__accepts_marketing_updated_at_date') }}" - name: marketing_opt_in_level description: "{{ doc('col__customer__marketing_opt_in_level') }}" - name: email_marketing_consent_state description: "{{ doc('col__customer__email_marketing_consent_state') }}" - name: email_marketing_consent_opt_in_level description: "{{ doc('col__customer__email_marketing_consent_opt_in_level') }}" - name: email_marketing_consent_consent_updated_at description: "{{ doc('col__customer__email_marketing_consent_consent_updated_at') }}" - name: email_marketing_consent_consent_updated_at_date description: "{{ doc('col__email_marketing_consent_consent_updated_at_date') }}" - name: sms_marketing_consent_state description: "{{ doc('col__customer__sms_marketing_consent_state') }}" - name: sms_marketing_consent_opt_in_level description: "{{ doc('col__customer__sms_marketing_consent_opt_in_level') }}" - name: sms_marketing_consent_collected_from description: "{{ doc('col__customer__sms_marketing_consent_collected_from') }}" - name: sms_marketing_consent_updated_at description: "{{ doc('col__customer__sms_marketing_consent_updated_at') }}" - name: sms_marketing_consent_updated_at_date description: "{{ doc('col__sms_marketing_consent_updated_at_date') }}" - name: default_phone_number description: "{{ doc('col__customer__default_phone_number') }}" - name: default_phone_number_source_location_id description: "{{ doc('col__customer__default_phone_number_source_location_id') }}" - name: default_phone_number_marketing_collected_from description: "{{ doc('col__customer__default_phone_number_marketing_collected_from') }}" - name: default_phone_number_marketing_state description: "{{ doc('col__customer__default_phone_number_marketing_state') }}" - name: default_phone_number_marketing_opt_in_level description: "{{ doc('col__customer__default_phone_number_marketing_opt_in_level') }}" - name: default_phone_number_marketing_updated_at description: "{{ doc('col__customer__default_phone_number_marketing_updated_at') }}" - name: default_phone_number_marketing_updated_at_date description: "{{ doc('col__default_phone_number_marketing_updated_at_date') }}" - name: default_email_address description: "{{ doc('col__customer__default_email_address') }}" - name: default_email_address_source_location_id description: "{{ doc('col__customer__default_email_address_source_location_id') }}" - name: metafield description: "{{ doc('col__customer__metafield') }}" - name: source_identifier description: "{{ doc('col__source_identifier') }}" - name: _fivetran_deleted description: "{{ doc('col__customer___fivetran_deleted') }}" - name: _fivetran_synced description: "{{ doc('col___fivetran_synced') }}" - name: v_customer_address description: > One row per saved address on a customer account across all stores. Sourced from CUSTOMER_ADDRESS tables. PII fields (name, first_name, last_name, phone, company, address_1, address_2) are masked to NULL. columns: - name: store_id description: "{{ doc('col__store_id') }}" - name: store_schema description: "{{ doc('col__store_schema') }}" - name: store_name description: "{{ doc('col__store_name') }}" - name: artist description: "{{ doc('col__artist') }}" - name: vendor_name description: "{{ doc('col__vendor_name') }}" - name: vendor_id description: "{{ doc('col__vendor_id') }}" - name: customer_id description: "{{ doc('col__customer_address__customer_id') }}" - name: id description: "{{ doc('col__customer_address__id') }}" - name: name description: "{{ doc('col__customer_address__name') }}" - name: first_name description: "{{ doc('col__customer_address__first_name') }}" - name: last_name description: "{{ doc('col__customer_address__last_name') }}" - name: company description: "{{ doc('col__customer_address__company') }}" - name: phone description: "{{ doc('col__customer_address__phone') }}" - name: address_1 description: "{{ doc('col__customer_address__address_1') }}" - name: address_2 description: "{{ doc('col__customer_address__address_2') }}" - name: city description: "{{ doc('col__customer_address__city') }}" - name: country description: "{{ doc('col__customer_address__country') }}" - name: country_code description: "{{ doc('col__customer_address__country_code') }}" - name: province description: "{{ doc('col__customer_address__province') }}" - name: province_code description: "{{ doc('col__customer_address__province_code') }}" - name: zip description: "{{ doc('col__customer_address__zip') }}" - name: latitude description: "{{ doc('col__customer_address__latitude') }}" - name: longitude description: "{{ doc('col__customer_address__longitude') }}" - name: is_default description: "{{ doc('col__customer_address__is_default') }}" - name: source_identifier description: "{{ doc('col__source_identifier') }}" - name: _fivetran_synced description: "{{ doc('col___fivetran_synced') }}" - name: v_fulfillment description: > One row per fulfillment (shipment record) across all stores. Sourced from FULFILLMENT tables. No PII fields; no masking applied. columns: - name: store_id description: "{{ doc('col__store_id') }}" - name: store_schema description: "{{ doc('col__store_schema') }}" - name: store_name description: "{{ doc('col__store_name') }}" - name: artist description: "{{ doc('col__artist') }}" - name: vendor_name description: "{{ doc('col__vendor_name') }}" - name: vendor_id description: "{{ doc('col__vendor_id') }}" - name: id description: "{{ doc('col__fulfillment__id') }}" - name: order_id description: "{{ doc('col__fulfillment__order_id') }}" - name: location_id description: "{{ doc('col__fulfillment__location_id') }}" - name: created_at description: "{{ doc('col__fulfillment__created_at') }}" - name: created_at_date description: "{{ doc('col__created_at_date') }}" - name: updated_at description: "{{ doc('col__fulfillment__updated_at') }}" - name: updated_at_date description: "{{ doc('col__updated_at_date') }}" - name: status description: "{{ doc('col__fulfillment__status') }}" - name: service description: "{{ doc('col__fulfillment__service') }}" - name: tracking_company description: "{{ doc('col__fulfillment__tracking_company') }}" - name: tracking_number description: "{{ doc('col__fulfillment__tracking_number') }}" - name: tracking_numbers description: "{{ doc('col__fulfillment__tracking_numbers') }}" - name: tracking_urls description: "{{ doc('col__fulfillment__tracking_urls') }}" - name: shipment_status description: "{{ doc('col__fulfillment__shipment_status') }}" - name: name description: "{{ doc('col__fulfillment__name') }}" - name: receipt_authorization description: "{{ doc('col__fulfillment__receipt_authorization') }}" - name: source_identifier description: "{{ doc('col__source_identifier') }}" - name: _fivetran_synced description: "{{ doc('col___fivetran_synced') }}" - name: v_fulfillment_event description: > One row per fulfillment tracking event (e.g. in_transit, delivered) across all stores. Sourced from FULFILLMENT_EVENT tables. No PII fields; no masking applied. columns: - name: store_id description: "{{ doc('col__store_id') }}" - name: store_schema description: "{{ doc('col__store_schema') }}" - name: store_name description: "{{ doc('col__store_name') }}" - name: artist description: "{{ doc('col__artist') }}" - name: vendor_name description: "{{ doc('col__vendor_name') }}" - name: vendor_id description: "{{ doc('col__vendor_id') }}" - name: id description: "{{ doc('col__fulfillment_event__id') }}" - name: order_id description: "{{ doc('col__fulfillment_event__order_id') }}" - name: fulfillment_id description: "{{ doc('col__fulfillment_event__fulfillment_id') }}" - name: shop_id description: "{{ doc('col__fulfillment_event__shop_id') }}" - name: status description: "{{ doc('col__fulfillment_event__status') }}" - name: message description: "{{ doc('col__fulfillment_event__message') }}" - name: happened_at description: "{{ doc('col__fulfillment_event__happened_at') }}" - name: happened_at_date description: "{{ doc('col__happened_at_date') }}" - name: estimated_delivery_at description: "{{ doc('col__fulfillment_event__estimated_delivery_at') }}" - name: estimated_delivery_at_date description: "{{ doc('col__estimated_delivery_at_date') }}" - name: created_at description: "{{ doc('col__fulfillment_event__created_at') }}" - name: created_at_date description: "{{ doc('col__created_at_date') }}" - name: updated_at description: "{{ doc('col__fulfillment_event__updated_at') }}" - name: updated_at_date description: "{{ doc('col__updated_at_date') }}" - name: address_1 description: "{{ doc('col__fulfillment_event__address_1') }}" - name: city description: "{{ doc('col__fulfillment_event__city') }}" - name: province description: "{{ doc('col__fulfillment_event__province') }}" - name: country description: "{{ doc('col__fulfillment_event__country') }}" - name: zip description: "{{ doc('col__fulfillment_event__zip') }}" - name: latitude description: "{{ doc('col__fulfillment_event__latitude') }}" - name: longitude description: "{{ doc('col__fulfillment_event__longitude') }}" - name: source_identifier description: "{{ doc('col__source_identifier') }}" - name: _fivetran_deleted description: "{{ doc('col___fivetran_deleted') }}" - name: _fivetran_synced description: "{{ doc('col___fivetran_synced') }}" - name: v_fulfillment_order description: > One row per fulfillment order (a group of line items to be fulfilled together from a single location) across all stores. A single Shopify order may produce multiple fulfillment orders. Sourced from FULFILLMENT_ORDER tables. PII fields in the destination address (email, name, phone, address lines) are masked to NULL. columns: - name: store_id description: "{{ doc('col__store_id') }}" - name: store_schema description: "{{ doc('col__store_schema') }}" - name: store_name description: "{{ doc('col__store_name') }}" - name: artist description: "{{ doc('col__artist') }}" - name: vendor_name description: "{{ doc('col__vendor_name') }}" - name: vendor_id description: "{{ doc('col__vendor_id') }}" - name: order_id description: "{{ doc('col__fulfillment_order__order_id') }}" - name: id description: "{{ doc('col__fulfillment_order__id') }}" - name: updated_at description: "{{ doc('col__fulfillment_order__updated_at') }}" - name: updated_at_date description: "{{ doc('col__updated_at_date') }}" - name: created_at description: "{{ doc('col__fulfillment_order__created_at') }}" - name: created_at_date description: "{{ doc('col__created_at_date') }}" - name: fulfill_at description: "{{ doc('col__fulfillment_order__fulfill_at') }}" - name: fulfill_at_date description: "{{ doc('col__fulfill_at_date') }}" - name: fulfill_by description: "{{ doc('col__fulfillment_order__fulfill_by') }}" - name: status description: "{{ doc('col__fulfillment_order__status') }}" - name: request_status description: "{{ doc('col__fulfillment_order__request_status') }}" - name: destination_id description: "{{ doc('col__fulfillment_order__destination_id') }}" - name: destination_address_1 description: "{{ doc('col__fulfillment_order__destination_address_1') }}" - name: destination_address_2 description: "{{ doc('col__fulfillment_order__destination_address_2') }}" - name: destination_city description: "{{ doc('col__fulfillment_order__destination_city') }}" - name: destination_company description: "{{ doc('col__fulfillment_order__destination_company') }}" - name: destination_country_code description: "{{ doc('col__fulfillment_order__destination_country_code') }}" - name: destination_email description: "{{ doc('col__fulfillment_order__destination_email') }}" - name: destination_first_name description: "{{ doc('col__fulfillment_order__destination_first_name') }}" - name: destination_last_name description: "{{ doc('col__fulfillment_order__destination_last_name') }}" - name: destination_phone description: "{{ doc('col__fulfillment_order__destination_phone') }}" - name: destination_province description: "{{ doc('col__fulfillment_order__destination_province') }}" - name: destination_zip description: "{{ doc('col__fulfillment_order__destination_zip') }}" - name: supported_actions description: "{{ doc('col__fulfillment_order__supported_actions') }}" - name: international_duties_incoterm description: "{{ doc('col__fulfillment_order__international_duties_incoterm') }}" - name: delivery_method_id description: "{{ doc('col__fulfillment_order__delivery_method_id') }}" - name: delivery_method_min_delivery_date_time description: "{{ doc('col__fulfillment_order__delivery_method_min_delivery_date_time') }}" - name: delivery_method_max_delivery_date_time description: "{{ doc('col__fulfillment_order__delivery_method_max_delivery_date_time') }}" - name: delivery_method_method_type description: "{{ doc('col__fulfillment_order__delivery_method_method_type') }}" - name: delivery_method_service_code description: "{{ doc('col__fulfillment_order__delivery_method_service_code') }}" - name: delivery_method_presented_name description: "{{ doc('col__fulfillment_order__delivery_method_presented_name') }}" - name: assigned_location_address_1 description: "{{ doc('col__fulfillment_order__assigned_location_address_1') }}" - name: assigned_location_address_2 description: "{{ doc('col__fulfillment_order__assigned_location_address_2') }}" - name: assigned_location_city description: "{{ doc('col__fulfillment_order__assigned_location_city') }}" - name: assigned_location_country_code description: "{{ doc('col__fulfillment_order__assigned_location_country_code') }}" - name: assigned_location_name description: "{{ doc('col__fulfillment_order__assigned_location_name') }}" - name: assigned_location_phone description: "{{ doc('col__fulfillment_order__assigned_location_phone') }}" - name: assigned_location_province description: "{{ doc('col__fulfillment_order__assigned_location_province') }}" - name: assigned_location_zip description: "{{ doc('col__fulfillment_order__assigned_location_zip') }}" - name: assigned_location_id description: "{{ doc('col__fulfillment_order__assigned_location_id') }}" - name: assigned_location_location_id description: "{{ doc('col__fulfillment_order__assigned_location_location_id') }}" - name: _fivetran_deleted description: "{{ doc('col__fulfillment_order___fivetran_deleted') }}" - name: _fivetran_synced description: "{{ doc('col___fivetran_synced') }}" - name: source_identifier description: "{{ doc('col__fulfillment_order__source_identifier') }}" - name: v_fulfillment_order_line description: > One row per line item within a fulfillment (linking a fulfillment to an order line item) across all stores. Sourced from FULFILLMENT_ORDER_LINE tables. No PII fields; no masking applied. columns: - name: store_id description: "{{ doc('col__store_id') }}" - name: store_schema description: "{{ doc('col__store_schema') }}" - name: store_name description: "{{ doc('col__store_name') }}" - name: artist description: "{{ doc('col__artist') }}" - name: vendor_name description: "{{ doc('col__vendor_name') }}" - name: vendor_id description: "{{ doc('col__vendor_id') }}" - name: fulfillment_id description: "{{ doc('col__fulfillment_order_line__fulfillment_id') }}" - name: order_line_id description: "{{ doc('col__fulfillment_order_line__order_line_id') }}" - name: product_id description: "{{ doc('col__fulfillment_order_line__product_id') }}" - name: variant_id description: "{{ doc('col__fulfillment_order_line__variant_id') }}" - name: name description: "{{ doc('col__fulfillment_order_line__name') }}" - name: title description: "{{ doc('col__fulfillment_order_line__title') }}" - name: vendor description: "{{ doc('col__fulfillment_order_line__vendor') }}" - name: price description: "{{ doc('col__fulfillment_order_line__price') }}" - name: price_set description: "{{ doc('col__fulfillment_order_line__price_set') }}" - name: quantity description: "{{ doc('col__fulfillment_order_line__quantity') }}" - name: grams description: "{{ doc('col__fulfillment_order_line__grams') }}" - name: sku description: "{{ doc('col__fulfillment_order_line__sku') }}" - name: fulfillable_quantity description: "{{ doc('col__fulfillment_order_line__fulfillable_quantity') }}" - name: fulfillment_service description: "{{ doc('col__fulfillment_order_line__fulfillment_service') }}" - name: gift_card description: "{{ doc('col__fulfillment_order_line__gift_card') }}" - name: requires_shipping description: "{{ doc('col__fulfillment_order_line__requires_shipping') }}" - name: taxable description: "{{ doc('col__fulfillment_order_line__taxable') }}" - name: variant_title description: "{{ doc('col__fulfillment_order_line__variant_title') }}" - name: properties description: "{{ doc('col__fulfillment_order_line__properties') }}" - name: order_id description: "{{ doc('col__fulfillment_order_line__order_id') }}" - name: _fivetran_synced description: "{{ doc('col___fivetran_synced') }}" - name: source_identifier description: "{{ doc('col__fulfillment_order_line__source_identifier') }}" - name: v_fulfillment_order_line_item description: > One row per line item assignment within a fulfillment order across all stores. Tracks quantity assignments — how many units of each inventory item are allocated to a fulfillment order and how many remain to be fulfilled. Sourced from FULFILLMENT_ORDER_LINE_ITEM tables. No PII fields; no masking applied. columns: - name: store_id description: "{{ doc('col__store_id') }}" - name: store_schema description: "{{ doc('col__store_schema') }}" - name: store_name description: "{{ doc('col__store_name') }}" - name: artist description: "{{ doc('col__artist') }}" - name: vendor_name description: "{{ doc('col__vendor_name') }}" - name: vendor_id description: "{{ doc('col__vendor_id') }}" - name: fulfillment_order_id description: "{{ doc('col__fulfillment_order_line_item__fulfillment_order_id') }}" - name: id description: "{{ doc('col__fulfillment_order_line_item__id') }}" - name: inventory_item_id description: "{{ doc('col__fulfillment_order_line_item__inventory_item_id') }}" - name: remaining_quantity description: "{{ doc('col__fulfillment_order_line_item__remaining_quantity') }}" - name: total_quantity description: "{{ doc('col__fulfillment_order_line_item__total_quantity') }}" - name: _fivetran_synced description: "{{ doc('col___fivetran_synced') }}" - name: source_identifier description: "{{ doc('col__fulfillment_order_line_item__source_identifier') }}" - name: v_inventory_item description: > One row per inventory item (each product variant has exactly one inventory item) across all stores. Contains cost, SKU, country of origin, weight, and tracking settings. Sourced from INVENTORY_ITEM tables. No PII fields; no masking applied. columns: - name: store_id description: "{{ doc('col__store_id') }}" - name: store_schema description: "{{ doc('col__store_schema') }}" - name: store_name description: "{{ doc('col__store_name') }}" - name: artist description: "{{ doc('col__artist') }}" - name: vendor_name description: "{{ doc('col__vendor_name') }}" - name: vendor_id description: "{{ doc('col__vendor_id') }}" - name: id description: "{{ doc('col__inventory_item__id') }}" - name: country_code_of_origin description: "{{ doc('col__inventory_item__country_code_of_origin') }}" - name: created_at description: "{{ doc('col__inventory_item__created_at') }}" - name: created_at_date description: "{{ doc('col__created_at_date') }}" - name: duplicate_sku_count description: "{{ doc('col__inventory_item__duplicate_sku_count') }}" - name: harmonized_system_code description: "{{ doc('col__inventory_item__harmonized_system_code') }}" - name: inventory_history_url description: "{{ doc('col__inventory_item__inventory_history_url') }}" - name: legacy_resource_id description: "{{ doc('col__inventory_item__legacy_resource_id') }}" - name: measurement_id description: "{{ doc('col__inventory_item__measurement_id') }}" - name: measurement_weight_value description: "{{ doc('col__inventory_item__measurement_weight_value') }}" - name: measurement_weight_unit description: "{{ doc('col__inventory_item__measurement_weight_unit') }}" - name: province_code_of_origin description: "{{ doc('col__inventory_item__province_code_of_origin') }}" - name: requires_shipping description: "{{ doc('col__inventory_item__requires_shipping') }}" - name: sku description: "{{ doc('col__inventory_item__sku') }}" - name: tracked description: "{{ doc('col__inventory_item__tracked') }}" - name: tracked_editable_locked description: "{{ doc('col__inventory_item__tracked_editable_locked') }}" - name: tracked_editable_reason description: "{{ doc('col__inventory_item__tracked_editable_reason') }}" - name: unit_cost_amount description: "{{ doc('col__inventory_item__unit_cost_amount') }}" - name: unit_cost_currency_code description: "{{ doc('col__inventory_item__unit_cost_currency_code') }}" - name: updated_at description: "{{ doc('col__inventory_item__updated_at') }}" - name: updated_at_date description: "{{ doc('col__updated_at_date') }}" - name: _fivetran_deleted description: "{{ doc('col__inventory_item___fivetran_deleted') }}" - name: _fivetran_synced description: "{{ doc('col___fivetran_synced') }}" - name: source_identifier description: "{{ doc('col__inventory_item__source_identifier') }}" - name: v_inventory_level description: > One row per inventory item per location (the available quantity of an inventory item at a specific fulfillment location) across all stores. Sourced from INVENTORY_LEVEL tables. No PII fields; no masking applied. columns: - name: store_id description: "{{ doc('col__store_id') }}" - name: store_schema description: "{{ doc('col__store_schema') }}" - name: store_name description: "{{ doc('col__store_name') }}" - name: artist description: "{{ doc('col__artist') }}" - name: vendor_name description: "{{ doc('col__vendor_name') }}" - name: vendor_id description: "{{ doc('col__vendor_id') }}" - name: inventory_item_id description: "{{ doc('col__inventory_level__inventory_item_id') }}" - name: id description: "{{ doc('col__inventory_level__id') }}" - name: location_id description: "{{ doc('col__inventory_level__location_id') }}" - name: can_deactivate description: "{{ doc('col__inventory_level__can_deactivate') }}" - name: created_at description: "{{ doc('col__inventory_level__created_at') }}" - name: created_at_date description: "{{ doc('col__created_at_date') }}" - name: deactivation_alert description: "{{ doc('col__inventory_level__deactivation_alert') }}" - name: updated_at description: "{{ doc('col__inventory_level__updated_at') }}" - name: updated_at_date description: "{{ doc('col__updated_at_date') }}" - name: _fivetran_synced description: "{{ doc('col___fivetran_synced') }}" - name: source_identifier description: "{{ doc('col__inventory_level__source_identifier') }}" - name: v_inventory_quantity description: > One row per named inventory quantity (e.g. available, committed, on_hand) per inventory item per location across all stores. Provides a breakdown of inventory by quantity name/state. Sourced from INVENTORY_QUANTITY tables. No PII fields; no masking applied. columns: - name: store_id description: "{{ doc('col__store_id') }}" - name: store_schema description: "{{ doc('col__store_schema') }}" - name: store_name description: "{{ doc('col__store_name') }}" - name: artist description: "{{ doc('col__artist') }}" - name: vendor_name description: "{{ doc('col__vendor_name') }}" - name: vendor_id description: "{{ doc('col__vendor_id') }}" - name: id description: "{{ doc('col__inventory_quantity__id') }}" - name: inventory_item_id description: "{{ doc('col__inventory_quantity__inventory_item_id') }}" - name: inventory_level_id description: "{{ doc('col__inventory_quantity__inventory_level_id') }}" - name: name description: "{{ doc('col__inventory_quantity__name') }}" - name: quantity description: "{{ doc('col__inventory_quantity__quantity') }}" - name: updated_at description: "{{ doc('col__inventory_quantity__updated_at') }}" - name: updated_at_date description: "{{ doc('col__updated_at_date') }}" - name: _fivetran_synced description: "{{ doc('col___fivetran_synced') }}" - name: source_identifier description: "{{ doc('col__inventory_quantity__source_identifier') }}" - name: v_order description: > One row per Shopify order across all stores. Sourced from CRM_ECOMMERCE_DATA.SHOPIFY_.ORDER and PROD_SHOPIFY_INTEGRATIONS..ORDER, unioned via the generate_shopify_table_union macro and enriched with store metadata from shopify_stores_master. PII fields (email, names, phone numbers, addresses, browser IP, user agent, notes) are masked to NULL. columns: - name: store_id description: "{{ doc('col__store_id') }}" - name: store_schema description: "{{ doc('col__store_schema') }}" - name: store_name description: "{{ doc('col__store_name') }}" - name: artist description: "{{ doc('col__artist') }}" - name: vendor_name description: "{{ doc('col__vendor_name') }}" - name: vendor_id description: "{{ doc('col__vendor_id') }}" - name: order_id description: "{{ doc('col__order__order_id') }}" - name: name description: "{{ doc('col__order__name') }}" - name: number description: "{{ doc('col__order__number') }}" - name: order_number description: "{{ doc('col__order__order_number') }}" - name: token description: "{{ doc('col__order__token') }}" - name: source_identifier description: "{{ doc('col__order__source_identifier') }}" - name: source_name description: "{{ doc('col__order__source_name') }}" - name: app_id description: "{{ doc('col__order__app_id') }}" - name: payment_gateway_names description: "{{ doc('col__order__payment_gateway_names') }}" - name: processing_method description: "{{ doc('col__order__processing_method') }}" - name: company_id description: "{{ doc('col__order__company_id') }}" - name: company_location_id description: "{{ doc('col__order__company_location_id') }}" - name: created_at description: "{{ doc('col__order__created_at') }}" - name: created_at_date description: "{{ doc('col__created_at_date') }}" - name: updated_at description: "{{ doc('col__order__updated_at') }}" - name: updated_at_date description: "{{ doc('col__updated_at_date') }}" - name: processed_at description: "{{ doc('col__order__processed_at') }}" - name: processed_at_date description: "{{ doc('col__processed_at_date') }}" - name: closed_at description: "{{ doc('col__order__closed_at') }}" - name: closed_at_date description: "{{ doc('col__closed_at_date') }}" - name: cancelled_at description: "{{ doc('col__order__cancelled_at') }}" - name: cancelled_at_date description: "{{ doc('col__cancelled_at_date') }}" - name: financial_status description: "{{ doc('col__order__financial_status') }}" - name: fulfillment_status description: "{{ doc('col__order__fulfillment_status') }}" - name: cancel_reason description: "{{ doc('col__order__cancel_reason') }}" - name: confirmed description: "{{ doc('col__order__confirmed') }}" - name: test description: "{{ doc('col__order__test') }}" - name: subtotal_price description: "{{ doc('col__order__subtotal_price') }}" - name: subtotal_price_set description: "{{ doc('col__order__subtotal_price_set') }}" - name: total_price description: "{{ doc('col__order__total_price') }}" - name: total_price_set description: "{{ doc('col__order__total_price_set') }}" - name: total_price_usd description: "{{ doc('col__order__total_price_usd') }}" - name: total_outstanding description: "{{ doc('col__order__total_outstanding') }}" - name: total_discounts description: "{{ doc('col__order__total_discounts') }}" - name: total_discounts_set description: "{{ doc('col__order__total_discounts_set') }}" - name: total_line_items_price description: "{{ doc('col__order__total_line_items_price') }}" - name: total_line_items_price_set description: "{{ doc('col__order__total_line_items_price_set') }}" - name: total_tax description: "{{ doc('col__order__total_tax') }}" - name: total_tax_set description: "{{ doc('col__order__total_tax_set') }}" - name: total_shipping_price_set description: "{{ doc('col__order__total_shipping_price_set') }}" - name: original_total_duties_set description: "{{ doc('col__order__original_total_duties_set') }}" - name: current_total_price description: "{{ doc('col__order__current_total_price') }}" - name: current_total_price_set description: "{{ doc('col__order__current_total_price_set') }}" - name: current_subtotal_price description: "{{ doc('col__order__current_subtotal_price') }}" - name: current_subtotal_price_set description: "{{ doc('col__order__current_subtotal_price_set') }}" - name: current_total_discounts description: "{{ doc('col__order__current_total_discounts') }}" - name: current_total_discounts_set description: "{{ doc('col__order__current_total_discounts_set') }}" - name: current_total_tax description: "{{ doc('col__order__current_total_tax') }}" - name: current_total_tax_set description: "{{ doc('col__order__current_total_tax_set') }}" - name: current_total_duties_set description: "{{ doc('col__order__current_total_duties_set') }}" - name: total_tip_received description: "{{ doc('col__order__total_tip_received') }}" - name: total_weight description: "{{ doc('col__order__total_weight') }}" - name: taxes_included description: "{{ doc('col__order__taxes_included') }}" - name: currency description: "{{ doc('col__order__currency') }}" - name: presentment_currency description: "{{ doc('col__order__presentment_currency') }}" - name: customer_id description: "{{ doc('col__order__customer_id') }}" - name: email description: "{{ doc('col__order__email') }}" - name: buyer_accepts_marketing description: "{{ doc('col__order__buyer_accepts_marketing') }}" - name: customer_locale description: "{{ doc('col__order__customer_locale') }}" - name: user_id description: "{{ doc('col__order__user_id') }}" - name: billing_address_id description: "{{ doc('col__order__billing_address_id') }}" - name: billing_address_address_1 description: "{{ doc('col__order__billing_address_address_1') }}" - name: billing_address_address_2 description: "{{ doc('col__order__billing_address_address_2') }}" - name: billing_address_city description: "{{ doc('col__order__billing_address_city') }}" - name: billing_address_company description: "{{ doc('col__order__billing_address_company') }}" - name: billing_address_country description: "{{ doc('col__order__billing_address_country') }}" - name: billing_address_country_code description: "{{ doc('col__order__billing_address_country_code') }}" - name: billing_address_first_name description: "{{ doc('col__order__billing_address_first_name') }}" - name: billing_address_last_name description: "{{ doc('col__order__billing_address_last_name') }}" - name: billing_address_name description: "{{ doc('col__order__billing_address_name') }}" - name: billing_address_phone description: "{{ doc('col__order__billing_address_phone') }}" - name: billing_address_province description: "{{ doc('col__order__billing_address_province') }}" - name: billing_address_province_code description: "{{ doc('col__order__billing_address_province_code') }}" - name: billing_address_zip description: "{{ doc('col__order__billing_address_zip') }}" - name: billing_address_latitude description: "{{ doc('col__order__billing_address_latitude') }}" - name: billing_address_longitude description: "{{ doc('col__order__billing_address_longitude') }}" - name: shipping_address_id description: "{{ doc('col__order__shipping_address_id') }}" - name: shipping_address_address_1 description: "{{ doc('col__order__shipping_address_address_1') }}" - name: shipping_address_address_2 description: "{{ doc('col__order__shipping_address_address_2') }}" - name: shipping_address_city description: "{{ doc('col__order__shipping_address_city') }}" - name: shipping_address_company description: "{{ doc('col__order__shipping_address_company') }}" - name: shipping_address_country description: "{{ doc('col__order__shipping_address_country') }}" - name: shipping_address_country_code description: "{{ doc('col__order__shipping_address_country_code') }}" - name: shipping_address_first_name description: "{{ doc('col__order__shipping_address_first_name') }}" - name: shipping_address_last_name description: "{{ doc('col__order__shipping_address_last_name') }}" - name: shipping_address_name description: "{{ doc('col__order__shipping_address_name') }}" - name: shipping_address_phone description: "{{ doc('col__order__shipping_address_phone') }}" - name: shipping_address_province description: "{{ doc('col__order__shipping_address_province') }}" - name: shipping_address_province_code description: "{{ doc('col__order__shipping_address_province_code') }}" - name: shipping_address_zip description: "{{ doc('col__order__shipping_address_zip') }}" - name: shipping_address_latitude description: "{{ doc('col__order__shipping_address_latitude') }}" - name: shipping_address_longitude description: "{{ doc('col__order__shipping_address_longitude') }}" - name: browser_ip description: "{{ doc('col__order__browser_ip') }}" - name: client_details_user_agent description: "{{ doc('col__order__client_details_user_agent') }}" - name: landing_site_base_url description: "{{ doc('col__order__landing_site_base_url') }}" - name: referring_site description: "{{ doc('col__order__referring_site') }}" - name: device_id description: "{{ doc('col__order__device_id') }}" - name: landing_site_ref description: "{{ doc('col__order__landing_site_ref') }}" - name: reference description: "{{ doc('col__order__reference') }}" - name: source_url description: "{{ doc('col__order__source_url') }}" - name: cart_token description: "{{ doc('col__order__cart_token') }}" - name: checkout_token description: "{{ doc('col__order__checkout_token') }}" - name: checkout_id description: "{{ doc('col__order__checkout_id') }}" - name: order_status_url description: "{{ doc('col__order__order_status_url') }}" - name: note description: "{{ doc('col__order__note') }}" - name: note_attributes description: "{{ doc('col__order__note_attributes') }}" - name: location_id description: "{{ doc('col__order__location_id') }}" - name: _fivetran_deleted description: "{{ doc('col__order___fivetran_deleted') }}" - name: _fivetran_synced description: "{{ doc('col__order___fivetran_synced') }}" - name: v_order_discount_code description: > One row per discount code applied to an order across all stores. A single order may have multiple discount codes applied (each appears as a separate row). Sourced from ORDER_DISCOUNT_CODE tables. No PII fields; no masking applied. columns: - name: store_id description: "{{ doc('col__store_id') }}" - name: store_schema description: "{{ doc('col__store_schema') }}" - name: store_name description: "{{ doc('col__store_name') }}" - name: artist description: "{{ doc('col__artist') }}" - name: vendor_name description: "{{ doc('col__vendor_name') }}" - name: vendor_id description: "{{ doc('col__vendor_id') }}" - name: order_id description: "{{ doc('col__order_discount_code__order_id') }}" - name: index description: "{{ doc('col__order_discount_code__index') }}" - name: code description: "{{ doc('col__order_discount_code__code') }}" - name: type description: "{{ doc('col__order_discount_code__type') }}" - name: amount description: "{{ doc('col__order_discount_code__amount') }}" - name: _fivetran_synced description: "{{ doc('col___fivetran_synced') }}" - name: source_identifier description: "{{ doc('col__order_discount_code__source_identifier') }}" - name: v_order_line description: > One row per line item on a Shopify order across all stores. Each line item represents a product variant purchased in a specific quantity. Sourced from ORDER_LINE tables. No PII fields; no masking applied. columns: - name: store_id description: "{{ doc('col__store_id') }}" - name: store_schema description: "{{ doc('col__store_schema') }}" - name: store_name description: "{{ doc('col__store_name') }}" - name: artist description: "{{ doc('col__artist') }}" - name: vendor_name description: "{{ doc('col__vendor_name') }}" - name: vendor_id description: "{{ doc('col__vendor_id') }}" - name: order_id description: "{{ doc('col__order_line__order_id') }}" - name: id description: "{{ doc('col__order_line__id') }}" - name: product_id description: "{{ doc('col__order_line__product_id') }}" - name: variant_id description: "{{ doc('col__order_line__variant_id') }}" - name: name description: "{{ doc('col__order_line__name') }}" - name: title description: "{{ doc('col__order_line__title') }}" - name: vendor description: "{{ doc('col__order_line__vendor') }}" - name: price description: "{{ doc('col__order_line__price') }}" - name: price_set description: "{{ doc('col__order_line__price_set') }}" - name: quantity description: "{{ doc('col__order_line__quantity') }}" - name: grams description: "{{ doc('col__order_line__grams') }}" - name: sku description: "{{ doc('col__order_line__sku') }}" - name: fulfillable_quantity description: "{{ doc('col__order_line__fulfillable_quantity') }}" - name: fulfillment_service description: "{{ doc('col__order_line__fulfillment_service') }}" - name: gift_card description: "{{ doc('col__order_line__gift_card') }}" - name: requires_shipping description: "{{ doc('col__order_line__requires_shipping') }}" - name: taxable description: "{{ doc('col__order_line__taxable') }}" - name: variant_title description: "{{ doc('col__order_line__variant_title') }}" - name: properties description: "{{ doc('col__order_line__properties') }}" - name: index description: "{{ doc('col__order_line__index') }}" - name: total_discount description: "{{ doc('col__order_line__total_discount') }}" - name: total_discount_set description: "{{ doc('col__order_line__total_discount_set') }}" - name: product_exists description: "{{ doc('col__order_line__product_exists') }}" - name: pre_tax_price description: "{{ doc('col__order_line__pre_tax_price') }}" - name: pre_tax_price_set description: "{{ doc('col__order_line__pre_tax_price_set') }}" - name: fulfillment_status description: "{{ doc('col__order_line__fulfillment_status') }}" - name: variant_inventory_management description: "{{ doc('col__order_line__variant_inventory_management') }}" - name: tax_code description: "{{ doc('col__order_line__tax_code') }}" - name: _fivetran_synced description: "{{ doc('col___fivetran_synced') }}" - name: origin_location_id description: "{{ doc('col__order_line__origin_location_id') }}" - name: origin_location_name description: "{{ doc('col__order_line__origin_location_name') }}" - name: origin_location_address_1 description: "{{ doc('col__order_line__origin_location_address_1') }}" - name: origin_location_address_2 description: "{{ doc('col__order_line__origin_location_address_2') }}" - name: origin_location_city description: "{{ doc('col__order_line__origin_location_city') }}" - name: origin_location_zip description: "{{ doc('col__order_line__origin_location_zip') }}" - name: origin_location_country_code description: "{{ doc('col__order_line__origin_location_country_code') }}" - name: origin_location_province_code description: "{{ doc('col__order_line__origin_location_province_code') }}" - name: destination_location_id description: "{{ doc('col__order_line__destination_location_id') }}" - name: destination_location_name description: "{{ doc('col__order_line__destination_location_name') }}" - name: destination_location_address_1 description: "{{ doc('col__order_line__destination_location_address_1') }}" - name: destination_location_address_2 description: "{{ doc('col__order_line__destination_location_address_2') }}" - name: destination_location_city description: "{{ doc('col__order_line__destination_location_city') }}" - name: destination_location_zip description: "{{ doc('col__order_line__destination_location_zip') }}" - name: destination_location_country_code description: "{{ doc('col__order_line__destination_location_country_code') }}" - name: destination_location_province_code description: "{{ doc('col__order_line__destination_location_province_code') }}" - name: source_identifier description: "{{ doc('col__order_line__source_identifier') }}" - name: v_order_line_refund description: > One row per refunded line item on a Shopify refund across all stores. Each record represents one order line item that was returned or refunded, with associated quantity and financial adjustments. Sourced from ORDER_LINE_REFUND tables. No PII fields; no masking applied. columns: - name: store_id description: "{{ doc('col__store_id') }}" - name: store_schema description: "{{ doc('col__store_schema') }}" - name: store_name description: "{{ doc('col__store_name') }}" - name: artist description: "{{ doc('col__artist') }}" - name: vendor_name description: "{{ doc('col__vendor_name') }}" - name: vendor_id description: "{{ doc('col__vendor_id') }}" - name: id description: "{{ doc('col__order_line_refund__id') }}" - name: location_id description: "{{ doc('col__order_line_refund__location_id') }}" - name: refund_id description: "{{ doc('col__order_line_refund__refund_id') }}" - name: restock_type description: "{{ doc('col__order_line_refund__restock_type') }}" - name: quantity description: "{{ doc('col__order_line_refund__quantity') }}" - name: subtotal description: "{{ doc('col__order_line_refund__subtotal') }}" - name: subtotal_set description: "{{ doc('col__order_line_refund__subtotal_set') }}" - name: total_tax description: "{{ doc('col__order_line_refund__total_tax') }}" - name: total_tax_set description: "{{ doc('col__order_line_refund__total_tax_set') }}" - name: order_line_id description: "{{ doc('col__order_line_refund__order_line_id') }}" - name: _fivetran_synced description: "{{ doc('col___fivetran_synced') }}" - name: source_identifier description: "{{ doc('col__order_line_refund__source_identifier') }}" - name: v_order_url_tag description: > One row per URL parameter tag appended to an order's landing URL across all stores. Captures UTM parameters and other tracking tags from the URL at the time of order placement. Sourced from ORDER_URL_TAG tables. No PII fields; no masking applied. columns: - name: store_id description: "{{ doc('col__store_id') }}" - name: store_schema description: "{{ doc('col__store_schema') }}" - name: store_name description: "{{ doc('col__store_name') }}" - name: artist description: "{{ doc('col__artist') }}" - name: vendor_name description: "{{ doc('col__vendor_name') }}" - name: vendor_id description: "{{ doc('col__vendor_id') }}" - name: order_id description: "{{ doc('col__order_url_tag__order_id') }}" - name: key description: "{{ doc('col__order_url_tag__key') }}" - name: value description: "{{ doc('col__order_url_tag__value') }}" - name: _fivetran_synced description: "{{ doc('col___fivetran_synced') }}" - name: source_identifier description: "{{ doc('col__order_url_tag__source_identifier') }}" - name: v_product description: > One row per product across all stores. Contains product metadata including title, type, status, pricing range, SEO fields, and category taxonomy. Sourced from PRODUCT tables. No PII fields; no masking applied. columns: - name: store_id description: "{{ doc('col__store_id') }}" - name: store_schema description: "{{ doc('col__store_schema') }}" - name: store_name description: "{{ doc('col__store_name') }}" - name: artist description: "{{ doc('col__artist') }}" - name: vendor_name description: "{{ doc('col__vendor_name') }}" - name: vendor_id description: "{{ doc('col__vendor_id') }}" - name: product_id description: "{{ doc('col__product__product_id') }}" - name: title description: "{{ doc('col__product__title') }}" - name: handle description: "{{ doc('col__product__handle') }}" - name: vendor description: "{{ doc('col__product__vendor') }}" - name: product_type description: "{{ doc('col__product__product_type') }}" - name: status description: "{{ doc('col__product__status') }}" - name: published_at description: "{{ doc('col__product__published_at') }}" - name: published_at_date description: "{{ doc('col__published_at_date') }}" - name: created_at description: "{{ doc('col__product__created_at') }}" - name: created_at_date description: "{{ doc('col__created_at_date') }}" - name: updated_at description: "{{ doc('col__product__updated_at') }}" - name: updated_at_date description: "{{ doc('col__updated_at_date') }}" - name: template_suffix description: "{{ doc('col__product__template_suffix') }}" - name: published_scope description: "{{ doc('col__product__published_scope') }}" - name: body_html description: "{{ doc('col__product__body_html') }}" - name: description description: "{{ doc('col__product__description') }}" - name: description_html description: "{{ doc('col__product__description_html') }}" - name: seo_title description: "{{ doc('col__product__seo_title') }}" - name: seo_description description: "{{ doc('col__product__seo_description') }}" - name: requires_selling_plan description: "{{ doc('col__product__requires_selling_plan') }}" - name: tracks_inventory description: "{{ doc('col__product__tracks_inventory') }}" - name: total_inventory description: "{{ doc('col__product__total_inventory') }}" - name: has_out_of_stock_variants description: "{{ doc('col__product__has_out_of_stock_variants') }}" - name: has_only_default_variant description: "{{ doc('col__product__has_only_default_variant') }}" - name: has_variants_that_requires_components description: "{{ doc('col__product__has_variants_that_requires_components') }}" - name: is_gift_card description: "{{ doc('col__product__is_gift_card') }}" - name: gift_card_template_suffix description: "{{ doc('col__product__gift_card_template_suffix') }}" - name: online_store_preview_url description: "{{ doc('col__product__online_store_preview_url') }}" - name: legacy_resource_id description: "{{ doc('col__product__legacy_resource_id') }}" - name: featured_media_id description: "{{ doc('col__product__featured_media_id') }}" - name: min_variant_price_amount description: "{{ doc('col__product__min_variant_price_amount') }}" - name: min_variant_price_currency_code description: "{{ doc('col__product__min_variant_price_currency_code') }}" - name: max_variant_price_amount description: "{{ doc('col__product__max_variant_price_amount') }}" - name: max_variant_price_currency_code description: "{{ doc('col__product__max_variant_price_currency_code') }}" - name: compare_at_price_range_min_variant_compare_at_price_amount description: "{{ doc('col__product__compare_at_price_range_min_variant_compare_at_price_amount') }}" - name: compare_at_price_range_min_variant_compare_at_price_currency_code description: "{{ doc('col__product__compare_at_price_range_min_variant_compare_at_price_currency_code') }}" - name: compare_at_price_range_max_variant_compare_at_price_amount description: "{{ doc('col__product__compare_at_price_range_max_variant_compare_at_price_amount') }}" - name: compare_at_price_range_max_variant_compare_at_price_currency_code description: "{{ doc('col__product__compare_at_price_range_max_variant_compare_at_price_currency_code') }}" - name: category_id description: "{{ doc('col__product__category_id') }}" - name: category_name description: "{{ doc('col__product__category_name') }}" - name: category_level description: "{{ doc('col__product__category_level') }}" - name: category_full_name description: "{{ doc('col__product__category_full_name') }}" - name: category_parent_id description: "{{ doc('col__product__category_parent_id') }}" - name: category_is_leaf description: "{{ doc('col__product__category_is_leaf') }}" - name: category_is_root description: "{{ doc('col__product__category_is_root') }}" - name: category_is_archived description: "{{ doc('col__product__category_is_archived') }}" - name: category_ancestor_ids description: "{{ doc('col__product__category_ancestor_ids') }}" - name: category_children_ids description: "{{ doc('col__product__category_children_ids') }}" - name: metafield description: "{{ doc('col__product__metafield') }}" - name: _fivetran_deleted description: "{{ doc('col__product___fivetran_deleted') }}" - name: _fivetran_synced description: "{{ doc('col___fivetran_synced') }}" - name: source_identifier description: "{{ doc('col__product__source_identifier') }}" - name: v_product_tag description: > One row per tag on a Shopify product across all stores. Tags are merchant-defined labels used for filtering and organizing products (e.g. "new-release", "vinyl", "limited-edition"). Sourced from PRODUCT_TAG tables. No PII fields; no masking applied. columns: - name: store_id description: "{{ doc('col__store_id') }}" - name: store_schema description: "{{ doc('col__store_schema') }}" - name: store_name description: "{{ doc('col__store_name') }}" - name: artist description: "{{ doc('col__artist') }}" - name: vendor_name description: "{{ doc('col__vendor_name') }}" - name: vendor_id description: "{{ doc('col__vendor_id') }}" - name: product_id description: "{{ doc('col__product_tag__product_id') }}" - name: index description: "{{ doc('col__product_tag__index') }}" - name: value description: "{{ doc('col__product_tag__value') }}" - name: _fivetran_synced description: "{{ doc('col___fivetran_synced') }}" - name: source_identifier description: "{{ doc('col__product_tag__source_identifier') }}" - name: v_product_variant description: > One row per product variant across all stores. Each product has at least one variant; variants represent different options (size, color, format) of a product. Contains pricing, inventory, weight, and option values. Sourced from PRODUCT_VARIANT tables. No PII fields; no masking applied. columns: - name: store_id description: "{{ doc('col__store_id') }}" - name: store_schema description: "{{ doc('col__store_schema') }}" - name: store_name description: "{{ doc('col__store_name') }}" - name: artist description: "{{ doc('col__artist') }}" - name: vendor_name description: "{{ doc('col__vendor_name') }}" - name: vendor_id description: "{{ doc('col__vendor_id') }}" - name: product_variant_id description: "{{ doc('col__product_variant__product_variant_id') }}" - name: product_id description: "{{ doc('col__product_variant__product_id') }}" - name: inventory_item_id description: "{{ doc('col__product_variant__inventory_item_id') }}" - name: available_for_sale description: "{{ doc('col__product_variant__available_for_sale') }}" - name: image_id description: "{{ doc('col__product_variant__image_id') }}" - name: barcode description: "{{ doc('col__product_variant__barcode') }}" - name: title description: "{{ doc('col__product_variant__title') }}" - name: price description: "{{ doc('col__product_variant__price') }}" - name: compare_at_price description: "{{ doc('col__product_variant__compare_at_price') }}" - name: created_at description: "{{ doc('col__product_variant__created_at') }}" - name: created_at_date description: "{{ doc('col__created_at_date') }}" - name: sku description: "{{ doc('col__product_variant__sku') }}" - name: display_name description: "{{ doc('col__product_variant__display_name') }}" - name: position description: "{{ doc('col__product_variant__position') }}" - name: inventory_policy description: "{{ doc('col__product_variant__inventory_policy') }}" - name: inventory_quantity description: "{{ doc('col__product_variant__inventory_quantity') }}" - name: fulfillment_service description: "{{ doc('col__product_variant__fulfillment_service') }}" - name: legacy_resource_id description: "{{ doc('col__product_variant__legacy_resource_id') }}" - name: metafield description: "{{ doc('col__product_variant__metafield') }}" - name: inventory_management description: "{{ doc('col__product_variant__inventory_management') }}" - name: updated_at description: "{{ doc('col__product_variant__updated_at') }}" - name: updated_at_date description: "{{ doc('col__updated_at_date') }}" - name: taxable description: "{{ doc('col__product_variant__taxable') }}" - name: requires_components description: "{{ doc('col__product_variant__requires_components') }}" - name: sellable_online_quantity description: "{{ doc('col__product_variant__sellable_online_quantity') }}" - name: grams description: "{{ doc('col__product_variant__grams') }}" - name: tax_code description: "{{ doc('col__product_variant__tax_code') }}" - name: weight description: "{{ doc('col__product_variant__weight') }}" - name: weight_unit description: "{{ doc('col__product_variant__weight_unit') }}" - name: option_1 description: "{{ doc('col__product_variant__option_1') }}" - name: option_2 description: "{{ doc('col__product_variant__option_2') }}" - name: option_3 description: "{{ doc('col__product_variant__option_3') }}" - name: presentment_prices description: "{{ doc('col__product_variant__presentment_prices') }}" - name: _fivetran_synced description: "{{ doc('col___fivetran_synced') }}" - name: inventory_quantity_adjustment description: "{{ doc('col__product_variant__inventory_quantity_adjustment') }}" - name: old_inventory_quantity description: "{{ doc('col__product_variant__old_inventory_quantity') }}" - name: requires_shipping description: "{{ doc('col__product_variant__requires_shipping') }}" - name: source_identifier description: "{{ doc('col__product_variant__source_identifier') }}" - name: v_refund description: > One row per refund issued on a Shopify order across all stores. A refund is a partial or full reversal of a paid order. Sourced from REFUND tables. No PII fields; no masking applied. columns: - name: store_id description: "{{ doc('col__store_id') }}" - name: store_schema description: "{{ doc('col__store_schema') }}" - name: store_name description: "{{ doc('col__store_name') }}" - name: artist description: "{{ doc('col__artist') }}" - name: vendor_name description: "{{ doc('col__vendor_name') }}" - name: vendor_id description: "{{ doc('col__vendor_id') }}" - name: id description: "{{ doc('col__refund__id') }}" - name: created_at description: "{{ doc('col__refund__created_at') }}" - name: created_at_date description: "{{ doc('col__created_at_date') }}" - name: processed_at description: "{{ doc('col__refund__processed_at') }}" - name: processed_at_date description: "{{ doc('col__processed_at_date') }}" - name: note description: "{{ doc('col__refund__note') }}" - name: restock description: "{{ doc('col__refund__restock') }}" - name: user_id description: "{{ doc('col__refund__user_id') }}" - name: order_id description: "{{ doc('col__refund__order_id') }}" - name: total_duties_set description: "{{ doc('col__refund__total_duties_set') }}" - name: _fivetran_synced description: "{{ doc('col___fivetran_synced') }}" - name: source_identifier description: "{{ doc('col__refund__source_identifier') }}" - name: v_shop description: > One row per Shopify store (one row per schema) across all stores. Contains store-level configuration: domain, currency, timezone, tax settings, plan, and geographic details. Sourced from SHOP tables. No PII fields; no masking applied. columns: - name: store_id description: "{{ doc('col__store_id') }}" - name: store_schema description: "{{ doc('col__store_schema') }}" - name: store_name description: "{{ doc('col__store_name') }}" - name: artist description: "{{ doc('col__artist') }}" - name: vendor_name description: "{{ doc('col__vendor_name') }}" - name: vendor_id description: "{{ doc('col__vendor_id') }}" - name: id description: "{{ doc('col__shop__id') }}" - name: name description: "{{ doc('col__shop__name') }}" - name: email description: "{{ doc('col__shop__email') }}" - name: domain description: "{{ doc('col__shop__domain') }}" - name: province description: "{{ doc('col__shop__province') }}" - name: country description: "{{ doc('col__shop__country') }}" - name: address_1 description: "{{ doc('col__shop__address_1') }}" - name: address_2 description: "{{ doc('col__shop__address_2') }}" - name: zip description: "{{ doc('col__shop__zip') }}" - name: city description: "{{ doc('col__shop__city') }}" - name: phone description: "{{ doc('col__shop__phone') }}" - name: primary_locale description: "{{ doc('col__shop__primary_locale') }}" - name: country_code description: "{{ doc('col__shop__country_code') }}" - name: country_name description: "{{ doc('col__shop__country_name') }}" - name: currency description: "{{ doc('col__shop__currency') }}" - name: customer_email description: "{{ doc('col__shop__customer_email') }}" - name: timezone description: "{{ doc('col__shop__timezone') }}" - name: iana_timezone description: "{{ doc('col__shop__iana_timezone') }}" - name: shop_owner description: "{{ doc('col__shop__shop_owner') }}" - name: money_format description: "{{ doc('col__shop__money_format') }}" - name: money_with_currency_format description: "{{ doc('col__shop__money_with_currency_format') }}" - name: weight_unit description: "{{ doc('col__shop__weight_unit') }}" - name: province_code description: "{{ doc('col__shop__province_code') }}" - name: plan_name description: "{{ doc('col__shop__plan_name') }}" - name: plan_display_name description: "{{ doc('col__shop__plan_display_name') }}" - name: myshopify_domain description: "{{ doc('col__shop__myshopify_domain') }}" - name: money_in_emails_format description: "{{ doc('col__shop__money_in_emails_format') }}" - name: money_with_currency_in_emails_format description: "{{ doc('col__shop__money_with_currency_in_emails_format') }}" - name: cookie_consent_level description: "{{ doc('col__shop__cookie_consent_level') }}" - name: visitor_tracking_consent_preference description: "{{ doc('col__shop__visitor_tracking_consent_preference') }}" - name: source description: "{{ doc('col__shop__source') }}" - name: google_apps_domain description: "{{ doc('col__shop__google_apps_domain') }}" - name: enabled_presentment_currencies description: "{{ doc('col__shop__enabled_presentment_currencies') }}" - name: primary_location_id description: "{{ doc('col__shop__primary_location_id') }}" - name: latitude description: "{{ doc('col__shop__latitude') }}" - name: longitude description: "{{ doc('col__shop__longitude') }}" - name: created_at description: "{{ doc('col__shop__created_at') }}" - name: created_at_date description: "{{ doc('col__created_at_date') }}" - name: updated_at description: "{{ doc('col__shop__updated_at') }}" - name: updated_at_date description: "{{ doc('col__updated_at_date') }}" - name: taxes_included description: "{{ doc('col__shop__taxes_included') }}" - name: county_taxes description: "{{ doc('col__shop__county_taxes') }}" - name: tax_shipping description: "{{ doc('col__shop__tax_shipping') }}" - name: has_discounts description: "{{ doc('col__shop__has_discounts') }}" - name: has_gift_cards description: "{{ doc('col__shop__has_gift_cards') }}" - name: eligible_for_payments description: "{{ doc('col__shop__eligible_for_payments') }}" - name: requires_extra_payments_agreement description: "{{ doc('col__shop__requires_extra_payments_agreement') }}" - name: password_enabled description: "{{ doc('col__shop__password_enabled') }}" - name: has_storefront description: "{{ doc('col__shop__has_storefront') }}" - name: eligible_for_card_reader_giveaway description: "{{ doc('col__shop__eligible_for_card_reader_giveaway') }}" - name: force_ssl description: "{{ doc('col__shop__force_ssl') }}" - name: checkout_api_supported description: "{{ doc('col__shop__checkout_api_supported') }}" - name: multi_location_enabled description: "{{ doc('col__shop__multi_location_enabled') }}" - name: setup_required description: "{{ doc('col__shop__setup_required') }}" - name: pre_launch_enabled description: "{{ doc('col__shop__pre_launch_enabled') }}" - name: google_apps_login_enabled description: "{{ doc('col__shop__google_apps_login_enabled') }}" - name: auto_configure_tax_inclusivity description: "{{ doc('col__shop__auto_configure_tax_inclusivity') }}" - name: _fivetran_deleted description: "{{ doc('col__shop___fivetran_deleted') }}" - name: _fivetran_synced description: "{{ doc('col___fivetran_synced') }}" - name: source_identifier description: "{{ doc('col__shop__source_identifier') }}" - name: v_transaction description: > One row per payment transaction on a Shopify order across all stores. Each order may have multiple transactions (authorization, capture, refund). Sourced from TRANSACTION tables. PII masking: PAYMENT_CREDIT_CARD_NUMBER, PAYMENT_CREDIT_CARD_NAME, and AUTHORIZATION are masked to NULL. columns: - name: store_id description: "{{ doc('col__store_id') }}" - name: store_schema description: "{{ doc('col__store_schema') }}" - name: store_name description: "{{ doc('col__store_name') }}" - name: artist description: "{{ doc('col__artist') }}" - name: vendor_name description: "{{ doc('col__vendor_name') }}" - name: vendor_id description: "{{ doc('col__vendor_id') }}" - name: id description: "{{ doc('col__transaction__id') }}" - name: order_id description: "{{ doc('col__transaction__order_id') }}" - name: refund_id description: "{{ doc('col__transaction__refund_id') }}" - name: amount description: "{{ doc('col__transaction__amount') }}" - name: authorization description: "{{ doc('col__transaction__authorization') }}" - name: created_at description: "{{ doc('col__transaction__created_at') }}" - name: created_at_date description: "{{ doc('col__created_at_date') }}" - name: processed_at description: "{{ doc('col__transaction__processed_at') }}" - name: processed_at_date description: "{{ doc('col__processed_at_date') }}" - name: device_id description: "{{ doc('col__transaction__device_id') }}" - name: gateway description: "{{ doc('col__transaction__gateway') }}" - name: source_name description: "{{ doc('col__transaction__source_name') }}" - name: message description: "{{ doc('col__transaction__message') }}" - name: currency description: "{{ doc('col__transaction__currency') }}" - name: location_id description: "{{ doc('col__transaction__location_id') }}" - name: parent_id description: "{{ doc('col__transaction__parent_id') }}" - name: payment_avs_result_code description: "{{ doc('col__transaction__payment_avs_result_code') }}" - name: payment_credit_card_bin description: "{{ doc('col__transaction__payment_credit_card_bin') }}" - name: payment_cvv_result_code description: "{{ doc('col__transaction__payment_cvv_result_code') }}" - name: payment_credit_card_number description: "{{ doc('col__transaction__payment_credit_card_number') }}" - name: payment_credit_card_company description: "{{ doc('col__transaction__payment_credit_card_company') }}" - name: kind description: "{{ doc('col__transaction__kind') }}" - name: receipt description: "{{ doc('col__transaction__receipt') }}" - name: currency_exchange_id description: "{{ doc('col__transaction__currency_exchange_id') }}" - name: currency_exchange_adjustment description: "{{ doc('col__transaction__currency_exchange_adjustment') }}" - name: currency_exchange_original_amount description: "{{ doc('col__transaction__currency_exchange_original_amount') }}" - name: currency_exchange_final_amount description: "{{ doc('col__transaction__currency_exchange_final_amount') }}" - name: currency_exchange_currency description: "{{ doc('col__transaction__currency_exchange_currency') }}" - name: error_code description: "{{ doc('col__transaction__error_code') }}" - name: status description: "{{ doc('col__transaction__status') }}" - name: test description: "{{ doc('col__transaction__test') }}" - name: authorization_expires_at description: "{{ doc('col__transaction__authorization_expires_at') }}" - name: authorization_expires_at_date description: "{{ doc('col__authorization_expires_at_date') }}" - name: extended_authorization_standard_authorization_expires_at description: "{{ doc('col__transaction__extended_authorization_standard_authorization_expires_at') }}" - name: extended_authorization_standard_authorization_expires_at_date description: "{{ doc('col__extended_authorization_standard_authorization_expires_at_date') }}" - name: extended_authorization_extended_authorization_expires_at description: "{{ doc('col__transaction__extended_authorization_extended_authorization_expires_at') }}" - name: extended_authorization_extended_authorization_expires_at_date description: "{{ doc('col__extended_authorization_extended_authorization_expires_at_date') }}" - name: user_id description: "{{ doc('col__transaction__user_id') }}" - name: _fivetran_synced description: "{{ doc('col___fivetran_synced') }}" - name: payment_credit_card_wallet description: "{{ doc('col__transaction__payment_credit_card_wallet') }}" - name: payment_id description: "{{ doc('col__transaction__payment_id') }}" - name: payment_credit_card_expiration_month description: "{{ doc('col__transaction__payment_credit_card_expiration_month') }}" - name: payment_credit_card_expiration_year description: "{{ doc('col__transaction__payment_credit_card_expiration_year') }}" - name: payment_credit_card_name description: "{{ doc('col__transaction__payment_credit_card_name') }}" - name: source_identifier description: "{{ doc('col__transaction__source_identifier') }}" - name: v_shopify_stores_master description: "{{ doc('model__shopify_stores_master') }}" columns: - name: store_id description: "{{ doc('col__shopify_stores_master__store_id') }}" - name: store_schema description: "{{ doc('col__shopify_stores_master__store_schema') }}" - name: store_name description: "{{ doc('col__shopify_stores_master__store_name') }}" - name: vendor_name description: "{{ doc('col__shopify_stores_master__vendor_name') }}" - name: vendor_id description: "{{ doc('col__shopify_stores_master__vendor_id') }}" - name: artist description: "{{ doc('col__shopify_stores_master__artist') }}" - name: global_participant_id description: "{{ doc('col__shopify_stores_master__global_participant_id') }}" - name: multi_artist_store_artists description: "{{ doc('col__shopify_stores_master__multi_artist_store_artists') }}" - name: multi_artist_store description: "{{ doc('col__shopify_stores_master__multi_artist_store') }}" - name: brand description: "{{ doc('col__shopify_stores_master__brand') }}" - name: crm_territory description: "{{ doc('col__shopify_stores_master__crm_territory') }}" - name: crm_territory_id description: "{{ doc('col__shopify_stores_master__crm_territory_id') }}" - name: crm_label description: "{{ doc('col__shopify_stores_master__crm_label') }}" - name: crm_label_id description: "{{ doc('col__shopify_stores_master__crm_label_id') }}" - name: shopify_domain description: "{{ doc('col__shopify_stores_master__shopify_domain') }}" - name: custom_domain description: "{{ doc('col__shopify_stores_master__custom_domain') }}" - name: source description: "{{ doc('col__shopify_stores_master__source') }}" - name: source_identifier description: "{{ doc('col__shopify_stores_master__source_identifier') }}" - name: active description: "{{ doc('col__shopify_stores_master__active') }}" - name: first_paid_order_date description: "{{ doc('col__shopify_stores_master__first_paid_order_date') }}" - name: last_paid_order_date description: "{{ doc('col__shopify_stores_master__last_paid_order_date') }}" - name: last_refresh description: "{{ doc('col__shopify_stores_master__last_refresh') }}"