Hi @Addy0_, thanks for sharing how to set it for existing table. Unfortunately, I think ALTER cannot be used with materialized view and streaming tables defined in dlt pipelines.

I was looking for something similar to 

@dlt.table(cluster_by_auto=True, cluster_by=["id"])

that in sql would look like

CREATE MATERIALIZED VIEW tbl_with_auto_and_initial_hint
CLUSTER BY id AUTO AS
SELECT
    id,
    fare_amount
FROM source_table;

 But this code raises syntax error.