Updating a Table In Snowflake- Work flow runs for ever and not updating.

Hi Experts,

Please let me give you some information about the situation:

1- I have created a database in Snowflake.

2- I have set up the ODBC connection to upload my data into Snowflake.

3- I have created a new table by using Alteryx, and I have uploaded my data into that table by using the Output tool.

4- I have set a Primary Key field by Altering the table inside the Snowflake, and it is confirmed when I use the input tool, and the yellow key indicates next to the field name.

Now the problem is when I want to update my table with new data after 2 hours (which will be less than 10 rows!), it takes forever, and the workflow does not stop.

I am using "Update: Insert if New" in the Output options selection. Am I doing something wrong? Would you please guide me with this?

Would you please let me know the best practice for updating my data in Snowflake by using Alteryx?

Thank you in advance for your time and help.

Output

Accepted answers

All comments

TrevorS

Hello @VahidGoli

Thank you for posting to the Community.

Are you still having issues with your connection?

If so, can you provide a copy of your workflow so the Community can see what your setup looks like?
Thanks!
TrevorS

ArtApa

Hi @VahidGoli - I suggest you to download and review the Snowflake Starter Kit. It contains not only sample workflows, but also training videos on how to setup connections: https://www.alteryx.com/starter-kit/snowflake

If you will still experience issues you may need to reach out to our support: support@alteryx.com

VahidGoli

Hi @TrevorS and @ArtApa ,

As I tried to explain in my original post, I have no problem connecting my workflows to Snowflake to retrieve data or uploading data into Snowflake. I can use both via ODBC or Bulk. I have watched all the available videos and read all the documents (including StarterKit).

My problem is how I can update my existing tables after initially loading my data into Snowflake?

My tables in all my databases need to be updated daily (say adding 100 new records). Still, there is no option for an update in bulk, and the Update option in ODBC takes ages to update a table with existing 100k records as it seems it goes through all the records to see IF NEW INSERT...

Any idea how I can fix this issue?

Thank you in advance for your help.

tareque

Bumping this question.
Just wondering if any progress has been made with just updating a small number of rows using the Snowflake ODBC quicker.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703