search

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

Errors when trying to change the database on upload or query in Snowflake Excelerator #32

Closed troywinsett closed 1 year ago

troywinsett commented 2 years ago

When trying to upload data or even query data in Excel, it prompts me for the database change. I make the change and it asks me to log in again. I do that and get the error message below (must close or hide topmost modal form first).

image

Snowflake Excel Error
ssegal100 commented 2 years ago

Hey Troy. I haven't seen this issue before but I'm happy to help out. The first thing I notice that's off is the name of the schema, it's blank, but the table has 'Test' in it. Any idea on what's going on there? Did you enter 'Test' for the table? Does the user you're logged in with have access the schemas in the DB that you selected?

e16e commented 2 years ago

@ssegal100 I'm the Snowflake SE working with Troy, and he shared his screen with me when he experienced this error (repeatedly).

There is a default db, schema, and table selected when he's prompted to authenticate. This appears to be the first db alphabetically in the account.

Troy then selects the db, "DEMAND_SPREADSHEETS," he's prompted to authenticate again, which is successful. Troy's user account is the owner of the db. When he goes to select the schema, that's when the error appears.

nicolasCreff commented 2 years ago

I have the same since one day. It was working well before. (i work in sysadmin)

ssegal100 commented 2 years ago

@nicolasCreff Did anything change in your environment? Was your operating system or Office/Excel version upgraded?

nicolasCreff commented 2 years ago

Yes i got an update of environment but i don't know what changed. I will try to look later, i have not infinite time to understand the pb. (i try to remove temp folder and to download again ). I tried to put a query directly a got a strange result

nicolasCreff commented 2 years ago

some login information go in C column image

nicolasCreff commented 2 years ago

Hi, For me it's working again, I don't know why. But when i set proxy it's work & ";proxy=:;" I tried before but He don't take the modification, it's was like the complement was in read only That why he don't sucess to save session, and then crash with VBA error. Maybe security policies of office can put .xlam in READ ONLY ?