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": ""
}
]
}