Upload error to new table in schema with quoted, lowercase name containing "/"

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 error to new table in schema with quoted, lowercase name containing "/" #15

Closed daniel-sali closed 3 years ago

daniel-sali commented 3 years ago

Hi,

I'm having issues uploading table data to a new table in a database and schema with a case-sensitive, lowercase quoted name. The names of the database and schema also contain the "/" character, I'm not sure if this is relevant.

The error happens after the "create or replace stage ... " statement is issued to Snowflake.

Upload of the same data succeeds to a database/schema with a case-insensitive, unquoted name.

I'm using version 1.1.10 of the add-in

Could you identify and eliminate the cause? We have a lot of case-sensitive, quoted database object names which we can't change.

Thanks, Daniel

ssegal100 commented 3 years ago

Hi Daniel. Are the column names in the header actually quoted? If so would you try it without the quotes. It should be by default case sensitive. Also, I'm not sure about the "/". I'll have to look at that. Thanks. Steve

daniel-sali commented 3 years ago

Hi, No, the column names are not quoted, this is the data I'm trying to load:

If there is a way I can capture VB error messages, let me know, I'd be happy to check and share logs. Thanks, Daniel

ssegal100 commented 3 years ago

This should be good enough info for me to reproduce. I'll let you know if I need anymore info. What timezone are you in? Steve

daniel-sali commented 3 years ago

I'm in the CET time zone GMT+1.

ssegal100 commented 3 years ago

Daniel, I'm able to upload the worksheet like the one you have. So the table doesn't exist and you are trying to create it with the add-in, right? There's not a simple way to capture the VB error if it's not already throwing one. Are you seeing a pop up with an error message? Can we do a zoom call tomorrow morning so you can walk me through it?

In the History tab in Snowflake, after the 'create stage...' statement, do you not see a 'put...' statement?

daniel-sali commented 3 years ago

Thanks for taking a look, I'm available tomorrow for a zoom call from 9:30 CET. You can contact me directly at daniel.sali >at< alphacruncher.com . I'm getting an error popup, yes, I'd be happy to show you when and how.

Thanks, Daniel

On Wed, Feb 10, 2021 at 6:20 PM Steven Segal notifications@github.com wrote:

Daniel, I'm able to upload the worksheet like the one you have. So the table doesn't exist and you are trying to create it with the add-in, right? There's not a simple way to capture the VB error if it's not already throwing one. Are you seeing a pop up with an error message? Can we do a zoom call tomorrow morning so you can walk me through it?

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/Snowflake-Labs/Excelerator/issues/15#issuecomment-776875150, or unsubscribe https://github.com/notifications/unsubscribe-auth/ADFDA4ISN5VC2YAHDICGNYLS6K55DANCNFSM4XNDCT2Q .

ssegal100 commented 3 years ago

@daniel-sali Please download v 1.1.11 and let me know if that works for you. Thanks. Steve

daniel-sali commented 3 years ago

Hi Steve,

Thank you for the call and the quick fix, I can confirm that I could upload my data to a new table in the database/schema with the quoted name containing "/".

Thanks, Daniel