cubes:
  - name: cloud_resource_budget
    sql: >
      SELECT * FROM cloud_resource_budget WHERE deletedAt IS NULL
    data_source: default

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

    dimensions:
      - name: id
        sql: id
        type: number
        primary_key: true
        shown: true

      - name: resourceid
        sql: resourceID
        type: number

      - name: month
        sql: month
        type: string

    measures:
      - name: count
        type: count

      - name: amount
        sql: amount
        type: sum

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