Snowflake-Labs / Excelerator

This is an Excel Addin for Windows that reads and writes data to Snowflake
Apache License 2.0
78 stars 22 forks source link

Upload Not Working #41

Closed trelmthorf8 closed 1 year ago

trelmthorf8 commented 1 year ago

Hello,

I downloaded the Excelerator for writebacks on May 16 (for Windows) The Worksheet Version Number is 7. The version # in the Configuration popup window is 1.1.19 Excel Version 2208

After modifying a cell and specifying a primary key column, then clicking UPLOAD, the following happens:

image

image

In Snowflake's Activity page I can see the stage is created successfully and the PUT is successful. I am not able to access the Excelerator Log tab - clicking UNHIDE doesn't reveal it, and when I create the tab myself and run the select & upload my LOG tab doesn't get populated.

Thanks for your help!

ssegal100 commented 1 year ago

Hi @trelmthorf8. Are you able to do a 'Put' command using the CLI from the same machine that is running Excel? I'm wondering if there is a network issue.

trelmthorf8 commented 1 year ago

Success when repeating the setup on a different PC where I am more familiar with the network and security setup. I agree, most likely a network issue, possibly a security issue. Thanks for your help!

ssegal100 commented 1 year ago

Great, thanks for the follow up.