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

[rapmac13160]

Hi @girish would it be possible to add the Snowflake driver ?

Command:

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

link: https://superset.apache.org/docs/databases/snowflake

[girish]

@rapmac13160 added, please check in the latest package.

[rapmac13160]

@girish It works very well, thanks!

[zeitrechnen]

@girish Has the driver for BigQuery been removed? I cannot find BigQuery as a selection in the list of available databases (package version 1.6.0).

[girish]

@zeitrechnen sqlalchemy-bigquery is still there.

[girish]

@zeitrechnen I managed to reproduce this. Can you please update to the latest package and check?

[zeitrechnen]

@girish Many thanks! I updated to the latest version, and now I can select BigQuery. Great!

[creative567145]

@girish we are trying to connect a MySQL DB but it requires the following:
driver "mysql-connector-python"
Is it possilble for it to be installed by us or by your team (by pushing it in the new update)?
Thank you

[girish]

@creative567145 I was going to say that it works fine with ours but it seems newer MySQL needs that module per https://github.com/apache/superset/blob/3dadefcfb0f0f2da159bec549ca1ed87263a31b6/docs/docs/configuration/databases.mdx#mysql .