[Bug]: One click binding is failing with Snowflake datasource on select/multi-select widget

[laveena-en]

Is there an existing issue for this?

• I have searched the existing issues

Description

One click binding is failing with Snowflake datasource with select/multi-select widget

Steps To Reproduce

1. D&D a select/multi-select widget
2. Select the Snowflake DS
3. Choose a table, label and value keys and click on connect data
4. Notice that the flow fails

Public Sample App

No response

Environment

Production

Issue video log

https://www.loom.com/share/ee8ceb1468214ac6b81251f58cee12ca?sid=a1298c31-7aa6-4ed7-8e86-1a3e044f296d

Version

Production

[HajaAsmath]

This issue occurs only when the size of the table which is being loaded is huge.
When binding a table to a select widget, if the query takes more time to execute. It fails due to timeout, The default timeout for a query is 10000ms. This can be increased in the query settings to fix the issue or the data has to be loaded in batches.

Can I take up this issue?