Hi! Im replicating Postgres table to Clickhouse, in my setup sling automatically configure target table with NULL-able columns, is there a way to control that (which column is NUllbale or not) ? I tried this, but stil see colums Nullable(T) in click

streams:
  bi.bi_tasks:
    mode: full-refresh
    primary_key: id
    update_key: create_ts
    columns:
      id: uuid | value is not null
      create_ts: timestamptz | value is not null
      is_deleted: bool | value is not null

hey @igrp try

target_options.table_ddl

https://docs.slingdata.io/concepts/replication/target-options#table-ddl

Thank you! Currently I use table_dll to define table structure I need, however with 100+ colums it look a bit messy in YAML.

@igrp agreed! here's the plan to improve the UX, something like this

yaml
streams:
  bi.bi_tasks:
    mode: full-refresh
    primary_key: id
    update_key: create_ts
    columns:
      id: uuid not null # not null would translate into DDL
      create_ts: timestamptz not null  # same here
      is_deleted: bool not null | value is not null  # ddl + runtime constraints enabled here