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

Issue Logging in #42

Closed Rposada closed 1 year ago

Rposada commented 1 year ago

when logging into snowflake; Excelerator first runs these commands bellow.

show databases; WITH databases (a,name,b,c,d,e,f,g,h) as (select * from table(result_scan(last_query_id()))) select name from databases;

it seems there are 10 columns now when declaring "show databases". I am unable to use excelerator and I am getting the error "Mismatch between number of columns produced by 'DATABASES' and the number of aliases specified."

Rposada commented 1 year ago

Easy by updating the getDatabasecombobos Sub: image

ssegal100 commented 1 year ago

Yes, that's the update. This issue occurs when a certain parameter is enabled in the Snowflake account that adds some columns to the view. Another approach is to not use the "Select *" and explicitly get the columns needed. It's more resilient to change that way. I'll see if I made this change in the latest release. Steve

pouj commented 1 year ago

An update was pushed in September 2022 fixing this issue. You'll need to uninstall your addon and reinstall using the latest version.

SuccinctGasca commented 1 year ago

Thanks! This really helps.