Snowflake check does not verify permissions correctly

[sherifnada]

Expected Behavior

I expect the snowflake destination to check upfront whether the credentials I input have the correct permissions.

Current Behavior

a snowflake sync is succeeding credentials check but failing sync with the following stack trace

2021-01-21 22:27:16 ERROR (/tmp/workspace/6/0) LineGobbler(voidCall):69 - Exception in thread "main" net.snowflake.client.jdbc.SnowflakeSQLException: SQL compilation error:
2021-01-21 22:27:16 ERROR (/tmp/workspace/6/0) LineGobbler(voidCall):69 - Schema 'AIRBYTE_SCHEMA' already exists, but current role has no privileges on it. If this is unexpected and you cannot resolve this problem, contact your system administrator. ACCOUNTADMIN role may be required to manage the privileges on the object.
2021-01-21 22:27:16 ERROR (/tmp/workspace/6/0) LineGobbler(voidCall):69 - at net.snowflake.client.jdbc.SnowflakeUtil.checkErrorAndThrowExceptionSub(SnowflakeUtil.java:124)
2021-01-21 22:27:16 ERROR (/tmp/workspace/6/0) LineGobbler(voidCall):69 - at net.snowflake.client.jdbc.SnowflakeUtil.checkErrorAndThrowException(SnowflakeUtil.java:64)
2021-01-21 22:27:16 ERROR (/tmp/workspace/6/0) LineGobbler(voidCall):69 - at net.snowflake.client.core.StmtUtil.pollForOutput(StmtUtil.java:434)
2021-01-21 22:27:16 ERROR (/tmp/workspace/6/0) LineGobbler(voidCall):69 - at net.snowflake.client.core.StmtUtil.execute(StmtUtil.java:338)
2021-01-21 22:27:16 ERROR (/tmp/workspace/6/0) LineGobbler(voidCall):69 - at net.snowflake.client.core.SFStatement.executeHelper(SFStatement.java:501)
2021-01-21 22:27:16 ERROR (/tmp/workspace/6/0) LineGobbler(voidCall):69 - at net.snowflake.client.core.SFStatement.executeQueryInternal(SFStatement.java:229)
2021-01-21 22:27:16 ERROR (/tmp/workspace/6/0) LineGobbler(voidCall):69 - at net.snowflake.client.core.SFStatement.executeQuery(SFStatement.java:167)
2021-01-21 22:27:16 ERROR (/tmp/workspace/6/0) LineGobbler(voidCall):69 - at net.snowflake.client.core.SFStatement.execute(SFStatement.java:749)
2021-01-21 22:27:16 ERROR (/tmp/workspace/6/0) LineGobbler(voidCall):69 - at net.snowflake.client.jdbc.SnowflakeStatementV1.executeInternal(SnowflakeStatementV1.java:292)
2021-01-21 22:27:16 ERROR (/tmp/workspace/6/0) LineGobbler(voidCall):69 - at net.snowflake.client.jdbc.SnowflakeStatementV1.execute(SnowflakeStatementV1.java:342)
2021-01-21 22:27:16 ERROR (/tmp/workspace/6/0) LineGobbler(voidCall):69 - at io.airbyte.db.jdbc.JdbcDatabase.lambda$execute$0(JdbcDatabase.java:50)
2021-01-21 22:27:16 ERROR (/tmp/workspace/6/0) LineGobbler(voidCall):69 - at io.airbyte.db.jdbc.DefaultJdbcDatabase.execute(DefaultJdbcDatabase.java:57)
2021-01-21 22:27:16 ERROR (/tmp/workspace/6/0) LineGobbler(voidCall):69 - at io.airbyte.db.jdbc.JdbcDatabase.execute(JdbcDatabase.java:50)
2021-01-21 22:27:16 ERROR (/tmp/workspace/6/0) LineGobbler(voidCall):69 - at io.airbyte.integrations.destination.jdbc.DefaultSqlOperations.createSchemaIfNotExists(DefaultSqlOperations.java:43)

Steps to Reproduce

1. Use a role which doesn't have access credentials to the current schema
2. 💣

Severity of the bug for you

Medium

Airbyte Version

@michel-tricot will update