Dataset properties

Copy
models: # can be seeds, sources, and metrics as well.
  - name: customers
    description: List of customers
    meta:
     metriql:
      label: Customers
      hidden: false
      measures:
        total_rows:
          aggregation count
          dimension | column | sql <reference>
          filters <filters>
             // filtered measure
      dimensions
        full_location:
          column | sql <reference>
          type: string
      category User Segments
      mappings
        user_id: id
        event_timestamp: occurred_at
      relations
        events:
          to: ref('user_id')
      aggregates
        total_customers:
           measures: ['total_rows']
           dimensions: ['full_location']
      always_filters
        - {dimension: 'is_active', value: true}
    columns:
       country:
         description: The country the user signed up from
         meta:
           metriql.dimension:
              type string
              label User Country
              category Location
              hidden false
              primary false
              name location_country
       created_at:
         meta:
           metriql.dimension:
              type: timestamp
              timeframes [day, week, month, year] # only available for timestamp columns
       total_sales:
         meta:
           metriql.measure:
              aggregation sum