Unable to see Glue catalog tables from Redshift serverless

0

I created glue catalog external schema on Redshift serverless .Both Glue and redshift are in same location .


create external schema dojo from data catalog database 'stream' iam_role 'arn:aws:iam::XXX'


I successfully created schema but tables under 'stream' catalog database aren't getting listed .

-Above Role which i associated to serverless redshift trusted relationship:

{

"Version": "2012-10-17",

"Statement": [
    {

        "Effect": "Allow",
        "Principal": {
            "Service": [
                "redshift-serverless.amazonaws.com",
                "redshift.amazonaws.com"
            ]
        },
        "Action": "sts:AssumeRole"
    }
]

}

policies: -AmazonS3FullAccess -AWSGlueConsoleFullAccess -AmazonRedshiftAllCommandsFullAccess

I have gone through below question but i couldn't find the solution. https://repost.aws/questions/QU6YMBY70wT0mLSVviOkkQLw/redshift-external-schema

Then i created same ext schema on redshift provisioned with respective role , then im able too see tables in stream catalog database.

  • I have the same issue with the catalog tables not showing up in Athena, are you able to resolve the issue?

Guna
질문됨 2년 전157회 조회
답변 없음

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인