I am getting this error message
Your database generated a SQL exception. This can be caused by query timeouts, resource constraints, unexpected DDL alterations before or during a query, and other database errors. Check your database settings and your query, and try again.
Hi @Dafini - Welcome to the community. This error can occur due to various reasons, such as query timeouts, resource constraints, unexpected schema changes, or other database errors. Here are some potential solutions: 1. Check your SQL query for syntax errors, as the error may be caused by an issue in your SQL code. 2. Verify that your database settings and resources are sufficient to handle the query. The error could be due to resource constraints or timeouts on the database side. 3. Ensure that there are no unexpected schema changes or DDL alterations happening before or during the query execution, which could cause the error. If the issue persists, you can try running the SQL query directly in a SQL client tool to identify the root cause.
If the issue still persists. 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. Hope this helps!