By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

Access Timestream table data from Redshift

0

Hi,

What is the easiest way of accessing data held in a Timestream table from a provisioned Redshift cluster (e.g. to run SQL queries against this table and combine this with other data stored with Redshift itself)?

Can I use a federated query for this? I am assuming Spectrum is not suitable in this case as the data isn't held in S3.

Thanks,

Topics
AnalyticsDatabase
Tags
AnalyticsAmazon RedshiftAmazon Timestream
Language
English
cgddrd
asked 7 months ago374 views
1 Answer
0

Hi,

You will need to run the queries using Amazon Athena as Redshift can´t access TimeStream. You will need to setup Athena to TimeStream connector and Athena to Redshift connector.

Link with the corresponding documentation: https://docs.aws.amazon.com/athena/latest/ug/connectors-available.html

Bests!

profile pictureAWS
acmanjon
answered 7 months ago
profile pictureAWS
EXPERT
Didier_Durand
reviewed 7 months ago
  • Didier_Durand EXPERT
    7 months ago

    Yes, the Athena TimeStream connector is probably the right way to go to extract the data that you need before processing it.

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content