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
feita há 2 anos157 visualizações
Sem respostas

Você não está conectado. Fazer login para postar uma resposta.

Uma boa resposta responde claramente à pergunta, dá feedback construtivo e incentiva o crescimento profissional de quem perguntou.

Diretrizes para responder a perguntas