Database drivers
-
wrote on Mar 6, 2023, 5:13 PM last edited by
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! -
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!@as1111111 I guess you mean https://superset.apache.org/docs/databases/sql-server . I can add this to the base package itself.
-
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!@as1111111 I pushed an update. Can you please try with that?
-
wrote on Mar 7, 2023, 1:06 PM last edited by
Thanks for the fast update! Will test it.
-
-
-
wrote on Mar 7, 2023, 3:29 PM last edited by
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 triedpip 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.
-
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 triedpip 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.
-
wrote on Apr 3, 2023, 7:08 AM last edited by
@girish would it be possible to also add the BigQuery driver ?
command:
echo "sqlalchemy-bigquery" >> ./docker/requirements-local.txt
link: Superset BigQuery
-
@girish would it be possible to also add the BigQuery driver ?
command:
echo "sqlalchemy-bigquery" >> ./docker/requirements-local.txt
link: Superset BigQuery
-
wrote on Nov 28, 2023, 8:58 PM last edited by
Hi @girish would it be possible to add the Snowflake driver ?
Command:
echo "snowflake-sqlalchemy" >> ./docker/requirements-local.txt
-
Hi @girish would it be possible to add the Snowflake driver ?
Command:
echo "snowflake-sqlalchemy" >> ./docker/requirements-local.txt
@rapmac13160 added, please check in the latest package.
-
@rapmac13160 added, please check in the latest package.
wrote on Nov 29, 2023, 1:35 PM last edited by@girish It works very well, thanks!
-
wrote on May 9, 2024, 11:23 AM last edited by
@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).
-
@zeitrechnen sqlalchemy-bigquery is still there.
-
@zeitrechnen I managed to reproduce this. Can you please update to the latest package and check?
-
@zeitrechnen I managed to reproduce this. Can you please update to the latest package and check?
wrote on May 16, 2024, 7:05 AM last edited by@girish Many thanks! I updated to the latest version, and now I can select BigQuery. Great!
-
wrote on Jun 13, 2024, 7:11 PM last edited by
@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 -
@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 .