RisingWave SQL Assistant

    Public Preview
    WebsiteGitHubSlack

    This tool is in Public Preview and may contain errors or inaccuracies.

    Please refer to the official RisingWave documentation for accurate and up-to-date information.

    ClickHouse Sink

    Generate CREATE SINK for ClickHouse

    Connection

    Connect to ClickHouse via HTTP interface. Ensure the target table exists with matching schema.

    HTTP interface URL (default port 8123).

    Target ClickHouse table name.

    Sink Configuration

    For upsert sinks, only specific MergeTree engines are supported. ReplacingMergeTree engines allow specifying a delete column.

    Append-only for insert-only data, Upsert for updates/deletes.

    Table engine must match sink type. For upsert, only specific engines are supported.

    Source

    Specify the RisingWave source (table/MV) or write a custom query to transform data before sinking.

    Advanced Options

    Configure advanced sink behavior including commit intervals and retry policies.

    Number of RisingWave checkpoints between commits to ClickHouse (default: 10).

    Maximum retry attempts on failure (default: 3).

    SQL Preview

    Ready to Generate SQL

    Fill in the required fields on the left to generate your RisingWave SQL statement. The preview will update automatically as you enter information.

    💡 Quick Start:

    • • Start with the required fields marked with red asterisks (*)
    • • Use the Verify button to check for missing fields
    • • Copy the generated SQL when ready