Issue with OpenSearch index not retrieving joined table data via ingestion pipeline

Question

I am currently utilizing OpenSearch Service (specifically OpenSearch Serverless) for indexing data from my application's tables. To manage the indexing process efficiently, I've set up an ingestion pipeline to connect to my table. Within this table, I've employed a join method to link two tables.

However, I've encountered an issue where the data from the joined table is not being retrieved in the OpenSearch index. Despite configuring the ingestion pipeline to index the connected tables, the joined table's data does not appear to be accessible via the OpenSearch endpoint.

Could you kindly provide guidance on how I can ensure that the joined table's data is properly indexed and retrievable through the OpenSearch endpoint?

Answer

Hello,

To understand the issue here it would require to troubleshoot the issue and check the resources involve to troubleshoot further, we require details that are non-public information. Please open a support case with AWS using the following link:

https://console.aws.amazon.com/support/home#/case/create

Issue with OpenSearch index not retrieving joined table data via ingestion pipeline

Relevant content