Thank you for voting for this feature! We are aware of this scenario and are looking into ways of supporting this. In the meantime, stay tuned for an update and please continue voting for this feature.Chris Aiken commented
Often, after scaling, my database refuse to return results from large tables. This is after scaling from DWU100 to DWU 1000 (i.e. going UP in size). The fix I have found is to pause the database, wait 15-30 minutes, then resume the database. I assume this results in the database being reassigned to a new DW cluster.
Overall, I have found scaling to be a tenuous affair -- sometimes it works, sometimes it fails or leaves my database in a state where it basically no longer responds.
Hopefully this is a preview "feature" that will be fixed....Chris Aiken supported this idea ·