Error - Materialized view in redshift

0

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 Resposta
0

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
respondido há um mês
profile picture
ESPECIALISTA
avaliado há um mês

Você não está conectado. Fazer login para postar uma resposta.

Uma boa resposta responde claramente à pergunta, dá feedback construtivo e incentiva o crescimento profissional de quem perguntou.

Diretrizes para responder a perguntas