I have this kinesis firehose delivery stream to s3 and redshift. While I want to continue putting the data to s3 but I want to temporarily stop sending data to redshift. One trick is to change the database table name. But that is not very sophisticated as request is still being made. I was wondering if there is any other way to stop sending data to redshift.
Unfortunately I don't think there is. I've usually resorted to renaming the table, like you mentioned.