This is an automated email from the ASF dual-hosted git repository.
hainenber pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/superset.git
The following commit(s) were added to refs/heads/master by this push:
new 0fdfd6660e0 docs(databases): add ClickHouse Managed Postgres (#44870)
0fdfd6660e0 is described below
commit 0fdfd6660e0ac33280f6b075d8fd35ea735821b4
Author: Alasdair Brown <[email protected]>
AuthorDate: Fri Oct 2 16:25:27 2026 +0100
docs(databases): add ClickHouse Managed Postgres (#44870)
Co-authored-by: Đỗ Trọng Hải <[email protected]>
---
docs/src/data/databases.json | 19 +++++++++++++++++++
superset/db_engine_specs/postgres.py | 34 ++++++++++++++++++++++++++++++++++
2 files changed, 53 insertions(+)
diff --git a/docs/src/data/databases.json b/docs/src/data/databases.json
index 63748377220..e58f1bfb425 100644
--- a/docs/src/data/databases.json
+++ b/docs/src/data/databases.json
@@ -6965,6 +6965,25 @@
},
"notes": "Uses the Data API for serverless access. Standard
PostgreSQL connections also work with psycopg2.",
"categories": ["Cloud - AWS", "Hosted Open Source"]
+ },
+ {
+ "name": "ClickHouse Managed Postgres",
+ "description": "Managed PostgreSQL from ClickHouse.",
+ "logo": "clickhouse.png",
+ "homepage_url": "https://clickhouse.com/cloud/postgres";,
+ "pypi_packages": ["psycopg2"],
+ "connection_string":
"postgresql+psycopg2://{username}:{password}@{host}:{port}/{database}?sslmode=verify-full&sslrootcert={ca_certificate_path}",
+ "parameters": {
+ "username": "Database user",
+ "password": "URL-encoded database password",
+ "host": "Direct PostgreSQL hostname from the Connect dialog",
+ "port": "Port from the Connect dialog (default: 5432)",
+ "database": "Database name",
+ "ca_certificate_path": "URL-encoded absolute path to the
instance CA certificate on the Superset server"
+ },
+ "notes": "In ClickHouse Cloud, open the Connect menu and use the
Directly option. Download the instance-specific CA certificate from Settings
and make it available to each Superset process that connects to the database.
Use verify-full to verify the certificate and hostname.",
+ "docs_url":
"https://clickhouse.com/docs/products/managed-postgres/connection";,
+ "categories": ["HOSTED_OPEN_SOURCE"]
}
],
"category": "Traditional RDBMS",
diff --git a/superset/db_engine_specs/postgres.py
b/superset/db_engine_specs/postgres.py
index 6fcd10b85f2..11ca690fa3f 100644
--- a/superset/db_engine_specs/postgres.py
+++ b/superset/db_engine_specs/postgres.py
@@ -626,6 +626,40 @@ class PostgresEngineSpec(BasicParametersMixin,
PostgresBaseEngineSpec):
],
"known_incompatibilities":
AURORA_DATA_API_KNOWN_INCOMPATIBILITIES,
},
+ {
+ "name": "ClickHouse Managed Postgres",
+ "description": "Managed PostgreSQL from ClickHouse.",
+ "logo": "clickhouse.png",
+ "homepage_url": "https://clickhouse.com/cloud/postgres";,
+ "pypi_packages": ["psycopg2"],
+ "connection_string": (
+ "postgresql+psycopg2://{username}:{password}"
+ "@{host}:{port}/{database}?sslmode=verify-full"
+ "&sslrootcert={ca_certificate_path}"
+ ),
+ "parameters": {
+ "username": "Database user",
+ "password": "URL-encoded database password",
+ "host": "Direct PostgreSQL hostname from the Connect
dialog",
+ "port": "Port from the Connect dialog (default: 5432)",
+ "database": "Database name",
+ "ca_certificate_path": (
+ "URL-encoded absolute path to the instance CA
certificate "
+ "on the Superset server"
+ ),
+ },
+ "notes": (
+ "In ClickHouse Cloud, open the Connect menu and use the "
+ "Directly option. Download the instance-specific CA
certificate "
+ "from Settings and make it available to each Superset
process "
+ "that connects to the database. Use verify-full to verify "
+ "the certificate and hostname."
+ ),
+ "docs_url": (
+
"https://clickhouse.com/docs/products/managed-postgres/connection";
+ ),
+ "categories": [DatabaseCategory.HOSTED_OPEN_SOURCE],
+ },
],
}
# https://www.postgresql.org/docs/9.1/libpq-ssl.html#LIBQ-SSL-CERTIFICATES
