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/03/03 13:56:43 UTC
[superset] branch master updated: chore: Added rockset and firebird
(#13418)
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 26b75fa chore: Added rockset and firebird (#13418)
26b75fa is described below
commit 26b75fadc4bc8a5e351dfd35093eeb8aa0b992f3
Author: Srini Kadamati <sk...@gmail.com>
AuthorDate: Wed Mar 3 08:55:59 2021 -0500
chore: Added rockset and firebird (#13418)
* added URL rerouting from old alerts & reports page to new one
* edited SQL Server, Rockset, db ordering, and link that Superset logo in left corner takes you to
* added Trino logo and firebird connection string and removed bigquery trailing comma
* added ROckset logo
* changed db list ordering for firebird
* tweaked presnetation of firebird connection string
---
docs/gatsby-node.js | 5 +++++
docs/src/components/MainMenu.tsx | 2 +-
docs/src/images/databases/rockset.png | Bin 0 -> 6151 bytes
docs/src/images/databases/trino.png | Bin 0 -> 37493 bytes
docs/src/images/databases/trino2.jpg | Bin 0 -> 36149 bytes
.../docs/Connecting to Databases/firebird.mdx | 24 +++++++++++++++++++++
.../Connecting to Databases/google-bigquery.mdx | 2 +-
.../pages/docs/Connecting to Databases/rockset.mdx | 17 +++++++++++++++
.../docs/Connecting to Databases/sql-server.mdx | 4 ++--
docs/src/pages/index.tsx | 2 +-
docs/src/resources/data.js | 10 +++++++++
11 files changed, 61 insertions(+), 5 deletions(-)
diff --git a/docs/gatsby-node.js b/docs/gatsby-node.js
index 081885d..6c08f6d 100644
--- a/docs/gatsby-node.js
+++ b/docs/gatsby-node.js
@@ -664,4 +664,9 @@ exports.createPages = ({ actions }) => {
toPath: '/docs/miscellaneous/issue-codes#issue-1005',
isPermanent: true,
});
+ createRedirect({
+ fromPath: '/docs/installation/email-reports',
+ toPath: '/docs/installation/alerts-reports',
+ isPermanent: true,
+ });
};
diff --git a/docs/src/components/MainMenu.tsx b/docs/src/components/MainMenu.tsx
index 3255ed3..9ac31cf 100644
--- a/docs/src/components/MainMenu.tsx
+++ b/docs/src/components/MainMenu.tsx
@@ -137,7 +137,7 @@ export default class MainMenu extends React.Component {
const { visible } = this.state;
return (
<Layout.Header css={headerStyle}>
- <a href="https://superset.apache.org">
+ <a href="/">
<img height="50" css={logoStyle} src={logoSvg} alt="logo" />
</a>
<MenuItems toggleDrawer={this.toggleDrawer} mode="horizontal" />
diff --git a/docs/src/images/databases/rockset.png b/docs/src/images/databases/rockset.png
new file mode 100644
index 0000000..c383506
Binary files /dev/null and b/docs/src/images/databases/rockset.png differ
diff --git a/docs/src/images/databases/trino.png b/docs/src/images/databases/trino.png
new file mode 100644
index 0000000..12f3b4d
Binary files /dev/null and b/docs/src/images/databases/trino.png differ
diff --git a/docs/src/images/databases/trino2.jpg b/docs/src/images/databases/trino2.jpg
new file mode 100644
index 0000000..6c6a087
Binary files /dev/null and b/docs/src/images/databases/trino2.jpg differ
diff --git a/docs/src/pages/docs/Connecting to Databases/firebird.mdx b/docs/src/pages/docs/Connecting to Databases/firebird.mdx
new file mode 100644
index 0000000..12bf99c
--- /dev/null
+++ b/docs/src/pages/docs/Connecting to Databases/firebird.mdx
@@ -0,0 +1,24 @@
+---
+name: Firebird
+menu: Connecting to Databases
+route: /docs/databases/firebird
+index: 30
+version: 1
+---
+
+## Firebird
+
+The recommended connector library for Firebird is [sqlalchemy-firebird](https://pypi.org/project/sqlalchemy-firebird/).
+Superset has been tested on `sqlalchemy-firebird>=0.7.0, <0.8`.
+
+The recommended connection string is:
+
+```
+firebird+fdb://{username}:{password}@{host}:{port}//{path_to_db_file}
+```
+
+Here's a connection string example of Superset connecting to a local Firebird database:
+
+```
+firebird+fdb://SYSDBA:masterkey@192.168.86.38:3050//Library/Frameworks/Firebird.framework/Versions/A/Resources/examples/empbuild/employee.fdb
+```
diff --git a/docs/src/pages/docs/Connecting to Databases/google-bigquery.mdx b/docs/src/pages/docs/Connecting to Databases/google-bigquery.mdx
index 63f7454..c6a8aa5 100644
--- a/docs/src/pages/docs/Connecting to Databases/google-bigquery.mdx
+++ b/docs/src/pages/docs/Connecting to Databases/google-bigquery.mdx
@@ -46,7 +46,7 @@ The resulting file should have this structure:
"auth_uri": "...",
"token_uri": "...",
"auth_provider_x509_cert_url": "...",
- "client_x509_cert_url": "...",
+ "client_x509_cert_url": "..."
}
}
```
diff --git a/docs/src/pages/docs/Connecting to Databases/rockset.mdx b/docs/src/pages/docs/Connecting to Databases/rockset.mdx
new file mode 100644
index 0000000..589905b
--- /dev/null
+++ b/docs/src/pages/docs/Connecting to Databases/rockset.mdx
@@ -0,0 +1,17 @@
+---
+name: Rockset
+menu: Connecting to Databases
+route: /docs/databases/rockset
+index: 29
+version: 1
+---
+
+## Rockset
+
+The connection string for Rockset is:
+
+```
+rockset://apikey:{your-apikey}@api.rs2.usw2.rockset.com/
+```
+
+For more complete instructions, we recommend the [Rockset documentation](https://docs.rockset.com/apache-superset/).
diff --git a/docs/src/pages/docs/Connecting to Databases/sql-server.mdx b/docs/src/pages/docs/Connecting to Databases/sql-server.mdx
index 1ee647c..bc87aa3 100644
--- a/docs/src/pages/docs/Connecting to Databases/sql-server.mdx
+++ b/docs/src/pages/docs/Connecting to Databases/sql-server.mdx
@@ -1,5 +1,5 @@
---
-name: SQL Server
+name: Microsoft SQL Server
menu: Connecting to Databases
route: /docs/databases/sql-server
index: 24
@@ -13,5 +13,5 @@ The recommended connector library for SQL Server is [pymssql](https://github.com
The connection string for SQL Server looks like this:
```
-mssql+pymssql://UserName@DB:Password@DB_Host:1433/TestSchema
+mssql+pymssql://<Username>:<Password>@<Host>:<Port-default:1433>/<Database Name>/?Encrypt=yes
```
diff --git a/docs/src/pages/index.tsx b/docs/src/pages/index.tsx
index 5b247cc..43bbdb2 100644
--- a/docs/src/pages/index.tsx
+++ b/docs/src/pages/index.tsx
@@ -361,7 +361,7 @@ const Theme = () => {
title="Integrates with modern databases"
descr={`
Superset can connect to any SQL based datasource
- through SQL Alchemy, including modern cloud native databases
+ through SQLAlchemy, including modern cloud native databases
and engines at petabyte scale.
`}
/>
diff --git a/docs/src/resources/data.js b/docs/src/resources/data.js
index 28e7fdc..aae3b07 100644
--- a/docs/src/resources/data.js
+++ b/docs/src/resources/data.js
@@ -216,6 +216,16 @@ export const Databases = [
imgName: 'sqllite.png',
},
{
+ title: 'Trino',
+ href: 'https://trino.io/',
+ imgName: 'trino2.jpg',
+ },
+ {
+ title: 'Rockset',
+ href: 'https://rockset.com/',
+ imgName: 'rockset.png',
+ },
+ {
title: 'Vertica',
href: 'https://www.vertica.com/',
imgName: 'vertica.png',