dim_order_lines

version: 2

models:
  - name: dim_order_lines
    description: >
      The dim_order_lines is a dimensional table containing order line information derived from e-commerce transactions.

    columns:
      - name: smcid
        description: >
          The SourceMedium ID of a store, which is derived from the store's myshopify.com domain.
        tests:
          - not_null

      - name: sm_order_line_key
        description: >
          The unique order line key created by SourceMedium that can be used to join order line dimensions to related tables.
        tests:
          - not_null
          - unique

      - name: sm_order_key
        description: >
          The unique order key created by SourceMedium that can be used to join order dimensions to related tables.
        tests:
          - not_null

      - name: sm_product_key
        description: >
          The unique product key created by SourceMedium that can be used to join product dimensions to related tables.
        tests:
          - not_null

      - name: sm_product_variant_key
        description: >
          The unique product variant key created by SourceMedium that can be used to join product variant dimensions to related tables.
        tests:
          - not_null

      - name: source_system
        description: >
          The e-commerce source system used to facilitate a customer's order.

      - name: order_line_id
        description: >
          The ID of the order line.

      - name: product_variant_id
        description: >
          A unique identifier for the product variant generated by the source system.

      - name: sku
        description: >
          The stock keeping unit (SKU) of the product variant.

      - name: order_line_product_title
        description: >
          The title of the product variant that the order line represents.

      - name: order_line_product_variant_title
        description: >
          The title of the product variant that the order line represents.

      - name: order_cart_quantity
        description: >
          The number of items that were originally purchased in an order.