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

appsmithorg / appsmith

Platform to build admin panels, internal tools, and dashboards. Integrates with 25+ databases and any API.

https://www.appsmith.com

Apache License 2.0

34.6k stars 3.73k forks source link

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

Open laveena-en opened 1 year ago

laveena-en commented 1 year ago

Is there an existing issue for this?

[X] I have searched the existing issues

Description

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

Steps To Reproduce

D&D a select/multi-select widget
Select the Snowflake DS
Choose a table, label and value keys and click on connect data
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 commented 1 year ago

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?