missing semicolon on cubes/orders.yml - when adding a pre-aggregation

[pinale]

following the getting started tutorial https://cube.dev/docs/product/getting-started/core/create-a-project with the built-in database
when i add a pre-aggregation i get this error

i've tried to add the pre-aggregation code snippet to the cubes/orders.yml (manually) as well but in this case the error is:
Error during upload of dev_pre_aggregations.orders_main_11f2gsdh_2ee4v4df_1ime8pq-0.csv.gz create table: CREATE TABLE dev_pre_aggregations.orders_main_11f2gsdh_2ee4v4df_1ime8pq (orders__status varchar(255), orders__created_at_day timestamp, orders__count bigint): Internal: No such file or directory (os error 2)

cubes/orders.yml

cubes:
  - name: orders
    sql_table: public.orders
    data_source: default

    joins: []

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

      - name: status
        sql: status
        type: string

      - name: created_at
        sql: created_at
        type: time

      - name: completed_at
        sql: completed_at
        type: time

    measures:
      - name: count
        type: count

      - name: number
        sql: number
        type: sum

    pre_aggregations:
      - name: main
        measures:
          - orders.count
        dimensions:
          - orders.status
        timeDimension: orders.created_at
        granularity: day

[igorlukanin]

I can confirm that the Rollup Designer would not work for a new Cube Core project with a YAML data model.

[github-actions]

If you are interested in working on this issue, please leave a comment below and we will be happy to assign the issue to you.
If this is the first time you are contributing a Pull Request to Cube.js, please check our contribution guidelines.
You can also post any questions while contributing in the #contributors channel in the Cube.js Slack.

[kaptinlin]

I have the same issue.

[igorlukanin]

Looks like a duplicate of #7223, isn't it?

[smellyspice]

This is a popular bug. Another dupe 5989

[whtblktone]

Why close it. What's the result?