Skip to content

Problems with the new data preparation experience in Quick Suite

0

With the new Quicksight update, I've noticed that when creating a dataset from S3, the error is INTERNAL_SERVICE_ERROR. Enter image description here

In my data preparation, I included a simple action to convert string data to decimal. I tried deleting this step, but it still produces the same error. Enter image description here

Interestingly, if I try loading the same file by pressing "Switch back to legacy experience" and manually convert the same columns to the Decimal data type, it works and is quite fast. The problem is with the new version.

Opinions, any help you can offer me

asked a year ago598 views

3 Answers
0

The issue you're experiencing with the new data preparation experience in Amazon Quick Sight (part of Amazon Quick Suite) appears to be related to the recently released visual data preparation feature.

Amazon Quick Sight recently launched a new data preparation experience that allows business users to perform advanced data transformations without writing complex code. This includes operations like cleaning, transforming, and combining data in multi-step workflows. While this new feature is designed to make data preparation more accessible, it seems you're encountering an INTERNAL_SERVICE_ERROR when trying to use it with S3 data sources.

Your workaround of switching back to the legacy experience is a good temporary solution. Since the legacy experience is working correctly for your decimal conversions, you might want to continue using it until this issue is resolved.

For this specific error, you might want to try the following:

  1. Verify that your S3 data source permissions are correctly configured
  2. Check if the data format is compatible with the new experience
  3. Try simplifying your transformation workflow initially, then gradually add complexity
  4. If you're using boolean fields in your dataset, ensure they're properly formatted as the new experience might handle them differently

If the problem persists, you might need to contact AWS Support as this could be related to the recent rollout of the new data preparation experience. The INTERNAL_SERVICE_ERROR suggests there might be an issue on the service side rather than with your specific configuration.
Sources
Amazon Quick Sight announces the general availability of a new data preparation experience - AWS
Quicksight Boolean issue | AWS re:Post
Transform and visualize your data preparation flow in Amazon Quick Sight without SQL | AWS Business Intelligence Blog
Reimagine business intelligence: Amazon QuickSight evolves to Amazon Quick Suite | AWS Business Intelligence Blog

answered a year ago

0

We will look into this issue and give you a response by Nov 7th.

AWS

answered a year ago

0

@SGuzman We would like to investigate further. Can you create an AWS support ticket and share your S3 manifest file used for this connection?

AWS

answered a year ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.