Hey @Yohan_Trindade , we haven’t heard from you in a few days. If you are still having an issue with this let me know, otherwise I can archive the question.
Hello @Yohan_Trindade , as you data backend is Redshift the best option is to check the query log to see the result and error in there
There are two ways of checking the last queries in Redshift:
a) Use STL_QUERY (note that he STL log views only retain approximately two to five days of log history, depending on log usage and available disk space) so you might need to reproduce the error to see it
b) Using the console, here the same applies, only recent queries will be present.
Hope this helps, otherwise I would recommend filing a case with AWS Support where we can dive into the details so that we can help you further. 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.