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?