How to configure ClickHouse as a destination in Mage to write data to a ClickHouse database.
Key | Description | Example Value | Required |
---|---|---|---|
sqlalchemy_url | SQLAlchemy connection string used to connect to ClickHouse. Includes host, user, password, etc. | clickhouse://default:@localhost/default | ✅ |
table_name | (Optional) Name of the destination table to write data into. If omitted, the stream name will be used. | abc123 | ❌ |
sqlalchemy_url
should follow this structure:
clickhouse://default:@localhost/default
clickhouse://user:pass123@127.0.0.1:9000/analytics_db
clickhouse-connect
Python package to be installed.table_name
is not provided?