create_table_on_premise_cluster.ts

import { createClient } from '@clickhouse/client' // or '@clickhouse/client-web'

// ClickHouse cluster - for example, as in our `docker-compose.cluster.yml`
void (async () => {
  const client = createClient()
  await client.command({
    // Sample macro definitions are located in `.docker/clickhouse/cluster/serverN_config.xml`
    query: `
      CREATE TABLE IF NOT EXISTS clickhouse_js_examples_local_cluster_table
      ON CLUSTER '{cluster}'
      (id UInt64, name String)
      ENGINE ReplicatedMergeTree(
        '/clickhouse/{cluster}/tables/{database}/{table}/{shard}',
        '{replica}'
      )
      ORDER BY (id)
    `,
    // Recommended for cluster usage.
    // By default, a query processing error might occur after the HTTP response was sent to the client.
    // See https://clickhouse.com/docs/en/interfaces/http/#response-buffering
    clickhouse_settings: {
      wait_end_of_query: 1,
    },
  })
  await client.close()
})()