Curious to see if anyone has experienced our issue. We are connecting a feathery form to a table in a Snowflake data warehouse via Zapier. We have configured both Feathery and our connection to Snowflake properly. The issue is in our mappings Visually we see that we have mapped properly. However, when we test run we get the following error message:
Failed to create a row in Snowflake
Failed: {"message":"Failed: DML operation to table xxxxxx.xxxxx.FEATHERYFORMSUBMIT failed on column LASTMODIFIEDDATETIME with error: Timestamp 'xxxxxxx@gmail.com' is not recognized"}
Zapier is shifting or swapping a field to incorrectly write to another field. At first it seemed it was shifting data from one field to write to the field that immediately followed. However, we have seen the gap greater than that; they are not adjacent to each other.
It’s only a two step zap, a feathery form completion and the zap to write to the snowflake table.
We processed a test run and selected a test record in the first step. We mapped the selected fields we needed and visually confirmed that they are in fact properly mapped, name to name, email to email, etc., five fields in all. Each time we run it we get the same error and visually can’t see anything we did that would trip it.
Thanks.
