Hi Team,
My team has setup a connection with our NEW Redshift cluster and has provided “select” permissions to the Quicksight User as well as Connection Name. We’re able to import the Redshift Tables as dataset in Quicksight but when we try to connect a Redshift View as dataset to Quicksight, we’re getting attached error whereas this was working well in our OLD cluster. Can you please help us troubleshoot this issue?
Regards,
Chabbil
Hi @chabbils - Did you create a new redshift cluster ( upgrade version) and try to bring views to QuickSight? Looks like there is some issue with the integration. Since the select permission is already there for the user to the view, QS should connect and fetch the data. It will be good to raise a ticket to AWS customer support to diagnostics this problem.
Regards - Sanjeeb
Done @Sanjeeb2022. https://support.console.aws.amazon.com/support/home#/case/?displayId=14428159251&language=en
Actually due to a recent-org change, we migrated everything from an OLD cluster to a NEW cluster. We didn’t upgrade the OLD cluster. I created all the Redshift Tables and Views, which were present in OLD cluster, into NEW cluster.
Thank you @chabbils . AWS team will check this and update you. One request - once the issue will get resolve, please post the solution in this forum so that wider community will get the details.
Thanks in advance.
Regards - Sanjeeb
I got below response from the AWS Quicksight team.
@Sanjeeb2022 I am using amazonbi Quicksight account for my analyses and dashboard. Can you please let me know how can I create a case using amazonbi Quicksight account so that the AWS QS team can try to figure out the issue?
Hello @chabbils and @Sanjeeb2022 !
@chabbils this might require you to have a different support plan:
Here are the steps to open a support case. 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.
Hello @chabbils !
Were you able to create a support case using the link I posted above? Again, it depends on your support plan which your AWS account admin should know.
Hey @chabbils !
Were you able to find a workaround or solution for this?
It has been some time since we have heard from you but would still like to help you find a solution. If we do not hear from you in the next 3 business days this topic will be archived.
Hi @duncan, I opened another AWS Support case for which I received below response but I didn’t get time yet to replicate these steps. I’ll try to follow these steps in next couple of days and will let you know.
Hey @chabbils !
I’m glad they got back to you! For the timing being I will mark this as the solution but please feel free to share if that worked to help the community!
