Using Timestream as a dataset for QuickSight (Domain: ap-southeast-2)

0

Hi, I'm trying to use my Timestream DB as a dataset for QuickSight BI. Both of them are in the ap-southeast-2 domain, but Timestream is not on the list. (Please find the attached screenshot). The only way I can make this work is by changing the domain to us-east-1,2. Is there any solution to this??screenshot
Enter image description here

2 回答
0

HI,

As of till date , Quicksight doesnt have a direct connection with Timestream DB. However you can leverage Athena(Serverless SQL Service) in between to Integrate Timestream and Quicksight. Once you go to Athena you can create a connector(Via Lambda) to your data source Timestream DB . Then you can make Athena as the source for your Quicksight for Dashboards and reporting. This Feature of Athena is called as federated query

Ref Flow Architecture:-

Timestream ---> Athena(Federated Query via Lambda Connectors) ----> Quicksight

Few useful links for your reference :-

Lambda Connector Template for Timestream in Athena (Github Source) - https://github.com/awslabs/aws-athena-query-federation (Go to athena-timestream)

Documentation - https://docs.aws.amazon.com/athena/latest/ug/connectors-timestream.html

Reference Blog - https://aws.amazon.com/blogs/big-data/query-any-data-source-with-amazon-athenas-new-federated-query/

AWS
已回答 2 年前
0

Hello User-1450233,

Just to clarify, Timestream as a direct datasource in QuickSight is not yet available in ap-southeast-2 and ap-northeast-1 regions. This is something we are working on.

However, in all other regions where Timestream is available (refer pricing page), you can use Timestream as a direct datasource in QuickSight.

While we are working on this, you can consider alternative approaches like the one suggested above.

Stay tuned for updates.

Raju

AWS
专家
RajuAWS
已回答 1 年前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则