Error - Materialized view in redshift

Question

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

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.

Error - Materialized view in redshift

Contenuto pertinente