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

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/

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