Error - Materialized view in redshift


Trying to ingest streaming data from kinesis using external schema and materialized views. Getting below error while creating materialized view ERROR: ----------------------------------------------- error: Unable to describe stream code: 42001 Request ID: abc. curlCode: t, Timeout was reached Stream name: stream_name query: -1[child_sequence:1] location: kinesis_client.

IAM role associated with redshift has below permission { "Version": "2012-10-17", "Statement": [ { "Sid": "ReadStream", "Effect": "Allow", "Action": [ "kinesis:DescribeStreamSummary", "kinesis:GetShardIterator", "kinesis:GetRecords", "kinesis:DescribeStream" ], "Resource": "" }, { "Sid": "ListStream", "Effect": "Allow", "Action": [ "kinesis:ListStreams", "kinesis:ListShards" ], "Resource": "" } ] }

1 Answer

You need to specify a particular resource or use * to allow all. I see the * is missing in between the quotes "Resource": "" , or it could be formatting issue.

profile pictureAWS
answered a month ago
profile picture
reviewed a month ago

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