Issue
I have a form on Appmsmith that records data every time there is a submission, but the data is not appearing in my Snowflake DB table. I need help with the query to ensure the data shows up in Snowflake.
Resolution
The first thing to check is that your connection to the datasource is correct. You can look at the Appsmith Snowflake documentation to confirm.
Once you are sure that your connection is good, then you should test your UPDATE query. If the query works well and gets your data into the DB, then you should be all set!
NOTE: If you are a cloud user, you must whitelist the IP addresses 18.223.74.85 and 3.131.104.27 of the Appsmith deployment, as well as your own machine's IP address. See Snowflake's Network Policies docs for more details.