Excelerator stopped returning data

[kmeagher1]

Hi all. Three of us were testing the tool and data retrieval was working as expected the first day (we are testing the read-only add-on). Next day, two of us have been experiencing these issues which have not been resolved:

• The connection to Snowflake works initially (using SSO) and they're able to select the schema, table, and columns. When they hit execute, the "Execute SQL" dialog closes and they're back on the current sheet, but data is not retrieved. After waiting some time and no data, one of two things happens: if they click back on either the Query or Connect options, the data will show up in the background on the sheet, as if it was paused and only continues once you select one of the Excelerator options again. Or, the other person still saw no data at all returned no matter what options are selected.
• Also, the Config options look corrupted (it had all fields filled with "E" which was one of the data result column values)
• Could something be happening wrong with the hidden worksheets for the config items? We compared our Trust Center options, but no differences were found. The 3rd person was able to continue getting data with various queries without issue and could not duplicate the same issue. Any ideas?

[ssegal100]

It certainly sounds like your configs are corrupted. Can you start with a fresh sheet and uninstall the plugin completely and then add it back. You can also look at the hidden SnowflakeConfig sheet by right clicking on the bottom tab where the sheet name is and unhide the sheet called SnowflakeConfig, unless that is what you are referring to already. It should look something like this, unless it was overwritten for some reason.

[ssegal100]

This issue occurred because the Addin was opened directly. Instead, open a worksheet and then add the Addin to it.