original_sql pre aggregation not working with ClickHouse driver when it's a Replicated db

[or-keren]

Describe the bug
Using original_sql pre aggregation on ClickHouse driver doesn't work, due to CREATE AS SELECT operation not supported with Replicated databases.

Expected behavior
Using original_sql pre aggregation type on clickhouse driver should work on any database type, including Replicated one.

Screenshots

Minimally reproducible Cube Schema

- name: users_auto_complete_props
    sql: >
      select property_name, property_value, any(tenantId) as tenantId, max(date) as date from
      (SELECT tenantId, 
      toDate(eventTime / 1000) date,
      arrayJoin(JSONExtractKeys(ifNull(props, ''))) AS property_name,
      JSONExtractString(props, property_name) AS property_value
      From coho_db."users_replacing" where 
      tenantId = '{{ COMPILE_CONTEXT.securityContext.tenantId | safe }}' and 
      date > DATEADD(DAY,-2,today()) 
      AND date < today() and props is not null and property_value is not null)
      group by property_name, property_value
    
    dimensions:
      - name: property_name
        type: string
        sql: property_name

      - name: date
        type: time
        sql: date

      - name: property_value
        type: string
        sql: property_value 

      - name: tenant_id
        type: string
        sql: tenantId
        public: false

    pre_aggregations:
      - name: live
        type: rollup_lambda
        union_with_source_data: true
        rollups:
          - CUBE.batch

      - name: batch
        type: original_sql
        time_dimension: CUBE.date
        partition_granularity: month
        refresh_key:
          every: 1 day
        indexes:
          - name: main_index
            columns:
              - tenant_id
              - property_name

Version:
0.35.54

[github-actions]

If you are interested in working on this issue, please go ahead and provide PR for that.
We'd be happy to review it and merge it.
If this is the first time you are contributing a Pull Request to Cube, please check our contribution guidelines.
You can also post any questions while contributing in the #contributors channel in the Cube Slack.

[or-keren]

@igorlukanin Hey, I'd be happy to take this one. Can you direct me to the place that generates the SQL of CREATE TABLE while calculating the pre aggregation of original_sql?