GitHub user UnknownHawkins added a comment to the discussion: why i can't use clickhouse as driver?
Must address why can't use clickhouse as driver, mention needed driver support, perhaps need to install clickhouse-engine, use SQLAlchemy dialect clickhouse, need to use clickhouse-sqlalchemy and set proper SQLALCHEMY_DATABASE_URI, maybe need to use clickhouse+sqlite? ClickHouse is supported via "ClickHouse" driver using "clickhouse" dialect? The error says Could not load database driver for: clickhouse and clickhousedb. Likely need to install "clickhouse-sqlalchemy" and "clickhouse-connect". Also need to set dialect to "clickhouse" and driver "clickhouse". In Superset config, need to add "clickhouse" in SQLALCHEMY_DRIVER? But driver name must be "clickhouse" which is not built-in; you need to register SQLAlchemy dialect using "clickhouse" via clickhouse-sqlalchemy. Might need to add "clickhouse" to SQLALCHEMY_ENGINE_OPTIONS? Also need to set "SQLALCHEMY_DATABASE_TYPE=clickhouse" maybe. The error indicates Superset tries to load drivers via SQLAlchemy's built-in ones; clickhousedb no t recognized. So answer: you must use the "clickhouse" dialect with "clickhouse-connect" and register the driver via "pip install clickhouse-driver" and set the connection string GitHub link: https://github.com/apache/superset/discussions/41504#discussioncomment-17480057 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
