Maximum Number of Parameters in Databricks SQL Queries

[rumfox]

Hello Databricks Community,

I'm working with Databricks SQL and encountered an issue when passing a large number of parameters in a query. Specifically, I attempted to pass 493 parameters, but I received the following error message:

BAD_REQUEST : Too many parameters: 493 parameters were given but the limit is 256

This suggests that Databricks has a limit on the number of parameters that can be passed in a single query. However, I've previously used Impala, which successfully handled over 500 parameters without any issues.

Can anyone confirm if Databricks SQL indeed has a limit of 256 parameters? If so, are there any workarounds or alternative approaches to handle more parameters in a single query? Any guidance would be appreciated.

Thank you!

[szymon_dybczak]

Hi @rumfox ,

I would assume there is such a limit, the error is pretty clear. But the weird thing is, I cannot find any mention in documentation about it 

[rumfox]

Hi Slash. 

Thank you for the helpful responses and insights regarding the parameter limit issue I encountered. Your guidance has been invaluable in understanding the constraints and potential workarounds in Databricks SQL. I'm grateful for the support and expertise shared through your responses.

Best regards,