Unable to create dataset using Redshift (auto-discover)

[dimplenr]

Unable to create dataset using Redshift (auto-discover)

Main objective - Create a QuickSight dashboard which displays data from jira fields
What I have done -

1. I exported data from my jira project in a CSV and dumped that CSV into an S3 bucket.
2. Created a Redshift table using the above data in S3
3. Did all the settings from “Authorizing connections from Amazon QuickSight to Amazon Redshift clusters - Amazon QuickSight” and “redshift-vpc-access
   Configuring the VPC connection in the QuickSight console - Amazon QuickSight”
4. Still not able to create the dataset.
   
   

[Naveed]

Hi

check your permission, most of the issue of setting the permission. Recheck it will work.

Secondary, you can use Athena to do this.

Regards,
Naveed Ali

[Brett]

Hi @dimplenr,
It’s been awhile since we last heard from you, did you have any additional questions regarding your initial topic?

If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.

Thank you!

[Brett]

Hi @dimplenr,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!