cubes:
  - name: cloud_product_cost
    sql: >
      SELECT * FROM cloud_product_cost
    data_source: default

    joins:
      - name: cloud_resource
        relationship: many_to_one
        sql: "{CUBE}.resourceID = {cloud_resource.id}"

    dimensions:
      - name: uniqueid
        sql: "CONCAT(resourceID, '-', date, '-', productID)"
        type: string
        primary_key: true

      - name: productname
        sql: productName
        type: string

      - name: resourceid
        sql: resourceID
        type: number

      - name: createdat
        sql: createdAt
        type: time

      - name: date
        sql: date
        type: time

    measures:
      - name: count
        type: count

      - name: cost
        sql: cost
        type: sum

    pre_aggregations:
      # Pre-aggregation definitions go here.
      # Learn more in the documentation: https://cube.dev/docs/caching/pre-aggregations/getting-started