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 Respuesta
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 hace un mes
profile picture
EXPERTO
revisado hace un mes

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas