rusackas commented on code in PR #44870:
URL: https://github.com/apache/superset/pull/44870#discussion_r4163374548
##########
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 Connect with via PgBouncer
turned "
Review Comment:
```suggestion
"In ClickHouse Cloud, open Connect with PgBouncer turned
"
```
##########
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 Connect with via PgBouncer
turned off. 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.",
Review Comment:
```suggestion
"notes": "In ClickHouse Cloud, open Connect with PgBouncer
turned off. 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.",
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
