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!