HELP: How to enable query logging - want to see query being generated for Comos DB

[golfalot]

Expected behaviour dab start --LogLevel Debug would emit queries being generated (posted to /graphql)

dab --version
Microsoft.DataApiBuilder 1.2.11+c7ca8db8558a63919c530e454c8f18b45d5b931c

Things I've looked for / tried

• No logging options in schema - https://github.com/Azure/data-api-builder/blob/v1.2.11/schemas/dab.draft.schema.json
• dab start --LogLevel Trace only emits Debug level
• "host": {"mode": "development" }

Thanks
Tim

[golfalot]

Am I possibly not seeing a query because there isn't one generated because ReadItemAsync is being used ? ref: #2399

[sourabh1007]

I don't think, you can see the query generated by DAB and for point operation like above, dab doesn't even generate the query.

[golfalot]

It sure would be helpful / reassuring to observe the execution plan in the debug output where I'd like to see either the query or the point operation(s) being executed.

In my current use case it's about pre-empting performance / RU consumption at the design stage for the solution we intend to deploy using dab.

I certainly foresee a situation where such logging would be highly valuable for troubleshooting after deployment too if Cosmos usage costs get high.

There is no Logger currently available in CosmosQueryEngine.cs to emit the debug messages I'd like to see.

[JerryNixon]

Would including the query in the logs introduce a possible security issue?

[golfalot]

Good thinking! We'd need to redact the literals from the query, much easier for point queries than SQL... Certainly an interim solution to simply indicate whether point or SQL is being used for Cosmos would be great.