devops - 带有AWS QuickSight的AWS Aurora Serverless(MySQL)

Closed. This question does not meet Stack Overflow guidelines。它当前不接受答案。












想改善这个问题吗？更新问题，以便将其作为on-topic用于堆栈溢出。

去年关闭。



Improve this question




因此，我一直在尝试使用无服务器后端(即Aurora MySQL)设置BI工具。

架构如下:



在这些行上的实现:tutorial-link

现在，我正在探索用于将此后端与BI / Analytics工具连接以实现快速查询和可视化目的的选项。

由于我们的后端是Aurora MySQL Serverless，因此其局限性在于无法像使用预配置的那样直接连接到终结点。

如此处所述:https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-serverless.html

同样，我正在尝试设置一个AWS Direct Connect，目前处于请求阶段:



无论这是正确的方法，我都需要帮助，如果是，是否有任何有关将Direct Connect与Aurora Serverless结合使用的教程？

另一方面，是否有任何双工具成功地用于无服务器后端。

需要的是能够在最短的时间内启动并运行，以进行快速推断。然后转到ETL或更复杂的用例。

任何帮助，不胜感激!

谢谢，
Arnab

最佳答案

想通了。

需要设置一个企业QuickSight帐户才能连接到专用VPC。常规的QuickSight帐户希望端点可以公开使用。而无服务器端点不是。

限制:https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-serverless.html

先决条件:企业QuickSight帐户，Aurora无服务器群集，并在创建连接时确保您的群集具有 Activity 的容量单位。

    Step 1: In QuickSight, choose your profile icon at the top right of the screen, then choose "Manage QuickSight". From the menu at left, choose "Manage VPC connections".

    Step 2: Choose "Add VPC connection" to add a new VPC connection.

    Step 3: For "VPC connection name", type a unique descriptive name. This name doesn't need to be an actual VPC ID or name.

    Step 4: Type the subnet ID for Subnet ID, and type the group ID for Security group ID. Make sure that the subnet and the security group are in the same VPC. Also, make sure you are accessing a VPC that is in the same AWS Region where you are creating Amazon QuickSight analyses. You can't use Amazon QuickSight in one AWS Region to connect to a subnet and security group that are in a different AWS Region.

    Important note: Please make sure the Security group you use for the VPC connection has access to the Security group used by your Aurora Serverless cluster and vice versa.

    Step 5: Review your choices, then choose "Create".

    Step 6: Create a new Aurora Data source

    Step 7: For the "Connection Type" option choose your newly created VPC connection from the drop down.

    Step 8 Fill out the rest of the details on for the connection and click "Create Data Source".

现在，您应该能够选择要在分析中使用的表，或者编写自定义SQL查询来获取数据。

也许将来会帮助某人。