Getting the below error, when trying to configure OpenSearch as data source.
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. Show details
Quick Sight can see the domains, but not abl to connect. OpenSearch domain is publicly accessible, so there is no connectivity issue.
Can you please help? Thank you!
Hi @Durga – The SQL exception error when configuring OpenSearch as a data source in Quick Sight could be related to several limitations. Custom SQL isn’t supported when using OpenSearch Service datasets in Quick Sight. Additionally, there are several other limitations when using OpenSearch with Quick Sight, including: multiple subquery operations aren’t supported, cross-dataset joins and self joins aren’t supported, and calculated fields aren’t supported.
Before connecting to OpenSearch Service, ensure that Amazon Quick Sight has been authorized to connect to Amazon OpenSearch Service.
A Quick Sight administrator needs to authorize connections to AWS resources by opening the profile menu, choosing “Manage Quick Sight,” selecting “Security & permissions,” and enabling the option for OpenSearch.
When creating the connection, make sure to properly validate the connection before proceeding.
Source: Using Amazon OpenSearch Service with Amazon QuickSight - Amazon QuickSight