Getting sql search query limit error on azure cosmos db for mongo db when trying to search through multiple fields

Question

{"level":"info","message":"error while searching alerts: MongoServerError: Error=2, Details='Response status code does not indicate success: BadRequest (400); Substatus: 0; ActivityId: ; Reason: ({"errors":[{"severity":"Error","location":{"start":0,"end":60},"code":"SC3020","message":"The SQL query text exceeded the maximum limit of 524288 characters."}]});

Answer 1

Based on the documentation, Azure Cosmos DB supports querying items using SQL. The following table describes restrictions in query statements, for example in terms of number of clauses or query length.

You can increase any of these SQL query limits by creating an Azure Support request.