Can't connect Timestream DB/Table to Quicksight

Question & Answer
1

Currently I am stuck connecting Timestream to Quicksight and I have seemed to exhausted all my avenues for debugging this.

The exact error I get when adding the timestream db in datasets is:

Your database generated a SQL exception. This can be caused by query timeouts, resource constraints, unexpected DDL alterations before or during a query, and other database errors. Check your database settings and your query, and try again. Show details

I tried:

  • Adding timestream into Quicksight permissions
  • Toggling timstream on/off in permissions
  • Deleting “” and having it regenerate.
  • Use the format “{db}/{table}” when connecting.
  • Checked to see if any timestream DBs exist
  • Add data into dbs/tables
  • Check if ANY dbs are able to validate at all.
  • Confirm both the timestream db/table or quicksight to be the same region
  • Deleting my entire Quicksight account and recreating it

But so far nothing seems to work. I have looked into Using Amazon Timestream data with Amazon QuickSight - Amazon QuickSight but I just don’t see what I am doing wrong.

Any help would be appreciated.

1 Like
2

This sounds like an issue that we will need more information to dig into. Here are the steps to open a support case so that we can help you further: Creating support cases and case management - AWS Support. If your company has an internal IT team, you might not have direct access to AWS Support and will need to raise an internal ticket to your IT team. They’ll open an AWS Support case on your behalf…

3

did you ever resolve this? having the same issue in one of our accounts.