suedschwede opened a new issue #13285:
URL: https://github.com/apache/superset/issues/13285


   At the moment there are two superset drivers 
"clickhouse-sqlalchemy","sqlalchemy-clickhouse"
   
   There are problems with both drivers and that leads to a lot of questions
   
   **sqlalchemy-clickhouse**
   
   - Table with 128 Columns  - Datasets sync of column does not work correctly 
- it seems there is a maximum columns you can use
   - If the default user has a password you must use 
"infi.clickhouse_orm==1.0.4"
   - using a dictionary you get "Python int too large to convert to C long"
   
   **clickhouse-sqlalchemy**
   
   - Sync of columns you get wrong data types e.g.: "NULLABLE(STRING)" instead 
of "STRING"
   
   
   For me the only stable driver is "clickhouse-sqlalchemy" with the native 
interface
   
   The documentation should recommend "clickhouse-sqlalchemy" instead of 
"sqlalchemy-clickhouse"
   https://superset.apache.org/docs/databases/installing-database-drivers
   
   It would be nice if the columns sync works correctly with 
"clickhouse-sqlalchemy"
   


----------------------------------------------------------------
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.

For queries about this service, please contact Infrastructure at:
[email protected]



---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to