Database drivers

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

[girish]

@creative567145 I have added it now. You have to use connection string like mysql+mysqlconnector://{username}:{password}@{host}/{database}