We are using data share table from different redshift account in our redshift account. we created external schemas in redshift for those data shared tables. When I am trying to access those tables, they are not visible under that schemas. If I write sql I am able to query it in quicksight but those table are not visible under that schema. how can I resolve this ?
From the screenshot it looks like the metadata is not being fetched.
I would recommend to log a support ticket .
Here are the steps for opening a support ticket - Creating support cases and case management - AWS Support . If your company has someone who manages your AWS account, you might not have direct access to AWS Support and will need to raise an internal ticket to your IT team or whomever manages your AWS account. They should be able to open an AWS Support case on your behalf
Kind regards,
Koushik
Thanks for reply Koushik. I will open ticket with AWS. Also we are able to query this table in quicksight by writing custom sql only thing we are not able to see under dropdown. also all other tools like tableau , data grip we can see those tables.