因此,我一直试图用我的无服务器后端,即Aurora MySQL来设置一个BI工具。
建筑如下:

在这些行上实现:教程链接
现在,我正在探索如何将这个后端与BI/Analytics工具连接起来,以便快速查询和可视化。
由于我们的后端是Aurora,因此限制将不能直接连接到端点,就像如何处理提供的端点一样。
如前所述:https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-serverless.html
在类似的行中,我正在尝试设置AWS直接连接,该连接目前正处于请求阶段:

我需要帮助是否这是正确的方法,如果是,有任何教程使用直接连接与?
另一方面,是否有人成功地在Serverless后端中使用过bi工具?
需要的是能够在最短的时间内起床和跑步,得到快速的推论。然后转移到ETL或更复杂的用例。
任何帮助都非常感谢!
谢谢你,阿纳布
发布于 2019-03-06 06:17:49
弄明白了。
需要设置企业QuickSight帐户才能连接到私有VPCs。常规的QuickSight帐户期望端点是公开可用的。而无服务器端点则不是。
限制:https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-serverless.html
先决条件:企业QuickSight帐户、Aurora集群,并确保您的集群在创建连接时具有活动容量单位。
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查询来获取数据。
也许以后能帮上忙。
https://stackoverflow.com/questions/54960503
复制相似问题