I am loading data from an existing data source and I am getting the followng error.
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.
Details:
| region: |
us-east-1 |
| timestamp: |
1747588151214 |
| requestId: |
f7a120d3-4889-4260-96dd-8a5ad4073512 |
| sourceErrorCode: |
0 |
| sourceErrorMessage: |
ERROR: Current user is not authenticated with IAM credentials. |
| sourceErrorState: |
XX000 |
| sourceException: |
spaceneedlejarjar.redshift21.com.amazon.redshift.util.RedshiftException |
Hi Kirajos, according to the error message, it seems an access control error. Please refer to this page, check if Quicksight use a proper role or use Redshift credentials to access the source cluster.
If the issue remain unresolved, please create a support case from the account that this error occurred. AWS support engineer will be able to check internal parameters and error to guide you what’s missing. Thanks.
Hi @kirajos
It’s been a while since we last heard from you. If you have any further questions, please let us know how we can assist you.
If we don’t hear back within the next 3 business days, we’ll proceed with close/archive this topic.
Thank you!
Hi @kirajos - Welcome to AWS QuickSight community and thanks for posting the question. Is it possible to provide more information about your data sets.
- What is the data source , is it redshift?
- Are you using the custom SQL to get the data?
- If yes, can you please run the sql by connecting redshift directly ( using any client tool) and see how much time it is taking to give the result.
- If the sql is not tuned or poor performing, you may observe timeout issue and in that case QS is not able to fetch the data. By default the timeout value for a direct query is 2 Mins ( not 100% sure although)
Regards - Sanjeeb
Hi @kirajos
Since we have not heard back from you, I’ll go ahead and close/archive this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information.
Thank you!