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!