engine = "Set" not created on cluster mode

[ikeniborn]

{{ config( enabled = true ,full_refresh = false ,schema = 'set' ,tags = ["discreteness_hour","model_token"] ,engine = "Set" ,materialized = "incremental" ,incremental_strategy = 'append' ,settings = { 'persistent': 1 } ,pre_hook = [ "{{truncate_table_cluster(this)}}" ] ) }}

select t0.token_id as token_id from {{ref("snap_dim_token")}} t0 where empty(main_token_id) and token_coinmarketcap_is_active and token_category_id not in ( 'e5e3fd01-394b-9a81-296b-75d5a7f4c1a2' /* STABLECOIN / ) -- and token_id not in {{ref("set_dim_token_wrapped")}} and token_name not like '%WRAP%' and token_id not in ( '69c6b514-4293-1c8f-391b-40b376391c84' / LIDO STAKED ETH [STETH]*/ ) order by t0.updated_dttm desc limit 1 by t0.token_id

in log

[0m12:58:08.843851 [debug] [Thread-1 (]: dbt_clickhouse adapter: On model.clickhouse.set_dim_token_active: /* {"app": "dbt", "dbt_version": "1.7.4", "profile_name": "clickhouse", "target_name": "*****", "node_id": "model.clickhouse.set_dim_token_active"} */

    create table `set`.`set_dim_token_active`

engine = Set

    SETTINGS  persistent=1

        empty
      as (

select t0.token_id as token_id from snapshot.snap_dim_token t0 where empty(main_token_id) and token_coinmarketcap_is_active and token_category_id not in ( 'e5e3fd01-394b-9a81-296b-75d5a7f4c1a2' /* STABLECOIN / ) -- and token_id not in set.set_dim_token_wrapped and token_name not like '%WRAP%' and token_id not in ( '69c6b514-4293-1c8f-391b-40b376391c84' / LIDO STAKED ETH [STETH]*/ ) order by t0.updated_dttm desc limit 1 by t0.token_id ) ... Core:

installed: 1.7.4 latest: 1.7.4 - Up to date! Plugins:

clickhouse: 1.7.1 - Up to date! Clickhouse: ClickHouse 23.12.1.1368

[ikeniborn]

Up!