Database drivers

[as1111111]

Thanks for offering Superset in Cloudron!

Is there a simple way to install additional database drivers? In our case we would like to connect a Microsoft SQL server.
According to the superset documentation at https://superset.apache.org/docs/databases/docker-add-drivers I should create a textfile as follows:

touch ./docker/requirements-local.txt

followed by

echo "mysqlclient" >> ./docker/requirements-local.txt

Or is this possible via the env.sh file?
Thanks for your help!

[girish]

@as1111111 I guess you mean https://superset.apache.org/docs/databases/sql-server . I can add this to the base package itself.

[girish]

@as1111111 I pushed an update. Can you please try with that?

[as1111111]

Thanks for the fast update! Will test it.

[as1111111]

It's working. Thanks @girish !

[Antonis]

Hi Community! Hi girish! Is it possible for you to add clickhouse support to the base package?
Or, is it possible for me to add it after the istallation?
I tried pip install clickhouse-connect on terminal
but I got an
ERROR: Could not install packages due to an OSError: [Errno 30] Read-only file system: '/app/code/venv/lib/python3.8/site-packages/zstandard'

I am new cloudron user and this is my first post here. I want to thank you all for this precious piece of software and your valuable support.

[girish]

@Antonis added it now to the package.

[Antonis]

@girish it took 2 minutes to upgrade and start querying my clickhouse! Pure magic! Thank you very much

[aurelie]

@girish would it be possible to also add the BigQuery driver ?

command:

echo "sqlalchemy-bigquery" >> ./docker/requirements-local.txt

link: Superset BigQuery

[girish]

@aurelie added this now, please check in the latest package.

[aurelie]

@girish thank you very much, confirming it work great