By using AWS re:Post, you agree to the Terms of Use

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?

No Answers

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions