SQL Being Generated from New Data Prep Experience Not What is Expected

Hi @TraderRef,

Just checking back in since we haven’t heard from you in a bit. I wanted to see if the guidance shared earlier helped resolve your question, or if you found a solution in the meantime.

Now from what you have said, it sounds like what you are trying to do properly works in the old data prep experience compared to the new experience. Submitting a support ticket could give you some more insight into the type of error you are running into. To do that I would refer to this resource (Case management - AWS Support). Moreover, it should also be noted that the new data prep experience is still new and constantly being improved upon. From my experience, I have run into some bugs and errors that Quick is still ironing out.

So, my recommendation is to use the old data prep experience for the timing being. Quick still gives you access to use the old data prep experience for a reason and you know definitively that what you are trying to do works there.

If you still have any additional questions related to your initial post, feel free to share them. Otherwise, any update you’re able to provide within the next 3 business days would be helpful for the community.

Thank you