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ビュー
回答なし

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ