ClickHouse

Prerequisites
Connection Setup
1. Host and Port
2. Database
3. Username and Password
Write Modes
Append
Replace
Upsert

ClickHouse is a columnar analytical database. MantrixFlow connects via the HTTP interface (port 8123 by default).

Prerequisites

You need a ClickHouse server and a user with INSERT and CREATE TABLE permissions on the target database.

Connection Setup

1. Host and Port

Enter the ClickHouse host and port. Default HTTP port is 8123.

2. Database

Enter the database name. The table will be created in this database.

3. Username and Password

Enter the ClickHouse username and password.

Write Modes

Append

Appends rows to the existing table. ClickHouse MergeTree tables are optimised for append. The table is created if it does not exist.

Replace

Replaces the table. For MergeTree, this typically means dropping and recreating.

Upsert

ClickHouse supports ReplacingMergeTree for deduplication. Configure the engine and version column as needed.

Redshift

MSSQL (Destination)

Introduction

Getting started

Connections

Pipelines

Sync reference

Transformations

Platform

Prerequisites

Connection Setup

1. Host and Port

2. Database

3. Username and Password

Write Modes

Append

Replace

Upsert

Introduction

Getting started

Connections

Pipelines

Sync reference

Transformations

Platform

​Prerequisites

​Connection Setup

​1. Host and Port

​2. Database

​3. Username and Password

​Write Modes

​Append

​Replace

​Upsert

Prerequisites

Connection Setup

1. Host and Port

2. Database

3. Username and Password

Write Modes

Append

Replace

Upsert