How can I add parameters to my CosmosDB Data Explorer workbooks?

Question

I have a CosmosDB Data Explorer workbook with a set of functional predefined queries. The workbook offers real benefits by improving efficiency when our organization needs to run some useful queries against when debugging our data/applications. The one draw back is that its prone to failure via user error.

As of now, users need to edit the cells, replacing query values for those that match their needs before running the cells. This is not optimal as it introduces the opportunity that the queries could be broken unintentionally by an unwitting user should they save an erroneous query, hence erasing record of the working query.

I'd like to introduce parameter fields for future users of the workbook to avoid the previously stated scenario. Is that possible?

I'm aware how to do this in Azure Data Studio (ADS) workbooks, but unfortunately can not see the option in Data Explorer, and am unaware of the possibility to connect to CosmosDb from ADS

Answer 1

Hello @Joshua Wheelock ,

Thanks for the ask and using the Microsoft Q&A platform .
At this time, we are reaching out to the internal team to get some help on this . We will update you once we hear back from them.

8/10
Just recieved an update from the internal team and they confimed that this feature is not yet supported .

Thanks
Himanshu

Answer 2

You can use parameters to define inputs to those queries and that can be user defined keeping queries untouched