usefulalgorithm
diff --git a/‎sqlglot/dialects/clickhouse.py‎
Lines changed: 1 addition & 0 deletions b/‎sqlglot/dialects/clickhouse.py‎
Lines changed: 1 addition & 0 deletions
diff --git a/‎tests/dialects/test_clickhouse.py‎
Lines changed: 8 additions & 0 deletions b/‎tests/dialects/test_clickhouse.py‎
Lines changed: 8 additions & 0 deletions
@@ -892,6 +892,7 @@ class Generator(generator.Generator):
         # There's no list in docs, but it can be found in Clickhouse code
         # see `ClickHouse/src/Parsers/ParserCreate*.cpp`
         ON_CLUSTER_TARGETS = {
+            "SCHEMA",  # Transpiled CREATE SCHEMA may have OnCluster property set
             "DATABASE",
             "TABLE",
             "VIEW",
 
@@ -622,6 +622,14 @@ def test_ddl(self):
         )
         self.assertEqual(create_with_cluster.sql("clickhouse"), "CREATE DATABASE foo ON CLUSTER c")
 
+        # Transpiled CREATE SCHEMA may have OnCluster property set
+        create_with_cluster = exp.Create(
+            this=db_table_expr,
+            kind="SCHEMA",
+            properties=exp.Properties(expressions=[exp.OnCluster(this=exp.to_identifier("c"))]),
+        )
+        self.assertEqual(create_with_cluster.sql("clickhouse"), "CREATE DATABASE foo ON CLUSTER c")
+
         ctas_with_comment = exp.Create(
             this=exp.table_("foo"),
             kind="TABLE",