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 查看次数
没有答案

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则