Hey everyone, I set up an AWS Redshift database a few years back and built a Java app that connects to it. I haven't used the app for a long time, and now that I've restarted my Redshift cluster, I'm trying to run it again, but it's throwing a connection error. When I checked the Redshift console, it shows that I have zero databases listed. Did my database disappear or expire somehow? Any insights would be appreciated!
3 Answers
Databases in Redshift don't really expire. If you can't find yours, it's likely that the cluster was deleted rather than AWS removing the database. The issue is probably related to your connection settings rather than missing data.
You might want to look at AWS CloudTrail. Filter the logs by Redshift Service to get an idea of what happened with your resources.
Are you sure you're checking the right AWS region? It's possible that you're logged into a different region from where your cluster is hosted.
I think I'm in the right region since I can see the cluster, but it shows zero databases.