search

Snowflake-Labs / Excelerator

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

Support encryption key size 256 #27

Closed miro-licek closed 2 years ago

miro-licek commented 3 years ago

After we have updated CLIENT_ENCRYPTION_KEY_SIZE to 256 (from 128 default) users were not able to decrypt data from stage when using Excelerator. All other tools work well. According to documentation change could have affected only JDBC drivers, not ODBC. the actual error message from SF logs is: "Failed to decrypt. Check file key and master key." Excelerator can still connect and read data, but not write/update. Could you please look at that? I tried searching through the VBA but could not find anything which would help.

Thank you

Miro

ssegal100 commented 3 years ago

Miro, Do the other tools that work use the ODBC driver? Can you test with the ODBC driver another way? Steve

ssegal100 commented 3 years ago

Miro, I was told that you should open a support case for this. While the Excelerator is not a Snowflake supported product, the ODBC driver is. So make sure you open it for that. Please let me know the case number and I'll follow it and answer any questions as needed. Steve

ssegal100 commented 2 years ago

@miro-licek Did you open a support ticket and was it resolved? Thanks.

miro-licek commented 2 years ago

Thx for following up. It was connected with encryption key size . When we extended it to 256 it affected loading into stage with ODBC which it shouldn't. We are following up with SF support. You can close this issue on your side. Thx