I have a dataset that has been working for couple of months in the backend for my Dashboard that I’ve launched. To resolve a data quality defect, I had to make changes to the query which included
- Remove a Where clause - As simple as it sounds, dataset refresh is failing if I am trying to publish the dataset with just this change.
- Changed a column:
OLD - cal.cal_month_short_desc + ‘-’ + right(trunc(cal_week_begin_date),2) cal_date_short
NEW - right(trunc(cal_week_begin_date),5) cal_date_short
Both the old and new queries are working in Redshift but the new query is throwing below error in QS
sourceErrorMessage: Amazon Invalid operation: syntax error at end of input Position: 16356
sourceErrorState : 42601
sourceException : java.sql.SQLException
sourceType : REDSHIFT
Its quite frustrating that this non-issue is blocking me from deploying critical changes to the dataset. Any help is appreciated
Hi @kcakula - Not a problem. Can you please provide the complete sql which is working in Redshift but not working in Quick Sight. Ideally it should work in QS as well.
Tagging @David_Wong @Max for their suggestion as well.
Regards - Sanjeeb
Hi @Sanjeeb2022, Thank you for the response. Unfortunately, I can’t share the complete query firstly because of internal AWS data team privacy policy, and secondly because its a lengthy one. Can we breakdown the problem for now? Both the changes that I mentioned above are addressing two separate issues that I want to resolve. Removing the where clause should be a straight forward change, I’m curious why is that effecting the dataset refresh when it is running fine when I’m testing in Redshift
Hi @kcakula - Not a problem. In that case can you please raise a ticket to AWS Customer support team so that they can see this issue. Ideally the sql should work in Quick Sight. To raise a ticket, please follow the link - Creating support cases and case management - AWS Support
Hi @Koushik_Muthanna - Can you please help in this case.
Regards - Sanjeeb