Superset: Permission denied for snowflake database connection

[rapmac13160]

Hi,

Snowflake database connection in Superset suddenly stopped to operate with the following error message:

Error: [Errno 13] Permission denied: '/root/.config/snowflake/config.toml'

This is the same when I try to test the connection in the settings directly.

Thank you in advance.

[nebulon]

Haven't heard of snowflake in the context of databases before, but looks like support for it has to be installed manually. I tried the upstream docs at https://superset.apache.org/docs/configuration/databases#installing-database-drivers to install that via pip but for some reason I can't even get the app to list snowflake as an option. How did you install that?

[girish]

The snowflake driver is already included in the package. The issue appears to be something else.

[girish]

From what I can make out, Snowflake CLI uses config.toml - https://docs.snowflake.com/en/developer-guide/snowflake-cli/connecting/configure-cli . Not sure why superset wants config.toml . Might be a question for the uptsream project?

[rapmac13160]

Hi, do you need any information from me ?

[girish]

@rapmac13160 we don't have experience with snowflake and don't have a set up to test. So, you will have to help us debug this further.

You said "suddenly stopped to operate" . Does this mean it worked before and just stopped working recently? What changed?

[rapmac13160]

Sure. Yes the connection worked well in the past month. I did not check superset for few months and when i connected few days ago, this message appeared. It can possibly be linked to an update of superset.

It was working fine at that time https://forum.cloudron.io/topic/11457/install-prophet-package/10?_=1732531616852

[girish]

@rapmac13160 do you think you can generate some test snowflake credentials / database for us to test? If you can send them to support@cloudron.io, we can test it .

I signed up at snowflake.com but tbh I couldn't make much sense of it. Can't even figure how to set up a database and generate access tokens.

[rapmac13160]

Hi @girish, they are sent to the adress

[girish]

@rapmac13160 thanks, the issue is https://github.com/snowflakedb/snowflake-connector-python/issues/2108 . I have left a note there. I am updating the package with a workaround - https://git.cloudron.io/cloudron/superset-app/-/merge_requests/4

[rapmac13160]

@girish thanks for the investigation, let me know when ok.

[girish]

@rapmac13160 new package is out

[rapmac13160]

@girish it works perfectly fine thanks!

[rapmac13160]

Hi, just did the upgrade of Superset and the error is back

[rapmac13160]

@rapmac13160 Not exactly the same but it seems very similar