I’m trying to set up snowflake as a storage target, but I’ve had a few problems with the setup.
Initially I got the error:
SnowflakeSQLException: Cannot perform CREATE SCHEMA. This session does not have a current database. Call 'USE DATABASE', or use a qualified name.
So I tried a qualified name for the schema in the snowflake config JSON and now get:
Exception in thread "main" net.snowflake.client.jdbc.SnowflakeSQLException: SQL compilation error: Database 'SNOWPLOW_TEST' does not exist.
Even though I have created the database.
Any suggestions as to what I’m doing wrong?