mirror of
https://github.com/apache/superset.git
synced 2026-09-09 08:44:32 +00:00
Compare commits
8
Commits
| Author | SHA1 | Date | |
|---|---|---|---|
|
|
9ce8582717 | ||
|
|
b0f3630d62 | ||
|
|
5c04256c05 | ||
|
|
45d11da815 | ||
|
|
317e80f6a8 | ||
|
|
37d65ef731 | ||
|
|
75e4014ac1 | ||
|
|
fee0f9e160 |
@@ -125,7 +125,6 @@ Here are some of the major database solutions that are supported:
|
||||
<a href="https://superset.apache.org/docs/databases/supported/apache-pinot" title="Apache Pinot"><img src="docs/static/img/databases/apache-pinot.svg" alt="Apache Pinot" width="76" height="40" /></a>
|
||||
<a href="https://superset.apache.org/docs/databases/supported/apache-solr" title="Apache Solr"><img src="docs/static/img/databases/apache-solr.png" alt="Apache Solr" width="79" height="40" /></a>
|
||||
<a href="https://superset.apache.org/docs/databases/supported/apache-spark-sql" title="Apache Spark SQL"><img src="docs/static/img/databases/apache-spark.png" alt="Apache Spark SQL" width="75" height="40" /></a>
|
||||
<a href="https://superset.apache.org/docs/databases/supported/ascend" title="Ascend"><img src="docs/static/img/databases/ascend.webp" alt="Ascend" width="117" height="40" /></a>
|
||||
<a href="https://superset.apache.org/docs/databases/supported/aurora-mysql-data-api" title="Aurora MySQL (Data API)"><img src="docs/static/img/databases/mysql.png" alt="Aurora MySQL (Data API)" width="77" height="40" /></a>
|
||||
<a href="https://superset.apache.org/docs/databases/supported/aurora-postgresql-data-api" title="Aurora PostgreSQL (Data API)"><img src="docs/static/img/databases/postgresql.svg" alt="Aurora PostgreSQL (Data API)" width="76" height="40" /></a>
|
||||
<a href="https://superset.apache.org/docs/databases/supported/azure-data-explorer" title="Azure Data Explorer"><img src="docs/static/img/databases/kusto.png" alt="Azure Data Explorer" width="40" height="40" /></a>
|
||||
|
||||
@@ -202,6 +202,8 @@ before retrying. Preview or recheck failures fail closed rather than treating
|
||||
unknown impact as zero. Chart and dashboard purge endpoints are unchanged.
|
||||
|
||||
- The dashboard datasource-based visibility fallback now fails closed: a dashboard whose member charts’ datasources cannot be resolved (deleted datasource rows, missing `datasource_id`, or unsupported datasource types) is no longer accessible to users without explicit editor/viewer rights, and a dashboard composed of semantic-view charts now requires `datasource_access` on (at least one of) its semantic views or their parent semantic layer — previously any authenticated user could open such a dashboard’s shell. Because the fallback now considers every member chart rather than only table-backed ones, a user holding `datasource_access` on any single member datasource — including a semantic view or its parent layer — can open a mixed dashboard that previously denied them. Dashboards with no charts remain accessible, and dashboards with explicit viewers are unaffected. Conversely, holders of `all_datasource_access` now see every published no-viewer dashboard in the dashboard list — including chart-less ones previously hidden by the inner joins — matching what the object-level gate already allowed them to open.
|
||||
- As the `ascend.io` platform shut down, its DB integration has been removed. Any existing users
|
||||
using `ascend://` DB protocol should switch to compatible `impala://` or preferentially remove the connection.
|
||||
- `SAMPLES_ROW_LIMIT` is now the default for `/datasource/samples` requests without a valid explicit `per_page`, rather than a hard per-request ceiling; explicit limits are honored up to the existing global row-limit ceiling, matching `/chart/data` SAMPLES requests.
|
||||
- The `cockroachdb` extra (`pip install apache-superset[cockroachdb]`) now installs `sqlalchemy-cockroachdb` instead of the abandoned `cockroachdb` package, whose SQLAlchemy dialect could not be imported under SQLAlchemy 2.0. Existing environments with the old package installed should `pip uninstall cockroachdb && pip install sqlalchemy-cockroachdb` (or simply reinstall the extra) to restore CockroachDB connectivity.
|
||||
|
||||
|
||||
@@ -159,7 +159,6 @@ single source of truth. The README.md retains its own static copy
|
||||
<a href="/user-docs/databases/supported/apache-pinot" title="Apache Pinot"><img src="/img/databases/apache-pinot.svg" alt="Apache Pinot" width="76" height="40" /></a>
|
||||
<a href="/user-docs/databases/supported/apache-solr" title="Apache Solr"><img src="/img/databases/apache-solr.png" alt="Apache Solr" width="79" height="40" /></a>
|
||||
<a href="/user-docs/databases/supported/apache-spark-sql" title="Apache Spark SQL"><img src="/img/databases/apache-spark.png" alt="Apache Spark SQL" width="75" height="40" /></a>
|
||||
<a href="/user-docs/databases/supported/ascend" title="Ascend"><img src="/img/databases/ascend.webp" alt="Ascend" width="117" height="40" /></a>
|
||||
<a href="/user-docs/databases/supported/aurora-mysql-data-api" title="Aurora MySQL (Data API)"><img src="/img/databases/mysql.png" alt="Aurora MySQL (Data API)" width="77" height="40" /></a>
|
||||
<a href="/user-docs/databases/supported/aurora-postgresql-data-api" title="Aurora PostgreSQL (Data API)"><img src="/img/databases/postgresql.svg" alt="Aurora PostgreSQL (Data API)" width="76" height="40" /></a>
|
||||
<a href="/user-docs/databases/supported/azure-data-explorer" title="Azure Data Explorer"><img src="/img/databases/kusto.png" alt="Azure Data Explorer" width="40" height="40" /></a>
|
||||
|
||||
@@ -70,7 +70,6 @@
|
||||
"Apache Doris",
|
||||
"Apache Kylin",
|
||||
"Apache Phoenix",
|
||||
"Ascend",
|
||||
"Azure Data Explorer",
|
||||
"Azure Synapse",
|
||||
"ClickHouse",
|
||||
@@ -168,7 +167,6 @@
|
||||
"base"
|
||||
],
|
||||
"Cloud Data Warehouses": [
|
||||
"Ascend",
|
||||
"Azure Synapse",
|
||||
"Cloudflare D1",
|
||||
"Databend",
|
||||
@@ -180,7 +178,6 @@
|
||||
"YugabyteDB"
|
||||
],
|
||||
"Hosted Open Source": [
|
||||
"Ascend",
|
||||
"Cloudflare D1",
|
||||
"Databricks",
|
||||
"Google Sheets",
|
||||
@@ -1741,87 +1738,6 @@
|
||||
"supports_catalog": false,
|
||||
"supports_dynamic_catalog": false
|
||||
},
|
||||
"Ascend": {
|
||||
"time_grains": {
|
||||
"SECOND": true,
|
||||
"FIVE_SECONDS": false,
|
||||
"THIRTY_SECONDS": false,
|
||||
"MINUTE": true,
|
||||
"FIVE_MINUTES": false,
|
||||
"TEN_MINUTES": false,
|
||||
"FIFTEEN_MINUTES": false,
|
||||
"THIRTY_MINUTES": false,
|
||||
"HALF_HOUR": false,
|
||||
"HOUR": true,
|
||||
"SIX_HOURS": false,
|
||||
"DAY": true,
|
||||
"WEEK": true,
|
||||
"WEEK_STARTING_SUNDAY": false,
|
||||
"WEEK_STARTING_MONDAY": false,
|
||||
"WEEK_ENDING_SATURDAY": false,
|
||||
"WEEK_ENDING_SUNDAY": false,
|
||||
"MONTH": true,
|
||||
"QUARTER": true,
|
||||
"QUARTER_YEAR": false,
|
||||
"YEAR": true
|
||||
},
|
||||
"module": "superset.db_engine_specs.ascend",
|
||||
"limit_method": 1,
|
||||
"limit_clause": true,
|
||||
"joins": true,
|
||||
"subqueries": true,
|
||||
"alias_in_select": true,
|
||||
"alias_in_orderby": true,
|
||||
"time_groupby_inline": false,
|
||||
"alias_to_source_column": false,
|
||||
"order_by_not_in_select": true,
|
||||
"expressions_in_orderby": false,
|
||||
"cte_in_subquery": true,
|
||||
"max_column_name": null,
|
||||
"sql_comments": true,
|
||||
"escaped_colons": true,
|
||||
"masked_encrypted_extra": false,
|
||||
"column_type_mapping": false,
|
||||
"function_names": false,
|
||||
"user_impersonation": false,
|
||||
"file_upload": true,
|
||||
"get_extra_table_metadata": false,
|
||||
"dbapi_exception_mapping": false,
|
||||
"custom_errors": false,
|
||||
"dynamic_schema": false,
|
||||
"catalog": false,
|
||||
"dynamic_catalog": false,
|
||||
"ssh_tunneling": true,
|
||||
"query_cancelation": true,
|
||||
"get_metrics": false,
|
||||
"where_latest_partition": false,
|
||||
"expand_data": false,
|
||||
"query_cost_estimation": false,
|
||||
"sql_validation": false,
|
||||
"score": 38,
|
||||
"max_score": 201,
|
||||
"documentation": {
|
||||
"description": "Ascend.io is a data automation platform for building data pipelines.",
|
||||
"logo": "ascend.webp",
|
||||
"homepage_url": "https://www.ascend.io/",
|
||||
"categories": [
|
||||
"Cloud Data Warehouses",
|
||||
"Analytical Databases",
|
||||
"Hosted Open Source"
|
||||
],
|
||||
"pypi_packages": ["impyla"],
|
||||
"connection_string": "ascend://{username}:{password}@{hostname}:{port}/{database}?auth_mechanism=PLAIN;use_ssl=true",
|
||||
"category": "Other Databases"
|
||||
},
|
||||
"engine": "ascend",
|
||||
"engine_name": "Ascend",
|
||||
"engine_aliases": [],
|
||||
"default_driver": null,
|
||||
"supports_file_upload": true,
|
||||
"supports_dynamic_schema": false,
|
||||
"supports_catalog": false,
|
||||
"supports_dynamic_catalog": false
|
||||
},
|
||||
"Aurora MySQL": {
|
||||
"time_grains": {
|
||||
"SECOND": true,
|
||||
|
||||
BIN
Binary file not shown.
|
Before Width: | Height: | Size: 35 KiB |
@@ -50,7 +50,6 @@ are compatible with Superset.
|
||||
| [Apache Pinot](/user-docs/6.0.0/configuration/databases#apache-pinot) | `pip install pinotdb` | `pinot://BROKER:5436/query?server=http://CONTROLLER:5983/` |
|
||||
| [Apache Solr](/user-docs/6.0.0/configuration/databases#apache-solr) | `pip install sqlalchemy-solr` | `solr://{username}:{password}@{hostname}:{port}/{server_path}/{collection}` |
|
||||
| [Apache Spark SQL](/user-docs/6.0.0/configuration/databases#apache-spark-sql) | `pip install pyhive` | `hive://hive@{hostname}:{port}/{database}` |
|
||||
| [Ascend.io](/user-docs/6.0.0/configuration/databases#ascendio) | `pip install impyla` | `ascend://{username}:{password}@{hostname}:{port}/{database}?auth_mechanism=PLAIN;use_ssl=true` |
|
||||
| [Azure MS SQL](/user-docs/6.0.0/configuration/databases#sql-server) | `pip install pymssql` | `mssql+pymssql://UserName@presetSQL:TestPassword@presetSQL.database.windows.net:1433/TestSchema` |
|
||||
| [ClickHouse](/user-docs/6.0.0/configuration/databases#clickhouse) | `pip install clickhouse-connect` | `clickhousedb://{username}:{password}@{hostname}:{port}/{database}` |
|
||||
| [CockroachDB](/user-docs/6.0.0/configuration/databases#cockroachdb) | `pip install cockroachdb` | `cockroachdb://root@{hostname}:{port}/{database}?sslmode=disable` |
|
||||
@@ -188,16 +187,6 @@ Repeat this process for each type of database you want Superset to connect to.
|
||||
|
||||
### Database-specific Instructions
|
||||
|
||||
#### Ascend.io
|
||||
|
||||
The recommended connector library to Ascend.io is [impyla](https://github.com/cloudera/impyla).
|
||||
|
||||
The expected connection string is formatted as follows:
|
||||
|
||||
```
|
||||
ascend://{username}:{password}@{hostname}:{port}/{database}?auth_mechanism=PLAIN;use_ssl=true
|
||||
```
|
||||
|
||||
#### Apache Doris
|
||||
|
||||
The [sqlalchemy-doris](https://pypi.org/project/pydoris/) library is the recommended way to connect to Apache Doris through SQLAlchemy.
|
||||
|
||||
@@ -69,7 +69,6 @@
|
||||
"Apache Doris",
|
||||
"Apache Kylin",
|
||||
"Apache Phoenix",
|
||||
"Ascend",
|
||||
"Azure Data Explorer",
|
||||
"Azure Synapse",
|
||||
"ClickHouse",
|
||||
@@ -165,7 +164,6 @@
|
||||
"base"
|
||||
],
|
||||
"Cloud Data Warehouses": [
|
||||
"Ascend",
|
||||
"Azure Synapse",
|
||||
"Cloudflare D1",
|
||||
"Databend",
|
||||
@@ -177,7 +175,6 @@
|
||||
"YugabyteDB"
|
||||
],
|
||||
"Hosted Open Source": [
|
||||
"Ascend",
|
||||
"Cloudflare D1",
|
||||
"Databricks",
|
||||
"Google Sheets",
|
||||
@@ -1738,87 +1735,6 @@
|
||||
"supports_catalog": false,
|
||||
"supports_dynamic_catalog": false
|
||||
},
|
||||
"Ascend": {
|
||||
"time_grains": {
|
||||
"SECOND": true,
|
||||
"FIVE_SECONDS": false,
|
||||
"THIRTY_SECONDS": false,
|
||||
"MINUTE": true,
|
||||
"FIVE_MINUTES": false,
|
||||
"TEN_MINUTES": false,
|
||||
"FIFTEEN_MINUTES": false,
|
||||
"THIRTY_MINUTES": false,
|
||||
"HALF_HOUR": false,
|
||||
"HOUR": true,
|
||||
"SIX_HOURS": false,
|
||||
"DAY": true,
|
||||
"WEEK": true,
|
||||
"WEEK_STARTING_SUNDAY": false,
|
||||
"WEEK_STARTING_MONDAY": false,
|
||||
"WEEK_ENDING_SATURDAY": false,
|
||||
"WEEK_ENDING_SUNDAY": false,
|
||||
"MONTH": true,
|
||||
"QUARTER": true,
|
||||
"QUARTER_YEAR": false,
|
||||
"YEAR": true
|
||||
},
|
||||
"module": "superset.db_engine_specs.ascend",
|
||||
"limit_method": 1,
|
||||
"limit_clause": true,
|
||||
"joins": true,
|
||||
"subqueries": true,
|
||||
"alias_in_select": true,
|
||||
"alias_in_orderby": true,
|
||||
"time_groupby_inline": false,
|
||||
"alias_to_source_column": false,
|
||||
"order_by_not_in_select": true,
|
||||
"expressions_in_orderby": false,
|
||||
"cte_in_subquery": true,
|
||||
"max_column_name": null,
|
||||
"sql_comments": true,
|
||||
"escaped_colons": true,
|
||||
"masked_encrypted_extra": false,
|
||||
"column_type_mapping": false,
|
||||
"function_names": false,
|
||||
"user_impersonation": false,
|
||||
"file_upload": true,
|
||||
"get_extra_table_metadata": false,
|
||||
"dbapi_exception_mapping": false,
|
||||
"custom_errors": false,
|
||||
"dynamic_schema": false,
|
||||
"catalog": false,
|
||||
"dynamic_catalog": false,
|
||||
"ssh_tunneling": true,
|
||||
"query_cancelation": true,
|
||||
"get_metrics": false,
|
||||
"where_latest_partition": false,
|
||||
"expand_data": false,
|
||||
"query_cost_estimation": false,
|
||||
"sql_validation": false,
|
||||
"score": 38,
|
||||
"max_score": 201,
|
||||
"documentation": {
|
||||
"description": "Ascend.io is a data automation platform for building data pipelines.",
|
||||
"logo": "ascend.webp",
|
||||
"homepage_url": "https://www.ascend.io/",
|
||||
"categories": [
|
||||
"Cloud Data Warehouses",
|
||||
"Analytical Databases",
|
||||
"Hosted Open Source"
|
||||
],
|
||||
"pypi_packages": ["impyla"],
|
||||
"connection_string": "ascend://{username}:{password}@{hostname}:{port}/{database}?auth_mechanism=PLAIN;use_ssl=true",
|
||||
"category": "Other Databases"
|
||||
},
|
||||
"engine": "ascend",
|
||||
"engine_name": "Ascend",
|
||||
"engine_aliases": [],
|
||||
"default_driver": null,
|
||||
"supports_file_upload": true,
|
||||
"supports_dynamic_schema": false,
|
||||
"supports_catalog": false,
|
||||
"supports_dynamic_catalog": false
|
||||
},
|
||||
"Aurora MySQL": {
|
||||
"time_grains": {
|
||||
"SECOND": true,
|
||||
|
||||
@@ -1,86 +0,0 @@
|
||||
---
|
||||
title: Ascend
|
||||
sidebar_label: Ascend
|
||||
description: 'Ascend.io is a data automation platform for building data pipelines.'
|
||||
hide_title: true
|
||||
---
|
||||
|
||||
{/*
|
||||
Licensed to the Apache Software Foundation (ASF) under one
|
||||
or more contributor license agreements. See the NOTICE file
|
||||
distributed with this work for additional information
|
||||
regarding copyright ownership. The ASF licenses this file
|
||||
to you under the Apache License, Version 2.0 (the
|
||||
"License"); you may not use this file except in compliance
|
||||
with the License. You may obtain a copy of the License at
|
||||
|
||||
http://www.apache.org/licenses/LICENSE-2.0
|
||||
|
||||
Unless required by applicable law or agreed to in writing,
|
||||
software distributed under the License is distributed on an
|
||||
"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
|
||||
KIND, either express or implied. See the License for the
|
||||
specific language governing permissions and limitations
|
||||
under the License.
|
||||
*/}
|
||||
|
||||
import { DatabasePage } from '@site/src/components/databases';
|
||||
|
||||
export const databaseInfo = {
|
||||
engine: 'ascend',
|
||||
engine_name: 'Ascend',
|
||||
module: 'ascend',
|
||||
documentation: {
|
||||
description:
|
||||
'Ascend.io is a data automation platform for building data pipelines.',
|
||||
logo: 'ascend.webp',
|
||||
homepage_url: 'https://www.ascend.io/',
|
||||
pypi_packages: ['impyla', 'impyla'],
|
||||
connection_string:
|
||||
'ascend://{username}:{password}@{hostname}:{port}/{database}?auth_mechanism=PLAIN;use_ssl=true',
|
||||
default_port: 21050,
|
||||
categories: [
|
||||
'CLOUD_DATA_WAREHOUSES',
|
||||
'ANALYTICAL_DATABASES',
|
||||
'HOSTED_OPEN_SOURCE',
|
||||
],
|
||||
},
|
||||
time_grains: {
|
||||
SECOND: true,
|
||||
FIVE_SECONDS: false,
|
||||
THIRTY_SECONDS: false,
|
||||
MINUTE: true,
|
||||
FIVE_MINUTES: false,
|
||||
TEN_MINUTES: false,
|
||||
FIFTEEN_MINUTES: false,
|
||||
THIRTY_MINUTES: false,
|
||||
HALF_HOUR: false,
|
||||
HOUR: true,
|
||||
SIX_HOURS: false,
|
||||
DAY: true,
|
||||
WEEK: true,
|
||||
WEEK_STARTING_SUNDAY: false,
|
||||
WEEK_STARTING_MONDAY: false,
|
||||
WEEK_ENDING_SATURDAY: false,
|
||||
WEEK_ENDING_SUNDAY: false,
|
||||
MONTH: true,
|
||||
QUARTER: true,
|
||||
QUARTER_YEAR: false,
|
||||
YEAR: true,
|
||||
},
|
||||
score: 38,
|
||||
max_score: 201,
|
||||
joins: true,
|
||||
subqueries: true,
|
||||
supports_dynamic_schema: false,
|
||||
supports_catalog: false,
|
||||
supports_dynamic_catalog: false,
|
||||
ssh_tunneling: true,
|
||||
supports_file_upload: true,
|
||||
query_cancelation: true,
|
||||
query_cost_estimation: false,
|
||||
sql_validation: false,
|
||||
user_impersonation: false,
|
||||
};
|
||||
|
||||
<DatabasePage name="Ascend" database={databaseInfo} />
|
||||
@@ -159,7 +159,6 @@ single source of truth. The README.md retains its own static copy
|
||||
<a href="/user-docs/databases/supported/apache-pinot" title="Apache Pinot"><img src="/img/databases/apache-pinot.svg" alt="Apache Pinot" width="76" height="40" /></a>
|
||||
<a href="/user-docs/databases/supported/apache-solr" title="Apache Solr"><img src="/img/databases/apache-solr.png" alt="Apache Solr" width="79" height="40" /></a>
|
||||
<a href="/user-docs/databases/supported/apache-spark-sql" title="Apache Spark SQL"><img src="/img/databases/apache-spark.png" alt="Apache Spark SQL" width="75" height="40" /></a>
|
||||
<a href="/user-docs/databases/supported/ascend" title="Ascend"><img src="/img/databases/ascend.webp" alt="Ascend" width="117" height="40" /></a>
|
||||
<a href="/user-docs/databases/supported/aurora-mysql-data-api" title="Aurora MySQL (Data API)"><img src="/img/databases/mysql.png" alt="Aurora MySQL (Data API)" width="77" height="40" /></a>
|
||||
<a href="/user-docs/databases/supported/aurora-postgresql-data-api" title="Aurora PostgreSQL (Data API)"><img src="/img/databases/postgresql.svg" alt="Aurora PostgreSQL (Data API)" width="76" height="40" /></a>
|
||||
<a href="/user-docs/databases/supported/azure-data-explorer" title="Azure Data Explorer"><img src="/img/databases/kusto.png" alt="Azure Data Explorer" width="40" height="40" /></a>
|
||||
|
||||
@@ -128,7 +128,6 @@ Here are some of the major database solutions that are supported:
|
||||
<a href="https://superset.apache.org/docs/databases/supported/apache-pinot" title="Apache Pinot"><img src="docs/static/img/databases/apache-pinot.svg" alt="Apache Pinot" width="76" height="40" /></a>
|
||||
<a href="https://superset.apache.org/docs/databases/supported/apache-solr" title="Apache Solr"><img src="docs/static/img/databases/apache-solr.png" alt="Apache Solr" width="79" height="40" /></a>
|
||||
<a href="https://superset.apache.org/docs/databases/supported/apache-spark-sql" title="Apache Spark SQL"><img src="docs/static/img/databases/apache-spark.png" alt="Apache Spark SQL" width="75" height="40" /></a>
|
||||
<a href="https://superset.apache.org/docs/databases/supported/ascend" title="Ascend"><img src="docs/static/img/databases/ascend.webp" alt="Ascend" width="117" height="40" /></a>
|
||||
<a href="https://superset.apache.org/docs/databases/supported/aurora-mysql-data-api" title="Aurora MySQL (Data API)"><img src="docs/static/img/databases/mysql.png" alt="Aurora MySQL (Data API)" width="77" height="40" /></a>
|
||||
<a href="https://superset.apache.org/docs/databases/supported/aurora-postgresql-data-api" title="Aurora PostgreSQL (Data API)"><img src="docs/static/img/databases/postgresql.svg" alt="Aurora PostgreSQL (Data API)" width="76" height="40" /></a>
|
||||
<a href="https://superset.apache.org/docs/databases/supported/azure-data-explorer" title="Azure Data Explorer"><img src="docs/static/img/databases/kusto.png" alt="Azure Data Explorer" width="40" height="40" /></a>
|
||||
|
||||
@@ -573,12 +573,6 @@ images:
|
||||
alt: Apache Spark SQL
|
||||
source_file: docs/intro.md
|
||||
selector: null
|
||||
- type: database-logo
|
||||
page_url: "https://superset.apache.org/user-docs"
|
||||
image_url: docs/static/img/databases/ascend.webp
|
||||
alt: Ascend
|
||||
source_file: docs/intro.md
|
||||
selector: null
|
||||
- type: database-logo
|
||||
page_url: "https://superset.apache.org/user-docs"
|
||||
image_url: docs/static/img/databases/aws.png
|
||||
@@ -947,13 +941,6 @@ images:
|
||||
alt: Apache Spark SQL
|
||||
source_file: docs/index.mdx
|
||||
selector: null
|
||||
- type: database-logo
|
||||
page_url: "https://superset.apache.org/user-docs"
|
||||
image_url: "https://superset.apache.org/img/databases/ascend.webp"
|
||||
output_path: docs/static/img/databases/ascend.webp
|
||||
alt: Ascend
|
||||
source_file: docs/index.mdx
|
||||
selector: null
|
||||
- type: database-logo
|
||||
page_url: "https://superset.apache.org/user-docs"
|
||||
image_url: "https://superset.apache.org/img/databases/aws.png"
|
||||
|
||||
@@ -59,7 +59,6 @@ These fields should be in every engine spec's `metadata` attribute:
|
||||
| Superset meta database | superset.py | 0% | category, connection_string, description, pypi_packages | default_port, homepage_url, logo |
|
||||
| Apache Drill | drill.py | 51% | connection_string, pypi_packages | default_port |
|
||||
| Amazon Athena | athena.py | 52% | connection_string, pypi_packages | default_port |
|
||||
| Ascend | ascend.py | 60% | ✓ | default_port, homepage_url, logo |
|
||||
| Ocient | ocient.py | 61% | ✓ | default_port, homepage_url, logo |
|
||||
| RisingWave | risingwave.py | 61% | ✓ | default_port, homepage_url, logo |
|
||||
| Arc | arc.py | 62% | ✓ | default_port, homepage_url, logo |
|
||||
|
||||
@@ -101,7 +101,6 @@ The tables below (generated via `python superset/db_engine_specs/lib.py`) summar
|
||||
| SQLite | 41 | Supported | Partial | Supported | Supported | Not supported | Not supported |
|
||||
| Shillelagh | 41 | Supported | Partial | Supported | Supported | Not supported | Not supported |
|
||||
| KustoKQL | 40 | Supported | Partial | Partial | Partial | Partial | Not supported |
|
||||
| Ascend | 38 | Supported | Partial | Supported | Not supported | Partial | Not supported |
|
||||
| DuckDB | 38 | Supported | Partial | Supported | Not supported | Partial | Not supported |
|
||||
| IBM Db2 | 38 | Supported | Partial | Supported | Not supported | Partial | Not supported |
|
||||
| IBM Db2 for i | 38 | Supported | Partial | Supported | Not supported | Partial | Not supported |
|
||||
@@ -149,7 +148,6 @@ The tables below (generated via `python superset/db_engine_specs/lib.py`) summar
|
||||
| Apache Pinot | superset.db_engine_specs.pinot | FORCE_LIMIT | True | None |
|
||||
| Apache Solr | superset.db_engine_specs.solr | FORCE_LIMIT | True | None |
|
||||
| Apache Spark SQL | superset.db_engine_specs.spark | FORCE_LIMIT | True | 767 |
|
||||
| Ascend | superset.db_engine_specs.ascend | FORCE_LIMIT | True | None |
|
||||
| Aurora MySQL (Data API) | superset.db_engine_specs.aurora | FORCE_LIMIT | True | 64 |
|
||||
| Aurora PostgreSQL (Data API) | superset.db_engine_specs.aurora | FORCE_LIMIT | True | 63 |
|
||||
| Azure Synapse | superset.db_engine_specs.mssql | FORCE_LIMIT | True | 128 |
|
||||
@@ -219,7 +217,6 @@ The tables below (generated via `python superset/db_engine_specs/lib.py`) summar
|
||||
| Apache Pinot | False | False | False | False | True | True | True | False | False | True | False |
|
||||
| Apache Solr | False | False | True | True | True | True | True | False | False | True | False |
|
||||
| Apache Spark SQL | True | True | True | True | True | True | True | False | False | False | False |
|
||||
| Ascend | True | True | True | True | True | True | True | False | False | True | False |
|
||||
| Aurora MySQL (Data API) | True | True | True | True | True | True | True | False | False | True | False |
|
||||
| Aurora PostgreSQL (Data API) | True | True | True | True | True | True | True | False | False | True | False |
|
||||
| Azure Synapse | True | True | True | True | False | True | True | False | False | True | False |
|
||||
@@ -289,7 +286,6 @@ The tables below (generated via `python superset/db_engine_specs/lib.py`) summar
|
||||
| Apache Pinot | True | True | True | True | True | True | True | True |
|
||||
| Apache Solr | False | False | False | False | False | False | False | False |
|
||||
| Apache Spark SQL | True | True | True | True | True | True | True | True |
|
||||
| Ascend | True | True | True | True | True | True | True | True |
|
||||
| Aurora MySQL (Data API) | True | True | True | True | True | True | True | True |
|
||||
| Aurora PostgreSQL (Data API) | True | True | True | True | True | True | True | True |
|
||||
| Azure Synapse | True | True | True | True | True | True | True | True |
|
||||
@@ -359,7 +355,6 @@ The tables below (generated via `python superset/db_engine_specs/lib.py`) summar
|
||||
| Apache Pinot | False | False | True | True | True | True | False | False | False | False | False | False | False |
|
||||
| Apache Solr | False | False | False | False | False | False | False | False | False | False | False | False | False |
|
||||
| Apache Spark SQL | False | False | False | False | False | False | False | False | True | False | True | False | False |
|
||||
| Ascend | False | False | False | False | False | False | False | False | False | False | False | False | False |
|
||||
| Aurora MySQL (Data API) | False | False | False | False | False | False | False | False | False | True | False | False | False |
|
||||
| Aurora PostgreSQL (Data API) | True | True | True | True | True | True | False | False | False | False | False | False | False |
|
||||
| Azure Synapse | False | False | True | True | True | True | False | False | True | True | False | False | False |
|
||||
@@ -432,7 +427,6 @@ Integration with platform features and metadata handling.
|
||||
| Apache Pinot | False | False | False | True | False | False | False | True | False | False | False | False | False | False |
|
||||
| Apache Solr | False | False | False | True | False | False | False | True | False | False | False | False | False | False |
|
||||
| Apache Spark SQL | False | True | True | True | True | True | True | True | True | True | False | True | False | False |
|
||||
| Ascend | False | False | False | True | False | False | False | True | False | True | False | False | False | False |
|
||||
| Aurora MySQL (Data API) | False | True | False | True | True | False | False | True | False | True | False | False | False | False |
|
||||
| Aurora PostgreSQL (Data API) | False | True | False | True | True | True | True | True | False | True | False | False | False | False |
|
||||
| Azure Synapse | False | True | False | True | False | False | False | True | False | False | False | False | False | False |
|
||||
@@ -502,7 +496,6 @@ Integration with platform features and metadata handling.
|
||||
| Apache Pinot | False | False | False | False |
|
||||
| Apache Solr | False | False | False | False |
|
||||
| Apache Spark SQL | True | True | True | False |
|
||||
| Ascend | False | False | False | False |
|
||||
| Aurora MySQL (Data API) | False | False | False | False |
|
||||
| Aurora PostgreSQL (Data API) | False | False | True | True |
|
||||
| Azure Synapse | False | False | False | False |
|
||||
|
||||
@@ -1,60 +0,0 @@
|
||||
# Licensed to the Apache Software Foundation (ASF) under one
|
||||
# or more contributor license agreements. See the NOTICE file
|
||||
# distributed with this work for additional information
|
||||
# regarding copyright ownership. The ASF licenses this file
|
||||
# to you under the Apache License, Version 2.0 (the
|
||||
# "License"); you may not use this file except in compliance
|
||||
# with the License. You may obtain a copy of the License at
|
||||
#
|
||||
# http://www.apache.org/licenses/LICENSE-2.0
|
||||
#
|
||||
# Unless required by applicable law or agreed to in writing,
|
||||
# software distributed under the License is distributed on an
|
||||
# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
|
||||
# KIND, either express or implied. See the License for the
|
||||
# specific language governing permissions and limitations
|
||||
# under the License.
|
||||
from sqlalchemy.dialects import registry
|
||||
|
||||
from superset.constants import TimeGrain
|
||||
from superset.db_engine_specs.base import DatabaseCategory
|
||||
from superset.db_engine_specs.impala import ImpalaEngineSpec
|
||||
|
||||
|
||||
class AscendEngineSpec(ImpalaEngineSpec):
|
||||
"""Engine spec for Ascend.io (Hive2+TLS) using Cloudera's Impala"""
|
||||
|
||||
engine = "ascend"
|
||||
registry.register("ascend", "impala.sqlalchemy", "ImpalaDialect")
|
||||
|
||||
engine_name = "Ascend"
|
||||
|
||||
metadata = {
|
||||
"description": (
|
||||
"Ascend.io is a data automation platform for building data pipelines."
|
||||
),
|
||||
"logo": "ascend.webp",
|
||||
"homepage_url": "https://www.ascend.io/",
|
||||
"categories": [
|
||||
DatabaseCategory.CLOUD_DATA_WAREHOUSES,
|
||||
DatabaseCategory.ANALYTICAL_DATABASES,
|
||||
DatabaseCategory.HOSTED_OPEN_SOURCE,
|
||||
],
|
||||
"pypi_packages": ["impyla"],
|
||||
"connection_string": (
|
||||
"ascend://{username}:{password}@{hostname}:{port}/{database}"
|
||||
"?auth_mechanism=PLAIN;use_ssl=true"
|
||||
),
|
||||
}
|
||||
|
||||
_time_grain_expressions = {
|
||||
None: "{col}",
|
||||
TimeGrain.SECOND: "DATE_TRUNC('second', {col})",
|
||||
TimeGrain.MINUTE: "DATE_TRUNC('minute', {col})",
|
||||
TimeGrain.HOUR: "DATE_TRUNC('hour', {col})",
|
||||
TimeGrain.DAY: "DATE_TRUNC('day', {col})",
|
||||
TimeGrain.WEEK: "DATE_TRUNC('week', {col})",
|
||||
TimeGrain.MONTH: "DATE_TRUNC('month', {col})",
|
||||
TimeGrain.QUARTER: "DATE_TRUNC('quarter', {col})",
|
||||
TimeGrain.YEAR: "DATE_TRUNC('year', {col})",
|
||||
}
|
||||
@@ -106,7 +106,6 @@ def _check_script_length(script: str, engine: str | None) -> None:
|
||||
# mapping between DB engine specs and sqlglot dialects
|
||||
SQLGLOT_DIALECTS = {
|
||||
"base": Dialects.DIALECT,
|
||||
"ascend": Dialects.HIVE,
|
||||
"awsathena": Dialects.ATHENA,
|
||||
"bigquery": Dialects.BIGQUERY,
|
||||
"datastore": Dialects.BIGQUERY,
|
||||
|
||||
@@ -1,32 +0,0 @@
|
||||
# Licensed to the Apache Software Foundation (ASF) under one
|
||||
# or more contributor license agreements. See the NOTICE file
|
||||
# distributed with this work for additional information
|
||||
# regarding copyright ownership. The ASF licenses this file
|
||||
# to you under the Apache License, Version 2.0 (the
|
||||
# "License"); you may not use this file except in compliance
|
||||
# with the License. You may obtain a copy of the License at
|
||||
#
|
||||
# http://www.apache.org/licenses/LICENSE-2.0
|
||||
#
|
||||
# Unless required by applicable law or agreed to in writing,
|
||||
# software distributed under the License is distributed on an
|
||||
# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
|
||||
# KIND, either express or implied. See the License for the
|
||||
# specific language governing permissions and limitations
|
||||
# under the License.
|
||||
from superset.db_engine_specs.ascend import AscendEngineSpec
|
||||
from tests.integration_tests.base_tests import SupersetTestCase
|
||||
|
||||
|
||||
class TestAscendDbEngineSpec(SupersetTestCase):
|
||||
def test_convert_dttm(self):
|
||||
dttm = self.get_dttm()
|
||||
|
||||
assert (
|
||||
AscendEngineSpec.convert_dttm("DATE", dttm) == "CAST('2019-01-02' AS DATE)"
|
||||
)
|
||||
|
||||
assert (
|
||||
AscendEngineSpec.convert_dttm("TIMESTAMP", dttm)
|
||||
== "CAST('2019-01-02T03:04:05.678900' AS TIMESTAMP)"
|
||||
)
|
||||
@@ -1878,7 +1878,6 @@ def test_custom_dialect(app: None) -> None:
|
||||
@pytest.mark.parametrize(
|
||||
"engine",
|
||||
[
|
||||
"ascend",
|
||||
"awsathena",
|
||||
"base",
|
||||
"bigquery",
|
||||
|
||||
Reference in New Issue
Block a user