Troubleshooting Snowflake Connector Unique Identifier Issues

hi I’m currently stuck with the Snowflake connector. I have all the required elements set up, but I’m encountering an issue with the unique identifier (primary key) field. The problem is:

The system requests a unique identifier, but even when I provide one, it fails to validate.
Instead, it prompts me to select an option from a dropdown menu—but the menu appears empty.
I cannot proceed without this selection.

Additionally, when I switch to a different Snowflake user or role, the unique identifier field disappears entirely. Upon attempting to validate without it, I receive the error: "You must specify a uniqueIdentifier." Could you please assist in resolving this validation issue? Let me know if further details are needed. Thank you!

8 comments

Channeled
APP
·
·
The Snowflake integration documentation shows that Upsert Row and Update Row actions use "a single field as a unique identifier" for operations. However, the specific validation issue you're experiencing with empty dropdowns and disappearing fields when switching users/roles isn't covered in our available documentation. This appears to be a technical issue that requires deeper troubleshooting. If you need further help resolving this validation problem, please request human assistance by clicking on "Talk to a person." Which specific Snowflake action are you trying to configure - Upsert Row, Update Row, or another operation?
Sources: Update Row with Snowflake Snowflake integration | Documentation | Clay University Upsert Row with Snowflake
LuisArturo
·
·
Hey there Hector sorry for the delay here, do you mind sending the link (url) to the table so we can take a look?
(52 kB)
Hector L.
·
·
you can check here but we could not connect snowflake to clay to import the table
Hector L.
·
·
https://app.clay.com/workspaces/516733/workbooks/wb_0sx7yw9tkFsECG5BnKn/tables/t_0sx7zfrCwgvCp4fHsmZ/views/gv_0sx7zfsVz9yDYEJxvZX
LuisArturo
·
·
Hey Hector sorry for the delay here, not seeing a table labeled FCT_organization here.
Hector L.
·
Yes indeed. But the issue is we can't create a table based on snowflake. So I don't really what you need to check the issue...
Hector L.
·
·
(fyi we doublechecked the access and compared it to other tools using the same credentials)
Mark L.
·
·
Thanks for sharing this, Hector! I saw my teammate just Tanvi sent a message around this Snowflake challenge. I'll merge this thread into that earlier one, so we can all stay on the same page!