RDB Loader can't access snowflake after an upgrade

For engineers Storage targets
1

hey guys, I’ve just upgraded all the modules to the latest ones, but the data stopped coming to snowflake.

When I check snowflake loader logs I get this:

INFO com.snowplowanalytics.snowplow.rdbloader: RDB Loader 5.6.0 has started.
INFO HikariPool-1 - Starting...
INFO HikariPool-1 - Start completed.
ERROR Error executing transaction. Sleeping for 30 seconds for the first time
net.snowflake.client.jdbc.SnowflakeSQLException: SQL compilation error:
Warehouse 'SP_PROD_WAREHOUSE' does not exist or not authorized.

I went through prepare destinations steps again just in case, but that did not help. the role and user clearly have access to the warehouse and db, so this is strange we get this error.

did I miss anything? thanks!

2

Ok I solved it, in new version role is not specified in the variables, so I had to assign default role and default warehouse to the snowflake user myself. it all works now :+1: