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