This is an automated email from the ASF dual-hosted git repository.
rusackas pushed a commit to branch athena-doc-fix
in repository https://gitbox.apache.org/repos/asf/superset.git
The following commit(s) were added to refs/heads/athena-doc-fix by this push:
new 05e8011446 lots o' markdown formatting
05e8011446 is described below
commit 05e80114469dd6bf5647d235a78d91ec4735ef50
Author: Evan Rusackas <[email protected]>
AuthorDate: Mon Nov 20 17:07:20 2023 -0700
lots o' markdown formatting
---
.../docs/databases/installing-database-drivers.mdx | 82 +++++++++++-----------
1 file changed, 41 insertions(+), 41 deletions(-)
diff --git a/docs/docs/databases/installing-database-drivers.mdx
b/docs/docs/databases/installing-database-drivers.mdx
index 0d5f8e7395..f698b7ab8e 100644
--- a/docs/docs/databases/installing-database-drivers.mdx
+++ b/docs/docs/databases/installing-database-drivers.mdx
@@ -22,47 +22,47 @@ as well as the packages needed to connect to the databases
you want to access th
Some of the recommended packages are shown below. Please refer to
[setup.py](https://github.com/apache/superset/blob/master/setup.py) for the
versions that are compatible with Superset.
-| Database | PyPI package
| Connection
String
|
-| --------------------------------------------------------- |
----------------------------------------------------------------------------------
|
-----------------------------------------------------------------------------------------------------------
|
-| [Amazon Athena](/docs/databases/athena) | `pip install
pyathena[pandas]` , `pip install PyAthenaJDBC` |
`awsathena+rest://{aws_access_key_id}:{aws_secret_access_key}@athena.{region_name}.amazonaws.com/{schema_name}?s3_staging_dir={s3_staging_dir}&...
` |
-| [Amazon DynamoDB](/docs/databases/dynamodb) | `pip install
pydynamodb` |
`dynamodb://{access_key_id}:{secret_access_key}@dynamodb.{region_name}.amazonaws.com?connector=superset`
|
-| [Amazon Redshift](/docs/databases/redshift) | `pip install
sqlalchemy-redshift` | `
redshift+psycopg2://<userName>:<DBPassword>@<AWS End Point>:5439/<Database
Name>` |
-| [Apache Drill](/docs/databases/drill) | `pip install
sqlalchemy-drill` |
`drill+sadrill:// For JDBC drill+jdbc://`
|
-| [Apache Druid](/docs/databases/druid) | `pip install
pydruid` |
`druid://<User>:<password>@<Host>:<Port-default-9088>/druid/v2/sql`
|
-| [Apache Hive](/docs/databases/hive) | `pip install
pyhive` |
`hive://hive@{hostname}:{port}/{database}`
|
-| [Apache Impala](/docs/databases/impala) | `pip install
impyla` |
`impala://{hostname}:{port}/{database}`
|
-| [Apache Kylin](/docs/databases/kylin) | `pip install
kylinpy` |
`kylin://<username>:<password>@<hostname>:<port>/<project>?<param1>=<value1>&<param2>=<value2>`
|
-| [Apache Pinot](/docs/databases/pinot) | `pip install
pinotdb` |
`pinot://BROKER:5436/query?server=http://CONTROLLER:5983/`
|
-| [Apache Solr](/docs/databases/solr) | `pip install
sqlalchemy-solr` |
`solr://{username}:{password}@{hostname}:{port}/{server_path}/{collection}`
|
-| [Apache Spark SQL](/docs/databases/spark-sql) | `pip install
pyhive` |
`hive://hive@{hostname}:{port}/{database}`
|
-| [Ascend.io](/docs/databases/ascend) | `pip install
impyla` |
`ascend://{username}:{password}@{hostname}:{port}/{database}?auth_mechanism=PLAIN;use_ssl=true`
|
-| [Azure MS SQL](/docs/databases/sql-server) | `pip install
pymssql` |
`mssql+pymssql://UserName@presetSQL:[email protected]:1433/TestSchema`
|
-| [Big Query](/docs/databases/bigquery) | `pip install
sqlalchemy-bigquery` |
`bigquery://{project_id}`
|
-| [ClickHouse](/docs/databases/clickhouse) | `pip install
clickhouse-connect` |
`clickhousedb://{username}:{password}@{hostname}:{port}/{database}`
|
-| [CockroachDB](/docs/databases/cockroachdb) | `pip install
cockroachdb` |
`cockroachdb://root@{hostname}:{port}/{database}?sslmode=disable`
|
-| [Dremio](/docs/databases/dremio) | `pip install
sqlalchemy_dremio` |
`dremio://user:pwd@host:31010/`
|
-| [Elasticsearch](/docs/databases/elasticsearch) | `pip install
elasticsearch-dbapi` |
`elasticsearch+http://{user}:{password}@{host}:9200/`
|
-| [Exasol](/docs/databases/exasol) | `pip install
sqlalchemy-exasol` |
`exa+pyodbc://{username}:{password}@{hostname}:{port}/my_schema?CONNECTIONLCALL=en_US.UTF-8&driver=EXAODBC`
|
-| [Google Sheets](/docs/databases/google-sheets) | `pip install
shillelagh[gsheetsapi]` |
`gsheets://`
|
-| [Firebolt](/docs/databases/firebolt) | `pip install
firebolt-sqlalchemy` |
`firebolt://{username}:{password}@{database} or
firebolt://{username}:{password}@{database}/{engine_name}` |
-| [Hologres](/docs/databases/hologres) | `pip install
psycopg2` |
`postgresql+psycopg2://<UserName>:<DBPassword>@<Database Host>/<Database Name>`
|
-| [IBM Db2](/docs/databases/ibm-db2) | `pip install
ibm_db_sa` |
`db2+ibm_db://`
|
-| [IBM Netezza Performance Server](/docs/databases/netezza) | `pip install
nzalchemy` |
`netezza+nzpy://<UserName>:<DBPassword>@<Database Host>/<Database Name>`
|
-| [MySQL](/docs/databases/mysql) | `pip install
mysqlclient` |
`mysql://<UserName>:<DBPassword>@<Database Host>/<Database Name>`
|
-| [Oracle](/docs/databases/oracle) | `pip install
cx_Oracle` |
`oracle://`
|
-| [PostgreSQL](/docs/databases/postgres) | `pip install
psycopg2` |
`postgresql://<UserName>:<DBPassword>@<Database Host>/<Database Name>`
|
-| [Presto](/docs/databases/presto) | `pip install
pyhive` |
`presto://`
|
-| [Rockset](/docs/databases/rockset) | `pip install
rockset-sqlalchemy` |
`rockset://<api_key>:@<api_server>`
|
-| [SAP Hana](/docs/databases/hana) | `pip install
hdbcli sqlalchemy-hana or pip install apache-superset[hana]` |
`hana://{username}:{password}@{host}:{port}`
|
-| [StarRocks](/docs/databases/starrocks) | `pip install
starrocks` |
`starrocks://<User>:<Password>@<Host>:<Port>/<Catalog>.<Database>`
|
-| [Snowflake](/docs/databases/snowflake) | `pip install
snowflake-sqlalchemy` |
`snowflake://{user}:{password}@{account}.{region}/{database}?role={role}&warehouse={warehouse}`
|
-| SQLite | No additional
library needed |
`sqlite://path/to/file.db?check_same_thread=false`
|
-| [SQL Server](/docs/databases/sql-server) | `pip install
pymssql` |
`mssql+pymssql://`
|
-| [Teradata](/docs/databases/teradata) | `pip install
teradatasqlalchemy` |
`teradatasql://{user}:{password}@{host}`
|
-| [TimescaleDB](/docs/databases/timescaledb) | `pip install
psycopg2` |
`postgresql://<UserName>:<DBPassword>@<Database Host>:<Port>/<Database Name>`
|
-| [Trino](/docs/databases/trino) | `pip install
trino` |
`trino://{username}:{password}@{hostname}:{port}/{catalog}`
|
-| [Vertica](/docs/databases/vertica) | `pip install
sqlalchemy-vertica-python` |
`vertica+vertica_python://<UserName>:<DBPassword>@<Database Host>/<Database
Name>` |
-| [YugabyteDB](/docs/databases/yugabytedb) | `pip install
psycopg2` |
`postgresql://<UserName>:<DBPassword>@<Database Host>/<Database Name>`
|
+| Database | PyPI package
| Connection
String
|
+| --------------------------------------------------------- |
----------------------------------------------------------------------------------
|
------------------------------------------------------------------------------------------------------------------------------------------------------
|
+| [Amazon Athena](/docs/databases/athena) | `pip install
pyathena[pandas]` , `pip install PyAthenaJDBC` |
`awsathena+rest://{aws_access_key_id}:{aws_secret_access_key}@athena.{region_name}.amazonaws.com/{schema_name}?s3_staging_dir={s3_staging_dir}&...
` |
+| [Amazon DynamoDB](/docs/databases/dynamodb) | `pip install
pydynamodb` |
`dynamodb://{access_key_id}:{secret_access_key}@dynamodb.{region_name}.amazonaws.com?connector=superset`
|
+| [Amazon Redshift](/docs/databases/redshift) | `pip install
sqlalchemy-redshift` | `
redshift+psycopg2://<userName>:<DBPassword>@<AWS End Point>:5439/<Database
Name>` |
+| [Apache Drill](/docs/databases/drill) | `pip install
sqlalchemy-drill` |
`drill+sadrill:// For JDBC drill+jdbc://`
|
+| [Apache Druid](/docs/databases/druid) | `pip install
pydruid` |
`druid://<User>:<password>@<Host>:<Port-default-9088>/druid/v2/sql`
|
+| [Apache Hive](/docs/databases/hive) | `pip install
pyhive` |
`hive://hive@{hostname}:{port}/{database}`
|
+| [Apache Impala](/docs/databases/impala) | `pip install
impyla` |
`impala://{hostname}:{port}/{database}`
|
+| [Apache Kylin](/docs/databases/kylin) | `pip install
kylinpy` |
`kylin://<username>:<password>@<hostname>:<port>/<project>?<param1>=<value1>&<param2>=<value2>`
|
+| [Apache Pinot](/docs/databases/pinot) | `pip install
pinotdb` |
`pinot://BROKER:5436/query?server=http://CONTROLLER:5983/`
|
+| [Apache Solr](/docs/databases/solr) | `pip install
sqlalchemy-solr` |
`solr://{username}:{password}@{hostname}:{port}/{server_path}/{collection}`
|
+| [Apache Spark SQL](/docs/databases/spark-sql) | `pip install
pyhive` |
`hive://hive@{hostname}:{port}/{database}`
|
+| [Ascend.io](/docs/databases/ascend) | `pip install
impyla` |
`ascend://{username}:{password}@{hostname}:{port}/{database}?auth_mechanism=PLAIN;use_ssl=true`
|
+| [Azure MS SQL](/docs/databases/sql-server) | `pip install
pymssql` |
`mssql+pymssql://UserName@presetSQL:[email protected]:1433/TestSchema`
|
+| [Big Query](/docs/databases/bigquery) | `pip install
sqlalchemy-bigquery` |
`bigquery://{project_id}`
|
+| [ClickHouse](/docs/databases/clickhouse) | `pip install
clickhouse-connect` |
`clickhousedb://{username}:{password}@{hostname}:{port}/{database}`
|
+| [CockroachDB](/docs/databases/cockroachdb) | `pip install
cockroachdb` |
`cockroachdb://root@{hostname}:{port}/{database}?sslmode=disable`
|
+| [Dremio](/docs/databases/dremio) | `pip install
sqlalchemy_dremio` |
`dremio://user:pwd@host:31010/`
|
+| [Elasticsearch](/docs/databases/elasticsearch) | `pip install
elasticsearch-dbapi` |
`elasticsearch+http://{user}:{password}@{host}:9200/`
|
+| [Exasol](/docs/databases/exasol) | `pip install
sqlalchemy-exasol` |
`exa+pyodbc://{username}:{password}@{hostname}:{port}/my_schema?CONNECTIONLCALL=en_US.UTF-8&driver=EXAODBC`
|
+| [Google Sheets](/docs/databases/google-sheets) | `pip install
shillelagh[gsheetsapi]` |
`gsheets://`
|
+| [Firebolt](/docs/databases/firebolt) | `pip install
firebolt-sqlalchemy` |
`firebolt://{username}:{password}@{database} or
firebolt://{username}:{password}@{database}/{engine_name}`
|
+| [Hologres](/docs/databases/hologres) | `pip install
psycopg2` |
`postgresql+psycopg2://<UserName>:<DBPassword>@<Database Host>/<Database Name>`
|
+| [IBM Db2](/docs/databases/ibm-db2) | `pip install
ibm_db_sa` |
`db2+ibm_db://`
|
+| [IBM Netezza Performance Server](/docs/databases/netezza) | `pip install
nzalchemy` |
`netezza+nzpy://<UserName>:<DBPassword>@<Database Host>/<Database Name>`
|
+| [MySQL](/docs/databases/mysql) | `pip install
mysqlclient` |
`mysql://<UserName>:<DBPassword>@<Database Host>/<Database Name>`
|
+| [Oracle](/docs/databases/oracle) | `pip install
cx_Oracle` |
`oracle://`
|
+| [PostgreSQL](/docs/databases/postgres) | `pip install
psycopg2` |
`postgresql://<UserName>:<DBPassword>@<Database Host>/<Database Name>`
|
+| [Presto](/docs/databases/presto) | `pip install
pyhive` |
`presto://`
|
+| [Rockset](/docs/databases/rockset) | `pip install
rockset-sqlalchemy` |
`rockset://<api_key>:@<api_server>`
|
+| [SAP Hana](/docs/databases/hana) | `pip install
hdbcli sqlalchemy-hana or pip install apache-superset[hana]` |
`hana://{username}:{password}@{host}:{port}`
|
+| [StarRocks](/docs/databases/starrocks) | `pip install
starrocks` |
`starrocks://<User>:<Password>@<Host>:<Port>/<Catalog>.<Database>`
|
+| [Snowflake](/docs/databases/snowflake) | `pip install
snowflake-sqlalchemy` |
`snowflake://{user}:{password}@{account}.{region}/{database}?role={role}&warehouse={warehouse}`
|
+| SQLite | No additional
library needed |
`sqlite://path/to/file.db?check_same_thread=false`
|
+| [SQL Server](/docs/databases/sql-server) | `pip install
pymssql` |
`mssql+pymssql://`
|
+| [Teradata](/docs/databases/teradata) | `pip install
teradatasqlalchemy` |
`teradatasql://{user}:{password}@{host}`
|
+| [TimescaleDB](/docs/databases/timescaledb) | `pip install
psycopg2` |
`postgresql://<UserName>:<DBPassword>@<Database Host>:<Port>/<Database Name>`
|
+| [Trino](/docs/databases/trino) | `pip install
trino` |
`trino://{username}:{password}@{hostname}:{port}/{catalog}`
|
+| [Vertica](/docs/databases/vertica) | `pip install
sqlalchemy-vertica-python` |
`vertica+vertica_python://<UserName>:<DBPassword>@<Database Host>/<Database
Name>` |
+| [YugabyteDB](/docs/databases/yugabytedb) | `pip install
psycopg2` |
`postgresql://<UserName>:<DBPassword>@<Database Host>/<Database Name>`
|
---
Note that many other databases are supported, the main criteria being the
existence of a functional
