Snowflake Insert/Update Error "Primary Key required for update option"

[akihirokomatsu]

Hi all -

Having some issues updating a Snowflake database by inserting/updating records based on a primary key. Getting this error below:

My set up: 

I have set a primary key in the Snowflake DB "PRIMARY_KEY", using the statement:

ALTER TABLE [TABLE NAME] ADD PRIMARY KEY (PRIMARY_KEY);

I have the same field "PRIMARY_KEY" in my Alteryx DB that I am using to write to the Snowflake table.

My output options are:

I am using the Snowflake Driver ODBC Driver 2.23.2

Is there anything I can do to fix this? Thanks!

[emilyforeman]

I am experiencing the same issue-- any luck?

[apathetichell]

I'm super curious about this one - because Snowflake doesn't even enforce Primary Keys! I'll take a look into it and see what I see (I use the DSII driver)

also see this thread:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Output-Data-Tool-update-insert-if-new/...