You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@superset.apache.org by sr...@apache.org on 2021/02/23 19:32:51 UTC
[superset] branch master updated: docs: Connecting to Trino
Databases (#13171)
This is an automated email from the ASF dual-hosted git repository.
srini pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/superset.git
The following commit(s) were added to refs/heads/master by this push:
new e8114be docs: Connecting to Trino Databases (#13171)
e8114be is described below
commit e8114be99aa4c68b02108c80705e1b927a199f66
Author: Đặng Minh Dũng <du...@live.com>
AuthorDate: Wed Feb 24 02:32:21 2021 +0700
docs: Connecting to Trino Databases (#13171)
* feat: add trino logo
Signed-off-by: Đặng Minh Dũng <du...@live.com>
* chores: update image links in README.md
Signed-off-by: Đặng Minh Dũng <du...@live.com>
* docs: add Trino Connecting to Databases doc
Signed-off-by: Đặng Minh Dũng <du...@live.com>
---
README.md | 53 +++++++++++----------
.../pages/docs/Connecting to Databases/index.mdx | 1 +
.../pages/docs/Connecting to Databases/trino.mdx | 17 +++++++
superset-frontend/images/trino.png | Bin 0 -> 23773 bytes
4 files changed, 45 insertions(+), 26 deletions(-)
diff --git a/README.md b/README.md
index 31190ad..673684d 100644
--- a/README.md
+++ b/README.md
@@ -52,27 +52,27 @@ A modern, enterprise-ready business intelligence web application.
**Gallery**
-<kbd><a href="https://superset.apache.org/gallery"><img title="Gallery" src="https://raw.githubusercontent.com/apache/superset/master/superset-frontend/images/screenshots/gallery.jpg"></a></kbd><br/>
+<kbd><a href="https://superset.apache.org/gallery"><img title="Gallery" src="superset-frontend/images/screenshots/gallery.jpg"></a></kbd><br/>
**View Dashboards**
-<kbd><img title="View Dashboards" src="https://raw.githubusercontent.com/apache/superset/master/superset-frontend/images/screenshots/slack_dash.jpg"></kbd><br/>
+<kbd><img title="View Dashboards" src="superset-frontend/images/screenshots/slack_dash.jpg"></kbd><br/>
**Slice & dice your data**
-<kbd><img title="Slice & dice your data" src="https://raw.githubusercontent.com/apache/superset/master/superset-frontend/images/screenshots/explore.jpg"></kbd><br/>
+<kbd><img title="Slice & dice your data" src="superset-frontend/images/screenshots/explore.jpg"></kbd><br/>
**Query and visualize your data with SQL Lab**
-<kbd><img title="SQL Lab" src="https://raw.githubusercontent.com/apache/superset/master/superset-frontend/images/screenshots/sql_lab.jpg"></kbd><br/>
+<kbd><img title="SQL Lab" src="superset-frontend/images/screenshots/sql_lab.jpg"></kbd><br/>
**Visualize geospatial data with deck.gl**
-<kbd><img title="Geospatial" src="https://raw.githubusercontent.com/apache/superset/master/superset-frontend/images/screenshots/geospatial_dash.jpg"></kbd><br/>
+<kbd><img title="Geospatial" src="superset-frontend/images/screenshots/geospatial_dash.jpg"></kbd><br/>
**Choose from a wide array of visualizations**
-<kbd><img title="Visualizations" src="https://raw.githubusercontent.com/apache/superset/master/superset-frontend/images/screenshots/explore_visualizations.jpg"></kbd><br/>
+<kbd><img title="Visualizations" src="superset-frontend/images/screenshots/explore_visualizations.jpg"></kbd><br/>
## Why Superset?
@@ -102,26 +102,27 @@ Superset can query data from any SQL-speaking datastore or data engine (e.g. Pre
Here are some of the major database solutions that are supported:
<p align="center">
- <img src="https://raw.githubusercontent.com/apache/superset/master/superset-frontend/images/redshift.png" alt="redshift" border="0" width="106" height="41"/>
- <img src="https://raw.githubusercontent.com/apache/superset/master/superset-frontend/images/google-biquery.png" alt="google-biquery" border="0" width="114" height="43"/>
- <img src="https://raw.githubusercontent.com/apache/superset/master/superset-frontend/images/snowflake.png" alt="snowflake" border="0" width="152" height="46"/>
- <img src="https://raw.githubusercontent.com/apache/superset/master/superset-frontend/images/presto.png" alt="presto" border="0" width="152" height="46"/>
- <img src="https://raw.githubusercontent.com/apache/superset/master/superset-frontend/images/druid.png" alt="druid" border="0" width="135" height="37" />
- <img src="https://raw.githubusercontent.com/apache/superset/master/superset-frontend/images/postgresql.png" alt="postgresql" border="0" width="132" height="81" />
- <img src="https://raw.githubusercontent.com/apache/superset/master/superset-frontend/images/mysql.png" alt="mysql" border="0" width="119" height="62" />
- <img src="https://raw.githubusercontent.com/apache/superset/master/superset-frontend/images/mssql-server.png" alt="mssql-server" border="0" width="93" height="74" />
- <img src="https://raw.githubusercontent.com/apache/superset/master/superset-frontend/images/db2.png" alt="db2" border="0" width="62" height="62" />
- <img src="https://raw.githubusercontent.com/apache/superset/master/superset-frontend/images/sqlite.png" alt="sqlite" border="0" width="102" height="45" />
- <img src="https://raw.githubusercontent.com/apache/superset/master/superset-frontend/images/sybase.png" alt="sybase" border="0" width="128" height="47" />
- <img src="https://raw.githubusercontent.com/apache/superset/master/superset-frontend/images/mariadb.png" alt="mariadb" border="0" width="83" height="63" />
- <img src="https://raw.githubusercontent.com/apache/superset/master/superset-frontend/images/vertica.png" alt="vertica" border="0" width="128" height="40" />
- <img src="https://raw.githubusercontent.com/apache/superset/master/superset-frontend/images/oracle.png" alt="oracle" border="0" width="121" height="66" />
- <img src="https://raw.githubusercontent.com/apache/superset/master/superset-frontend/images/firebird.png" alt="firebird" border="0" width="86" height="56" />
- <img src="https://raw.githubusercontent.com/apache/superset/master/superset-frontend/images/greenplum.png" alt="greenplum" border="0" width="140" height="45" />
- <img src="https://raw.githubusercontent.com/apache/superset/master/superset-frontend/images/clickhouse.png" alt="clickhouse" border="0" width="133" height="34" />
- <img src="https://raw.githubusercontent.com/apache/superset/master/superset-frontend/images/exasol.png" alt="exasol" border="0" width="106" height="59" />
- <img src="https://raw.githubusercontent.com/apache/superset/master/superset-frontend/images/monet-db.png" alt="monet-db" border="0" width="106" height="46" />
- <img src="https://raw.githubusercontent.com/apache/superset/master/superset-frontend/images/apache-kylin.png" alt="apache-kylin" border="0" width="56" height="64"/>
+ <img src="superset-frontend/images/redshift.png" alt="redshift" border="0" width="106" height="41"/>
+ <img src="superset-frontend/images/google-biquery.png" alt="google-biquery" border="0" width="114" height="43"/>
+ <img src="superset-frontend/images/snowflake.png" alt="snowflake" border="0" width="152" height="46"/>
+ <img src="superset-frontend/images/trino.png" alt="trino" border="0" width="46" height="46"/>
+ <img src="superset-frontend/images/presto.png" alt="presto" border="0" width="152" height="46"/>
+ <img src="superset-frontend/images/druid.png" alt="druid" border="0" width="135" height="37" />
+ <img src="superset-frontend/images/postgresql.png" alt="postgresql" border="0" width="132" height="81" />
+ <img src="superset-frontend/images/mysql.png" alt="mysql" border="0" width="119" height="62" />
+ <img src="superset-frontend/images/mssql-server.png" alt="mssql-server" border="0" width="93" height="74" />
+ <img src="superset-frontend/images/db2.png" alt="db2" border="0" width="62" height="62" />
+ <img src="superset-frontend/images/sqlite.png" alt="sqlite" border="0" width="102" height="45" />
+ <img src="superset-frontend/images/sybase.png" alt="sybase" border="0" width="128" height="47" />
+ <img src="superset-frontend/images/mariadb.png" alt="mariadb" border="0" width="83" height="63" />
+ <img src="superset-frontend/images/vertica.png" alt="vertica" border="0" width="128" height="40" />
+ <img src="superset-frontend/images/oracle.png" alt="oracle" border="0" width="121" height="66" />
+ <img src="superset-frontend/images/firebird.png" alt="firebird" border="0" width="86" height="56" />
+ <img src="superset-frontend/images/greenplum.png" alt="greenplum" border="0" width="140" height="45" />
+ <img src="superset-frontend/images/clickhouse.png" alt="clickhouse" border="0" width="133" height="34" />
+ <img src="superset-frontend/images/exasol.png" alt="exasol" border="0" width="106" height="59" />
+ <img src="superset-frontend/images/monet-db.png" alt="monet-db" border="0" width="106" height="46" />
+ <img src="superset-frontend/images/apache-kylin.png" alt="apache-kylin" border="0" width="56" height="64"/>
<img src="superset-frontend/images/hologres.png" alt="hologres" border="0" width="71" height="64"/>
</p>
diff --git a/docs/src/pages/docs/Connecting to Databases/index.mdx b/docs/src/pages/docs/Connecting to Databases/index.mdx
index dc48db1..f6f36e3 100644
--- a/docs/src/pages/docs/Connecting to Databases/index.mdx
+++ b/docs/src/pages/docs/Connecting to Databases/index.mdx
@@ -43,6 +43,7 @@ A list of some of the recommended packages.
|[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/postgresql)|```pip install psycopg2```|```postgresql://<UserName>:<DBPassword>@<Database Host>/<Database Name>```|
+|[Trino](/docs/databases/trino)|```pip install sqlalchemy-trino```|```trino://{username}:{password}@{hostname}:{port}/{catalog}```|
|[Presto](/docs/databases/presto)|```pip install pyhive```|```presto://```|
|[SAP Hana](/docs/databases/hana)|```pip install hdbcli sqlalchemy-hana or pip install apache-superset[hana]```|```hana://{username}:{password}@{host}:{port}```|
|[Snowflake](/docs/databases/snowflake)|```pip install snowflake-sqlalchemy```|```snowflake://{user}:{password}@{account}.{region}/{database}?role={role}&warehouse={warehouse}```|
diff --git a/docs/src/pages/docs/Connecting to Databases/trino.mdx b/docs/src/pages/docs/Connecting to Databases/trino.mdx
new file mode 100644
index 0000000..c818f6c
--- /dev/null
+++ b/docs/src/pages/docs/Connecting to Databases/trino.mdx
@@ -0,0 +1,17 @@
+---
+name: Trino
+menu: Connecting to Databases
+route: /docs/databases/trino
+index: 28
+version: 1
+---
+
+## Trino
+
+The [sqlalchemy-trino](https://pypi.org/project/sqlalchemy-trino/) library is the recommended way to connect to Trino through SQLAlchemy.
+
+The expected connection string is formatted as follows:
+
+```
+trino://{username}:{password}@{hostname}:{port}/{catalog}
+```
diff --git a/superset-frontend/images/trino.png b/superset-frontend/images/trino.png
new file mode 100644
index 0000000..904db40
Binary files /dev/null and b/superset-frontend/images/trino.png differ