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 QuickSight could be related to several limitations. Custom SQL isn’t supported when using OpenSearch Service datasets in QuickSight. Additionally, there are several other limitations when using OpenSearch with QuickSight, 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 QuickSight has been authorized to connect to Amazon OpenSearch Service.
A QuickSight administrator needs to authorize connections to AWS resources by opening the profile menu, choosing “Manage QuickSight,” 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