Generated SQL for simple metrics in not correct

[SebZbp]

Count_distinct aggregations are not generated properly.

Example

models:
  - name: test
    table: (SELECT 1 as id, 100 as value)
    primary_key: id
    metrics:
      - name: total
        agg: sum
        sql: value
  - name: location
    table: LOCKERS_AGGREGATION__DEV.METRICS.DIM_LOCATION
    primary_key: sk_location_id
    metrics:
      - name: count
        agg: count_distinct

generates for location.count

WITH location_cte AS (
  SELECT
    sk_location_id AS sk_location_id,
    count AS count_raw
  FROM LOCKERS_AGGREGATION__DEV.METRICS.DIM_LOCATION
)
SELECT
  COUNT(DISTINCT location_cte.count_raw) AS count
FROM location_cte
-- sidemantic: models=location metrics=location.count dimensions=

and count does not exist in the table

[nicosuave]

I added a significant amount of test coverage patched up a good deal of bugs (including a fix for this one) in v0.5.0 if you want to give that a shot. Thanks!

[SebZbp]

Using 0.5.0, above example works. But once I had a segment, needed columns are not added to the CTE.

[nicosuave]

I made a change that hopefully helps with this.

Can you share your segment definition as well? Thanks

[SebZbp]

Thanks, I will retry as soon as I can.
Regarding the segmants, it's a very basic filter:

    segments:
      - name: lockers_3000
        description: lockers in 3000 Leuven
        sql: zipcode = '3000'
      - name: lockers_7090
        description: lockers in 7090 Braine-le-Comte
        sql: zipcode = '7090'