10

I am passing some json data to firehose delivery stream which in the end is getting saved into Redshift table. For my use case, I want the data to be stored in different tables.

Do I create different delivery stream for different tables? If I create it that way, there will be data duplication in S3 as the data must go through S3 in order to push data to Redshift using Firehose delivery stream.

John Rotenstein
  • 241,921
  • 22
  • 380
  • 470
user2677679
  • 259
  • 2
  • 12

1 Answers1

12

From the Kinesis Firehose FAQ:

Q: Can a single delivery stream deliver data to multiple Amazon Redshift clusters or tables?

A single delivery stream can only deliver data to one Amazon Redshift cluster and one table currently. If you want to have data delivered to multiple Redshift clusters or tables, you can create multiple delivery streams.

You will need multiple streams.

Community
  • 1
  • 1
GuiSim
  • 7,361
  • 6
  • 40
  • 50