This is an automated email from the ASF dual-hosted git repository.
catpineapple pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris-website.git
The following commit(s) were added to refs/heads/master by this push:
new f8b894895a2 quicksight docs (#3078)
f8b894895a2 is described below
commit f8b894895a24c8a6fe8d3b1390e595e89b80ab51
Author: catpineapple <[email protected]>
AuthorDate: Wed Nov 12 14:01:56 2025 +0800
quicksight docs (#3078)
## Versions
- [x] dev
- [ ] 4.x
- [x] 3.x
- [ ] 2.1
## Languages
- [x] Chinese
- [x] English
## Docs Checklist
- [ ] Checked by AI
- [ ] Test Cases Built
---
docs/ecosystem/bi/powerbi.md | 4 +-
docs/ecosystem/bi/quicksight.md | 59 +++++++++++++++------
.../current/ecosystem/bi/powerbi.md | 4 +-
.../current/ecosystem/bi/quicksight.md | 59 +++++++++++++++------
.../version-3.x/ecosystem/bi/powerbi.md | 4 +-
.../version-3.x/ecosystem/bi/quicksight.md | 59 +++++++++++++++------
.../quicksight/ASnSCopmkPwncLbB5FXZcEc7xn3.png | Bin 0 -> 42122 bytes
.../quicksight/Cm8EbaeoIoYDeAxGDR8cuSFhns1.png | Bin 0 -> 341890 bytes
.../quicksight/DlJobTycDoqhDOxdUtCcqZCxnkc.png | Bin 0 -> 99580 bytes
.../quicksight/DoVOMbQTxBrRBpx3Bbgn2gcUXLd.png | Bin 0 -> 152289 bytes
.../quicksight/LAFXbSSnwop5C7xn3kPcEcBZnmc.png | Bin 0 -> 73437 bytes
.../quicksight/MXgObQbdDoLBVTxBrRBcUpx3n2g.png | Bin 0 -> 244207 bytes
.../quicksight/Pjf5bRheroLmtKxcZ2PcFYMkn7d.png | Bin 0 -> 71069 bytes
.../quicksight/RN4fbtJU5o89gQxePQKcOGRBnyh.png | Bin 0 -> 69275 bytes
.../quicksight/XngnbqKxhouZHIxgVYhcyta5n3f.png | Bin 0 -> 83677 bytes
versioned_docs/version-3.x/ecosystem/bi/powerbi.md | 4 +-
.../version-3.x/ecosystem/bi/quicksight.md | 59 +++++++++++++++------
17 files changed, 184 insertions(+), 68 deletions(-)
diff --git a/docs/ecosystem/bi/powerbi.md b/docs/ecosystem/bi/powerbi.md
index c3fb6c2c8f6..9a7f9cea5b9 100644
--- a/docs/ecosystem/bi/powerbi.md
+++ b/docs/ecosystem/bi/powerbi.md
@@ -96,7 +96,7 @@ check `(Not Recommended) Allow any extension to load without
validation or warni
-1. Click `OK`, then restart Power BI Desktop.
+Click `OK`, then restart Power BI Desktop.
### Find the Doris connector
@@ -105,7 +105,7 @@ check `(Not Recommended) Allow any extension to load
without validation or warni
-1. Click "Get Data" and select the Doris database in the pop-up window.
+3. Click "Get Data" and select the Doris database in the pop-up window.
diff --git a/docs/ecosystem/bi/quicksight.md b/docs/ecosystem/bi/quicksight.md
index f40c7ecdc97..59907328aea 100644
--- a/docs/ecosystem/bi/quicksight.md
+++ b/docs/ecosystem/bi/quicksight.md
@@ -5,31 +5,60 @@
}
---
-## Introduction
-QuickSight is a robust data visualization and analysis platform that
seamlessly integrates data computation with visually appealing charts. It does
not necessitate programming skills from users, as data insights can be quickly
obtained through simple drag-and-drop operations. QuickSight offers a diverse
range of viewing options for exploring data from various perspectives.
Furthermore, it facilitates easy integration of multiple data sources,
simplifying and streamlining the process of p [...]
+QuickSight can connect to Apache Doris via the official MySQL data source in
Directly query or Import mode
-## Data configuration
+## Prerequisites
-1. Upon completing the registration process, please proceed to sign in to
QuickSight and choose the desired dataset.
+- Apache Doris version must be no less than 3.1.2
+- Network connectivity (VPC, security group configuration) needs to be
configured according to the Doris deployment environment to ensure that AWS
servers can access your Doris cluster.
+- Run the following SQL on the MySQL client that connects to Doris to adjust
the declared MySQL compatibility version:
- 
+ ```sql
+ SET GLOBAL version = '8.3.99';
+ ```
+ Verification result:
+ ```sql
+ mysql> show variables like "version";
+ +---------------+--------+---------------+---------+
+ | Variable_name | Value | Default_Value | Changed |
+ +---------------+--------+---------------+---------+
+ | version | 8.3.99 | 5.7.99 | 1 |
+ +---------------+--------+---------------+---------+
+ 1 row in set (0.01 sec)
+ ```
-2. Select MySQL on the dataset selection page.
+## Connect QuickSight to Apache Doris
- 
+First, visit
[https://quicksight.aws.amazon.com](https://quicksight.aws.amazon.com/),
navigate to Datasets, and click "New dataset":
-3. On the data connection page, fill in the corresponding IP, port, database
name, username, and password for Doris. After filling in the information, click
"Verify the Connection". If the test is successful, create a data source.
+
- 
+
-4. Select the table for which you want to create the dashboard.
+Search for the official MySQL connector bundled with QuickSight (named simply
**MySQL**):
- 
+
-5. QuickSight offers two methods for importing tables. You can choose the
appropriate import method based on your needs.
+Specify your connection details. Note that the MySQL interface port defaults
to 9030, which may vary depending on your FE `query_port` configuration.
- 
+
-6. After importing the table, you can create the desired dashboard.
+Now, you can select a table from the list:
- 
+
+
+Additionally, you can specify a custom SQL to fetch your data:
+
+
+
+It is recommended to choose the "Directly query" mode:
+
+
+
+Additionally, by clicking "Edit/Preview data", you should be able to view the
internal table structure or adjust the custom SQL, and you can adjust the
dataset here:
+
+
+
+Now, you can proceed to publish the dataset and create new visualizations!
+
+
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/ecosystem/bi/powerbi.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/ecosystem/bi/powerbi.md
index 6d40b31b1e0..412cad01f3f 100644
--- a/i18n/zh-CN/docusaurus-plugin-content-docs/current/ecosystem/bi/powerbi.md
+++ b/i18n/zh-CN/docusaurus-plugin-content-docs/current/ecosystem/bi/powerbi.md
@@ -96,7 +96,7 @@ Microsoft Power BI 可以从 Apache Doris 查询或加载到内存数据。
-1. 选择 `ok` ，然后重启 Power BI Desktop。
+选择 `ok` ，然后重启 Power BI Desktop。
### 查找 Doris 连接器
@@ -105,7 +105,7 @@ Microsoft Power BI 可以从 Apache Doris 查询或加载到内存数据。
-1. 点击获取数据，在弹出窗口中选择 Doris 数据库
+3. 点击获取数据，在弹出窗口中选择 Doris 数据库
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/ecosystem/bi/quicksight.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/ecosystem/bi/quicksight.md
index ab367e4df9d..06a186acb62 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/ecosystem/bi/quicksight.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/ecosystem/bi/quicksight.md
@@ -5,31 +5,60 @@
}
---
-## QuickSight 介绍
-QuickSight
是一个强大的数据可视化分析平台，致力于将数据计算与美观的图表完美融合。它不要求用户具备编程技能，仅需通过拖放操作，就能迅速获取数据洞察。QuickSight
提供了多种视图选项，方便用户从不同角度探索数据。此外，它还支持轻松整合多个数据源，使得数据展示、探索和分析变得更加简单高效。这个平台不仅让数据处理变得快捷，还使分析过程更加直观和易于理解，极大地提升了用户的工作效率和分析能力。
+QuickSight 可以通过官方 MySQL 数据源以 Directly query 或 Import 模式连接到 Apache Doris
-## 数据配置
+## 前提条件
-1. 注册账号后登录 QuickSight，然后选择数据集。
+- Apache Doris 版本要求不低于 3.1.2
+- 网络连通性（VPC、安全组配置），需要结合 Doris 部署环境进行配置，以保证 AWS 服务器能访问到你的 Doris 集群。
+- 在连接到 Doris 的 MySQL client 上运行如下 SQL 来调整声明 MySQL 的兼容版本 ：
- 
+ ```sql
+ SET GLOBAL version = '8.3.99';
+ ```
+ 校验结果：
+ ```sql
+ mysql> show variables like "version";
+ +---------------+--------+---------------+---------+
+ | Variable_name | Value | Default_Value | Changed |
+ +---------------+--------+---------------+---------+
+ | version | 8.3.99 | 5.7.99 | 1 |
+ +---------------+--------+---------------+---------+
+ 1 row in set (0.01 sec)
+ ```
-2. 在数据集选择的页面中选择 MySQL。
+## 将 QuickSight 连接到 Apache Doris
- 
+首先，访问
[https://quicksight.aws.amazon.com](https://quicksight.aws.amazon.com/)，导航到数据集并点击“新建数据集”：
-3. 在数据连接页面中填写对应 Doris 的 IP、端口、数据库名称、登录的用户名和密码。填写后点击连接测试，测试成功后创建链接。
+
- 
+
-4. 创建数据源之后选择需要产生看板的表。
+搜索 QuickSight 捆绑的官方 MySQL 连接器（仅命名为 **MySQL**）：
- 
+
-5. QuickSight 有两种导入表的方式，可以根据自己的需求选择对应的导入方式。
+指定您的连接详细信息。请注意，MySQL 接口端口默认为 9030，具体取决于您的 Fe `query_port` 配置可能会有所不同。
- 
+
-6. 导入表之后，即可以创建所需要的看板。
+现在，您可以从列表中选择一个表：
- 
+
+
+此外，您可以指定一个自定义 SQL 来获取您的数据：
+
+
+
+这里推荐您选择 “Directly query” 模式：
+
+
+
+此外，通过点击 “Edit/Preview data”，您应该能够看到内部结构的表结构或调整自定义 SQL ，并且可以在此处进行 数据集的调整：
+
+
+
+现在，您可以继续发布数据集并创建新的可视化！
+
+
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/ecosystem/bi/powerbi.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/ecosystem/bi/powerbi.md
index 5d03789fbbb..6698a6556e3 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/ecosystem/bi/powerbi.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/ecosystem/bi/powerbi.md
@@ -96,7 +96,7 @@ Microsoft Power BI 可以从 Apache Doris 查询或加载到内存数据。
-1. 选择 `ok` ，然后重启 Power BI Desktop。
+选择 `ok` ，然后重启 Power BI Desktop。
### 查找 Doris 连接器
@@ -105,7 +105,7 @@ Microsoft Power BI 可以从 Apache Doris 查询或加载到内存数据。
-1. 点击获取数据，在弹出窗口中选择 Doris 数据库
+3. 点击获取数据，在弹出窗口中选择 Doris 数据库
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/ecosystem/bi/quicksight.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/ecosystem/bi/quicksight.md
index ab367e4df9d..06a186acb62 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/ecosystem/bi/quicksight.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/ecosystem/bi/quicksight.md
@@ -5,31 +5,60 @@
}
---
-## QuickSight 介绍
-QuickSight
是一个强大的数据可视化分析平台，致力于将数据计算与美观的图表完美融合。它不要求用户具备编程技能，仅需通过拖放操作，就能迅速获取数据洞察。QuickSight
提供了多种视图选项，方便用户从不同角度探索数据。此外，它还支持轻松整合多个数据源，使得数据展示、探索和分析变得更加简单高效。这个平台不仅让数据处理变得快捷，还使分析过程更加直观和易于理解，极大地提升了用户的工作效率和分析能力。
+QuickSight 可以通过官方 MySQL 数据源以 Directly query 或 Import 模式连接到 Apache Doris
-## 数据配置
+## 前提条件
-1. 注册账号后登录 QuickSight，然后选择数据集。
+- Apache Doris 版本要求不低于 3.1.2
+- 网络连通性（VPC、安全组配置），需要结合 Doris 部署环境进行配置，以保证 AWS 服务器能访问到你的 Doris 集群。
+- 在连接到 Doris 的 MySQL client 上运行如下 SQL 来调整声明 MySQL 的兼容版本 ：
- 
+ ```sql
+ SET GLOBAL version = '8.3.99';
+ ```
+ 校验结果：
+ ```sql
+ mysql> show variables like "version";
+ +---------------+--------+---------------+---------+
+ | Variable_name | Value | Default_Value | Changed |
+ +---------------+--------+---------------+---------+
+ | version | 8.3.99 | 5.7.99 | 1 |
+ +---------------+--------+---------------+---------+
+ 1 row in set (0.01 sec)
+ ```
-2. 在数据集选择的页面中选择 MySQL。
+## 将 QuickSight 连接到 Apache Doris
- 
+首先，访问
[https://quicksight.aws.amazon.com](https://quicksight.aws.amazon.com/)，导航到数据集并点击“新建数据集”：
-3. 在数据连接页面中填写对应 Doris 的 IP、端口、数据库名称、登录的用户名和密码。填写后点击连接测试，测试成功后创建链接。
+
- 
+
-4. 创建数据源之后选择需要产生看板的表。
+搜索 QuickSight 捆绑的官方 MySQL 连接器（仅命名为 **MySQL**）：
- 
+
-5. QuickSight 有两种导入表的方式，可以根据自己的需求选择对应的导入方式。
+指定您的连接详细信息。请注意，MySQL 接口端口默认为 9030，具体取决于您的 Fe `query_port` 配置可能会有所不同。
- 
+
-6. 导入表之后，即可以创建所需要的看板。
+现在，您可以从列表中选择一个表：
- 
+
+
+此外，您可以指定一个自定义 SQL 来获取您的数据：
+
+
+
+这里推荐您选择 “Directly query” 模式：
+
+
+
+此外，通过点击 “Edit/Preview data”，您应该能够看到内部结构的表结构或调整自定义 SQL ，并且可以在此处进行 数据集的调整：
+
+
+
+现在，您可以继续发布数据集并创建新的可视化！
+
+
diff --git
a/static/images/ecomsystem/quicksight/ASnSCopmkPwncLbB5FXZcEc7xn3.png
b/static/images/ecomsystem/quicksight/ASnSCopmkPwncLbB5FXZcEc7xn3.png
new file mode 100644
index 00000000000..04f37e3c0b6
Binary files /dev/null and
b/static/images/ecomsystem/quicksight/ASnSCopmkPwncLbB5FXZcEc7xn3.png differ
diff --git
a/static/images/ecomsystem/quicksight/Cm8EbaeoIoYDeAxGDR8cuSFhns1.png
b/static/images/ecomsystem/quicksight/Cm8EbaeoIoYDeAxGDR8cuSFhns1.png
new file mode 100644
index 00000000000..4621b7a90d7
Binary files /dev/null and
b/static/images/ecomsystem/quicksight/Cm8EbaeoIoYDeAxGDR8cuSFhns1.png differ
diff --git
a/static/images/ecomsystem/quicksight/DlJobTycDoqhDOxdUtCcqZCxnkc.png
b/static/images/ecomsystem/quicksight/DlJobTycDoqhDOxdUtCcqZCxnkc.png
new file mode 100644
index 00000000000..7fc12e2128d
Binary files /dev/null and
b/static/images/ecomsystem/quicksight/DlJobTycDoqhDOxdUtCcqZCxnkc.png differ
diff --git
a/static/images/ecomsystem/quicksight/DoVOMbQTxBrRBpx3Bbgn2gcUXLd.png
b/static/images/ecomsystem/quicksight/DoVOMbQTxBrRBpx3Bbgn2gcUXLd.png
new file mode 100644
index 00000000000..3ca7fbeb136
Binary files /dev/null and
b/static/images/ecomsystem/quicksight/DoVOMbQTxBrRBpx3Bbgn2gcUXLd.png differ
diff --git
a/static/images/ecomsystem/quicksight/LAFXbSSnwop5C7xn3kPcEcBZnmc.png
b/static/images/ecomsystem/quicksight/LAFXbSSnwop5C7xn3kPcEcBZnmc.png
new file mode 100644
index 00000000000..23a57ae9326
Binary files /dev/null and
b/static/images/ecomsystem/quicksight/LAFXbSSnwop5C7xn3kPcEcBZnmc.png differ
diff --git
a/static/images/ecomsystem/quicksight/MXgObQbdDoLBVTxBrRBcUpx3n2g.png
b/static/images/ecomsystem/quicksight/MXgObQbdDoLBVTxBrRBcUpx3n2g.png
new file mode 100644
index 00000000000..2ca20287a99
Binary files /dev/null and
b/static/images/ecomsystem/quicksight/MXgObQbdDoLBVTxBrRBcUpx3n2g.png differ
diff --git
a/static/images/ecomsystem/quicksight/Pjf5bRheroLmtKxcZ2PcFYMkn7d.png
b/static/images/ecomsystem/quicksight/Pjf5bRheroLmtKxcZ2PcFYMkn7d.png
new file mode 100644
index 00000000000..6c17f480f8e
Binary files /dev/null and
b/static/images/ecomsystem/quicksight/Pjf5bRheroLmtKxcZ2PcFYMkn7d.png differ
diff --git
a/static/images/ecomsystem/quicksight/RN4fbtJU5o89gQxePQKcOGRBnyh.png
b/static/images/ecomsystem/quicksight/RN4fbtJU5o89gQxePQKcOGRBnyh.png
new file mode 100644
index 00000000000..c6bd2d9455f
Binary files /dev/null and
b/static/images/ecomsystem/quicksight/RN4fbtJU5o89gQxePQKcOGRBnyh.png differ
diff --git
a/static/images/ecomsystem/quicksight/XngnbqKxhouZHIxgVYhcyta5n3f.png
b/static/images/ecomsystem/quicksight/XngnbqKxhouZHIxgVYhcyta5n3f.png
new file mode 100644
index 00000000000..49015ae6544
Binary files /dev/null and
b/static/images/ecomsystem/quicksight/XngnbqKxhouZHIxgVYhcyta5n3f.png differ
diff --git a/versioned_docs/version-3.x/ecosystem/bi/powerbi.md
b/versioned_docs/version-3.x/ecosystem/bi/powerbi.md
index c3fb6c2c8f6..9a7f9cea5b9 100644
--- a/versioned_docs/version-3.x/ecosystem/bi/powerbi.md
+++ b/versioned_docs/version-3.x/ecosystem/bi/powerbi.md
@@ -96,7 +96,7 @@ check `(Not Recommended) Allow any extension to load without
validation or warni
-1. Click `OK`, then restart Power BI Desktop.
+Click `OK`, then restart Power BI Desktop.
### Find the Doris connector
@@ -105,7 +105,7 @@ check `(Not Recommended) Allow any extension to load
without validation or warni
-1. Click "Get Data" and select the Doris database in the pop-up window.
+3. Click "Get Data" and select the Doris database in the pop-up window.
diff --git a/versioned_docs/version-3.x/ecosystem/bi/quicksight.md
b/versioned_docs/version-3.x/ecosystem/bi/quicksight.md
index f40c7ecdc97..59907328aea 100644
--- a/versioned_docs/version-3.x/ecosystem/bi/quicksight.md
+++ b/versioned_docs/version-3.x/ecosystem/bi/quicksight.md
@@ -5,31 +5,60 @@
}
---
-## Introduction
-QuickSight is a robust data visualization and analysis platform that
seamlessly integrates data computation with visually appealing charts. It does
not necessitate programming skills from users, as data insights can be quickly
obtained through simple drag-and-drop operations. QuickSight offers a diverse
range of viewing options for exploring data from various perspectives.
Furthermore, it facilitates easy integration of multiple data sources,
simplifying and streamlining the process of p [...]
+QuickSight can connect to Apache Doris via the official MySQL data source in
Directly query or Import mode
-## Data configuration
+## Prerequisites
-1. Upon completing the registration process, please proceed to sign in to
QuickSight and choose the desired dataset.
+- Apache Doris version must be no less than 3.1.2
+- Network connectivity (VPC, security group configuration) needs to be
configured according to the Doris deployment environment to ensure that AWS
servers can access your Doris cluster.
+- Run the following SQL on the MySQL client that connects to Doris to adjust
the declared MySQL compatibility version:
- 
+ ```sql
+ SET GLOBAL version = '8.3.99';
+ ```
+ Verification result:
+ ```sql
+ mysql> show variables like "version";
+ +---------------+--------+---------------+---------+
+ | Variable_name | Value | Default_Value | Changed |
+ +---------------+--------+---------------+---------+
+ | version | 8.3.99 | 5.7.99 | 1 |
+ +---------------+--------+---------------+---------+
+ 1 row in set (0.01 sec)
+ ```
-2. Select MySQL on the dataset selection page.
+## Connect QuickSight to Apache Doris
- 
+First, visit
[https://quicksight.aws.amazon.com](https://quicksight.aws.amazon.com/),
navigate to Datasets, and click "New dataset":
-3. On the data connection page, fill in the corresponding IP, port, database
name, username, and password for Doris. After filling in the information, click
"Verify the Connection". If the test is successful, create a data source.
+
- 
+
-4. Select the table for which you want to create the dashboard.
+Search for the official MySQL connector bundled with QuickSight (named simply
**MySQL**):
- 
+
-5. QuickSight offers two methods for importing tables. You can choose the
appropriate import method based on your needs.
+Specify your connection details. Note that the MySQL interface port defaults
to 9030, which may vary depending on your FE `query_port` configuration.
- 
+
-6. After importing the table, you can create the desired dashboard.
+Now, you can select a table from the list:
- 
+
+
+Additionally, you can specify a custom SQL to fetch your data:
+
+
+
+It is recommended to choose the "Directly query" mode:
+
+
+
+Additionally, by clicking "Edit/Preview data", you should be able to view the
internal table structure or adjust the custom SQL, and you can adjust the
dataset here:
+
+
+
+Now, you can proceed to publish the dataset and create new visualizations!
+
+
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
