seeds.yml

version: 2
seeds:
  - name: customer
    meta: 
      metriql:
        measures:
          total_customers:
            aggregation: count
            report:   
              superset: 
                certification_details: buremba 
    columns:
      - name: c_custkey
      - name: c_name
        meta:
          metriql.dimension:
            type: string
      - name: c_address
      - name: c_nationkey
      - name: c_phone
      - name: c_acctbal
      - name: c_mktsegment
  - name: orders
    meta:
      metriql:
        measures:
          total_orders:
            aggregation: count
        relations:
          customer:
            to: ref('customer')
            source: o_custkey
            target: c_custkey
            relationship: one_to_one
            type: left_join
    columns:
      - name: o_orderkey
      - name: o_custkey
        meta:
          metriql.measure:
            name: unique_users
            aggregation: count_unique
      - name: o_orderstatus
      - name: o_totalprice
        meta:
          metriql.measure:
            aggregation: sum
            name: total_price
      - name: o_orderdate
      - name: o_orderpriority
        meta:
          metriql.dimension:
            type: string
      - name: o_clerk
      - name: o_shippriority
metrics:
  - name: important_orders
    model: ref('orders')
    label: Important Order Counts
    description: "Imported orders from our customers"
    type: count
    sql: "1"
    timestamp: o_orderdate
    time_grains: [day, week, month, year]

    dimensions:
      - "customer.c_mktsegment"
      - o_clerk
      - o_orderpriority
    
    filters:
      - field: o_orderpriority
        operator: "!="
        value: "'test'"
    meta:
        metriql:
          hidden: false
    tags:
      - okrs
  - name: paid_users
    model: ref('orders')
    label: Paid Users
    type: count_distinct
    sql: o_custkey
    timestamp: o_orderdate
    time_grains: [day, week, month]
    dimensions:
      - "customer.c_mktsegments"